phoenix-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From alchemist <alchemistsrivast...@gmail.com>
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
varchar)COLUMN_ENCODED_BYTES=0
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: http://apache-phoenix-user-list.1124778.n5.nabble.com/

Mime
View raw message