Re: Phoenix Performance issue

2016-05-11 Thread Naveen Nahata
Thanks Mujtaba. Could you tell me which version of phoenix are you using ? -Naveen Nahata On 11 May 2016 at 04:12, Mujtaba Chohan wrote: > Tried the following in Sqlline/Phoenix and HBase shell. Both take ~20ms for > point lookups with local HBase. > > hbase(main):015:0> get 'MYTABLE','a' > CO

Re: Phoenix Performance issue

2016-05-10 Thread Mujtaba Chohan
Tried the following in Sqlline/Phoenix and HBase shell. Both take ~20ms for point lookups with local HBase. hbase(main):015:0> get 'MYTABLE','a' COLUMN CELL 0:MYCOLtimestamp=1462515518048, value=b 0:_0 timestamp=1462515518048, v

Phoenix Performance issue

2016-05-10 Thread Naveen Nahata ( SC )
Hi, I am using phoenix 4.5.2-HBase-0.98 to connect HBase. To benchmark phoenix perforance executed select statement on primary key using phoenix driver and hbase client. Surprisingly figured out PhoenixDriver is approx. 10~15 times slower then hbase client. ​ Addition to this looked explain sta

Phoenix Performance issue

2016-05-10 Thread Naveen Nahata
Hi, I am using phoenix 4.5.2-HBase-0.98 to connect HBase. To benchmark phoenix perforance executed select statement on primary key using phoenix driver and hbase client. Surprisingly figured out PhoenixDriver is approx. 10~15 times slower then hbase client. ​ Addition to this looked explain sta