Re: Phoenix ResultSet.next() takes a long time for first row

2016-09-27 Thread Sasikumar Natarajan
Any one has suggestions for the performance issue discussed in this thread?. Your suggestions would help me resolve this issue. Infrastructure details: Azure HDInsight HBase Type Node SizeCores Nodes Head D3 V2 8 2 Region D3 V2 16 4 ZooKeeper D3 V2 12 3 Thanks, Sasikumar Natarajan

Re: Phoenix ResultSet.next() takes a long time for first row

2016-09-22 Thread Sasikumar Natarajan
Statement.executeQuery() has taken : 702 ms ResultSet Indices at which long time has been taken : *0* (7965 ms), *2041* (7155 ms), *4126 *(1630 ms) On Fri, Sep 23, 2016 at 7:52 AM, Sasikumar Natarajan <sasi...@gmail.com> wrote: > Hi Ankit, >Where does the server proces

Re: Phoenix ResultSet.next() takes a long time for first row

2016-09-22 Thread Sasikumar Natarajan
ol12 VARCHAR ext.col13 BOOLEAN CONSTRAINT SPL_FINAL_PK PRIMARY KEY (col1, col2, col3, col4, col5, col6, col7, col8)) COMPRESSION='SNAPPY'; Thanks, Sasikumar Natarajan. On Thu, Sep 22, 2016 at 12:36 PM, Ankit Singhal <ankitsingha...@gmail.com> wrote: > Share some more details about the query,

Phoenix ResultSet.next() takes a long time for first row

2016-09-21 Thread Sasikumar Natarajan
the ResultSet ready. Please share your thoughts on this. -- Regards, Sasikumar Natarajan