Hi NIshant,
Have you seen this:
https://phoenix.apache.org/faq.html#How_I_map_Phoenix_table_to_an_existing_HBase_table
Your row key is a byte[] in HBase. It has no column qualifier, so you
wouldn't want to prefix those columns with any column family.
Thanks,
James
On Sun, Jun 14, 2015 at 11:58 PM, Nishant Patel
<nishant.k.pa...@gmail.com> wrote:
> 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
