Mapping existing hbase table with phoenix view/table

[Nishant Patel]

Hi,

I have create one table in Hbase. My hbase rowkey is combination of
multiple qualifier. I tried multiple things but nothing working as per my
expectation.

Case 1:

CREATE view IF NOT EXISTS EICIPERFORMANCE1 (
pk VARCHAR PRIMARY KEY,
"0"."CustomerName" VARCHAR,
"0"."LocationName" VARCHAR,
"0"."ExamKey" VARCHAR
);

Results : Only pk column has data, reaming columns has only NULL values.

Case 2:

CREATE view IF NOT EXISTS EICIPERFORMANCE1 (
"0"."CustomerName" VARCHAR,
"0"."LocationName" VARCHAR,
"0"."FacilityName" VARCHAR,
"0"."ExamKey" VARCHAR,
CONSTRAINT PK PRIMARY KEY (CustomerName,"LocationName","ExamKey")
);


Result : It give me Error as - Error: ERROR 504 (42703): Undefined column.
columnName=EICIPERFORMANCE1.CUSTOMERNAME (state=42703,code=504)

Case 3:

CREATE view IF NOT EXISTS EICIPERFORMANCE1 (
"0"."CustomerName" VARCHAR,
"0"."LocationName" VARCHAR,
"0"."FacilityName" VARCHAR,
"0"."ExamKey" VARCHAR,
CONSTRAINT PK PRIMARY KEY ("CustomerName","LocationName","ExamKey")
);

Result : It gives error as - Error: ERROR 1003 (42J01): Primary key columns
must not have a family name. columnName=EICIPERFORMANCE1.0.CustomerName
(state=42J01,code=1003)

Not sure whether I am missing anything.

Thanks,
Nishant