Hi Siddharth, That's sounds strange because sqlline tool is just an another db client and it uses the same JDBC API. By any chance can you provide the DDLs and queries, so we will be able to reproduce the problem?
Thanks, Sergey On Wed, Jul 19, 2017 at 11:16 PM, Siddharth Ubale < [email protected]> wrote: > Hi , > > > > I am executing 2 join queries which give the same response. > > > > Query 1: Nested join over 5 tables where . The query uses rowkey “like” > statement to narrow down to the filtered columns. This query in Phoenix > sqlline terminal takes 800millisecs to execute. > > Query 2: Is a inner join over the same 5 tables with secondary indexes > used, it uses the HINT /*+ USE_SORT_MERGE_JOIN */. This query takes approx. > 700millisecs to execute on sqlline terminal. > > > > When we use JDBC to execute the same above 2 queries . > > >Query 1 takes approx. 900 ms to 1000ms to execute and provide results. > > >However query2 takes approx. 3 secs to produce the result. And time taken > in the query on further analysis shows that resultset.next() takes bulk of > this time. Why is is that the terminal takes such less time and the JDBC > API is taking so much time to execute the query? > > > > Please do let me know if anyone faced this issue and is there any way I > can ensure that JDBC call with inner join query is executed faster. > > > > Thanks, > > Siddharth Ubale, > > > > >
