phoenix-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Naveen Nahata <nahata.ii...@gmail.com>
Subject Re: Phoenix Performance issue
Date Thu, 12 May 2016 10:00:45 GMT
Thanks Mujtaba.

Could you also tell me which hbase version are you using ?

-Naveen Nahata

On 12 May 2016 at 00:03, Mujtaba Chohan <mujtaba@apache.org> wrote:

> This is with 4.5.2-HBase-0.98 and 4.x-HBase-0.98 head, got almost the same
> numbers with both.
>
> On Wed, May 11, 2016 at 12:19 AM, Naveen Nahata <nahata.iiitm@gmail.com>
> wrote:
>
>> Thanks Mujtaba.
>>
>> Could you tell me which version of phoenix are you using ?
>>
>> -Naveen Nahata
>>
>> On 11 May 2016 at 04:12, Mujtaba Chohan <mujtaba@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.nahata@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
>>> >
>>> >
>>> >
>>>
>>
>>
>

Mime
View raw message