phoenix-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From alchemist <>
Subject Row Scan In HBase Not Working When Table Created With Phoenix
Date Fri, 27 Jul 2018 00:44:34 GMT
create table empPh2(id integer primary key, fname varchar, lname
upsert into empPh2 values (1, 'A', 'B');
upsert into empPh2 values (2, 'B', 'B');
upsert into empPh2 values (3, 'C', 'B');
upsert into empPh2 values (4, 'John', 'B');

Then when to HBase to do the range query using following command:

hbase(main):004:0> scan 'EMPPH2', {STARTROW => '1', ENDROW => '3'}
ROW                                                COLUMN+CELL                           
0 row(s) in 0.0030 seconds

I saw row in HBASE has extra symbols.  Not sure how to have 1:1 mapping
between HBASE table to Phoenix table.

ROW                                              COLUMN+CELL                             
 \x80\x00\x00\x01                                column=0:FNAME,
timestamp=1532651140732, value=A                                                         
 \x80\x00\x00\x01                                column=0:LNAME,
timestamp=1532651140732, value=B                                                         
 \x80\x00\x00\x01                                column=0:_0,
timestamp=1532651140732, value=x                                                         
 \x80\x00\x00\x02                                column=0:FNAME,
timestamp=1532651151877, value=B                                                         
 \x80\x00\x00\x02                                column=0:LNAME,
timestamp=1532651151877, value=B                                                         
 \x80\x00\x00\x02                                column=0:_0,
timestamp=1532651151877, value=x                                                         
 \x80\x00\x00\x03                                column=0:FNAME,
timestamp=1532651164899, value=C                                                         
 \x80\x00\x00\x03                                column=0:LNAME,
timestamp=1532651164899, value=B  

Sent from:

View raw message