Thanks Mujtaba. Could you tell me which version of phoenix are you using ?
-Naveen Nahata On 11 May 2016 at 04:12, Mujtaba Chohan <mujt...@apache.org> 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' > COLUMN > CELL > > 0:MYCOL timestamp=1462515518048, > value=b > > 0:_0 timestamp=1462515518048, > value= > > 2 row(s) in 0.0190 seconds > > 0: jdbc:phoenix:localhost> select * from mytable where pk1='a'; > +------+--------+ > | PK1 | MYCOL | > +------+--------+ > | a | b | > +------+--------+ > 1 row selected (0.028 seconds) > > In your test, are you factoring out initial cost of setting up Phoenix > connection? If no then see performance of subsequent runs by measuring time > in a loop for executeStatement and iterate over resultSet. > > -mujtaba > > > On Tue, May 10, 2016 at 12:55 PM, Naveen Nahata ( SC ) < > naveen.nah...@flipkart.com> wrote: > > > 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 statement from phoenix, which stats query > > is look up on one key. > > > > > > > > > > If query on look up on 1 key why its taking so long ? > > > > Code Ref. > > > > // Connecting phoenix > > > > String sql = "select * from fklogistics.shipment where shipmentId = > 'WSRR4271782117'"; > > long startTime = System.nanoTime(); > > ResultSet rs1 = st.executeQuery(sql); > > long endTime = System.nanoTime(); > > long duration = endTime - startTime; > > System.out.println("Time take by phoenix :" + duration); > > > > // Connecting HBase > > > > Get get = new Get(row); > > startTime = System.nanoTime(); > > Result rs = table1.get(get); > > endTime = System.nanoTime(); > > duration = endTime - startTime; > > System.out.println("Time take by hbase :" + duration); > > > > Please suggest why query is so slow ? Also will upgrading phoenix driver > can help in this ? > > > > Thanks & Regards, > > > > Naveen Nahata > > > > > > >