Getting issue while creating Phoenix View for my scenario.
CREATE view IF NOT EXISTS Test (
0.CustomerName VARCHAR,
0.LocationName VARCHAR,
0.ReferringPhysicianKey VARCHAR,
0.ExamKey VARCHAR
CONSTRAINT PK PRIMARY KEY (CustomerName,LocationName,ExamKey)
);
Getting Error as below.
Primary key
If use a zero byte instead of a |, then you can create your view with a
four column primary key without any issues. If a value is not present, make
sure to still include the null byte separator.
Thanks,
James
On Thursday, June 11, 2015, Nishant Patel nishant.k.pa...@gmail.com wrote:
Thanks
Yes. Will try same thing. If value is not there it is including null byte.
Let me try with all these changes.
Thanks,
Nishant
On Jun 12, 2015 12:23 PM, James Taylor jamestay...@apache.org wrote:
If use a zero byte instead of a |, then you can create your view with a
four column primary key
Hi All,
I have hbase table where rowkey is composite key of 4 columns.
Rowkey Example:
qualifier1|qualifier2|qualifier3|qualifier4
I want to create phoenix table mapping this hbase table. I always receive
qualifier1, qualifier2 and qualifier3 as filter condition in query.
How can I map