phoenix-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From anil gupta <anilgupt...@gmail.com>
Subject Re: Row Scan In HBase Not Working When Table Created With Phoenix
Date Sat, 28 Jul 2018 17:41:36 GMT
In addition to Miles comment, its recommended to use Phoenix for reads if
you wrote data using Phoenix.
To mimic your range scan in Phoenix query: select * from EMPPH2 where id >=
1 and id < 3;

On Thu, Jul 26, 2018 at 11:10 PM, Miles Spielberg <miles@box.com> wrote:

> SQL INTEGER is not stored as strings, but as 4-bytes of encoded binary.
> See https://phoenix.apache.org/language/datatypes.html#integer_type
>
> Miles Spielberg
> Staff Software Engineer
>
>
> O. 650.485.1102
> 900 Jefferson Ave
> <https://maps.google.com/?q=900+Jefferson+Ave+%0D%0A%0D%0ARedwood+City+,+CA+94063&entry=gmail&source=g>
> Redwood City, CA 94063
> <https://maps.google.com/?q=900+Jefferson+Ave+%0D%0A%0D%0ARedwood+City+,+CA+94063&entry=gmail&source=g>
>
> On Thu, Jul 26, 2018 at 5:44 PM, alchemist <alchemistsrivastava@gmail.com>
> wrote:
>
>> 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/
>>
>
>


-- 
Thanks & Regards,
Anil Gupta

Mime
View raw message