Firas, I have the follow table in hbase:
hbase(main):032:0> scan 'test' ROW COLUMN+CELL row1 column=cf:a, timestamp=1397068853016, value=value1 row2 column=cf:b, timestamp=1397068857098, value=value2 row3 column=cf:c, timestamp=1397068861755, value=value3 When a try to create table using Phoenix, use the command: CREATE table "test" ( pk VARCHAR PRIMARY KEY, "cf"."val" VARCHAR ); The result is : *PK* * val* row1 <null> row2 <null> row3 <null> Could you help me? Thank you. Kleiton On Tue, Apr 8, 2014 at 6:19 AM, Firas Khasawneh <[email protected]>wrote: > Thanks Pankaj! > > > > *From:* Pankaj kr [mailto:[email protected]] > *Sent:* Tuesday, April 08, 2014 12:50 AM > > *To:* [email protected] > *Subject:* RE: Basic mapping to HBase table > > > > Hi Firas, > > > > Phoenix doesn't work with Accumulo. > > > > > Kindly check the below link for more details, > > http://phoenix.incubator.apache.org/ > > Cheers, > > Pankaj > > > > > > *From:* Firas Khasawneh > [mailto:[email protected]<[email protected]>] > > *Sent:* 07 April 2014 20:46 > *To:* [email protected] > *Subject:* RE: Basic mapping to HBase table > > > > Hi all, > > > > Does phoenix work only with HBase or does it also work with Accumulo? > > > > Thanks, > > Firas > > > > *From:* Pankaj kr [mailto:[email protected] <[email protected]>] > *Sent:* Monday, April 07, 2014 9:15 AM > *To:* [email protected] > *Subject:* RE: Basic mapping to HBase table > > > > Hi Daniel, > > > > You mapped the HBase table using the below statement, > > CREATE VIEW "t1" ( pk VARCHAR > PRIMARY KEY, "f1".val VARCHAR ); > > By default, Phoenix sends characters in capital letter, so > here second column of view is mapped to the qualifier "f1:VAL". > > > > But you inserted records at HBase in "f1:val" instead of "f1:VAL" as, > > r1 column=f1:val, timestamp=1396558762590, value=a > > > > So NULL value is displayed in VAL column at Phoenix side. > > > > You can map as "f1"."val" to resolve this or insert records in "f1:VAL". > > > > Cheers, > > Pankaj > > > > *From:* Daniel Rodriguez > [mailto:[email protected]<[email protected]>] > > *Sent:* 04 April 2014 06:18 > *To:* user > *Subject:* Basic mapping to HBase table > > > > Hi all, > > > > I spent a couple of hours today trying phoenix for the first time, looks > amazing. > > > > My final objective is to do SQL on a big hbase table that has a composite > key, i decided to start slow and I was able to create a table on phoenix, > upsert values and see them on hbase, but I am not able to do the oposite: > map (using a view) values on an existing hbase to a phoenix table, i am > always getting "null" values. > > > > Here is a basic example copied from the docs: > > > > HBASE: > > > create 't1', {NAME => 'f1', VERSIONS => 5} > > > > PHOENIX: > > > CREATE VIEW "t1" ( pk VARCHAR PRIMARY KEY, "f1".val VARCHAR ); > > select * from "t1"; > +------------+------------+ > | PK | VAL | > +------------+------------+ > +------------+------------+ > > > > Works fine since there is no data. > > > > I add data to hbase: > > > put 't1,'r1','f1','a' > > > scan 't1' > > ROW COLUMN+CELL > > r1 column=f1:, > timestamp=1396558806334, value=a > > > > But if i try to select from phoenix i get only null values.: > > > select * from "t1"; > > +------------+------------+ > > | PK | VAL | > > +------------+------------+ > > | r1 | null | > > +------------+------------+ > > > > I also tried to save it on an specific column in the column family: > > > > > scan 't1' > > ROW COLUMN+CELL > > r1 column=f1:, > timestamp=1396558806334, value=a > > r1 column=f1:val, > timestamp=1396558762590, value=a > > > > I also tried to change from varchar to integer and insert numbers but i > got the same result in both cases. > > > > I am using phoenix 2.2.0 on EMR. > > > > Any help you can give me is appreciated. > > > > Thanks, > > Daniel >
