Hi James, Thanks for your response. It is working now.
Regards, Nishant On Mon, Jun 15, 2015 at 11:33 PM, James Taylor <[email protected]> wrote: > 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 > <[email protected]> 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 > -- Regards, Nishant Patel
