How many simultaneous query can execute


#1

Hi,

please let us know is it any limit to run simultaneous queries.

Observed following Error

java.sql.SQLException: Query failed : org.apache.thrift.TApplicationException: sql_execute failed: out of sequence response: expected 3 but got 2


#2

Hi @sumit,

Yes there should be no issue running simultaneous queries. Can you give additional info on what types of queries you were running when this happened? Were they all select queries or were there any drops/truncates/updates/deletes?

Regards


#3

@darwin

Referring "select "query


#4

Hello @sumit. We’re still interested in this issue… there could be an limit for Thrift.
Are you starting the queries one at a time? Or starting them all at the same time?


#5

Hi @sumit,

The philosophy behind the product, is to allocate all the resources available in the system to single queries in order to give the reposnse to the user in the shortest time, so basically the queries you launch are executed in a serialized way.

Said that, it’s likely you are hitting a jdbc driver bug than a system constraint


#6

Hi,

I have same problem. What is the solution? You can see my exception below

Query failed : org.apache.thrift.TApplicationException: sql_execute failed: out of sequence response: expected 3 but got 2