Hi @AcharkiMed   As you suggested me to set  TSaslTransportBufSize=4000; RowsFetchedPerBlock=60536; SSP_BATCH_SIZE=60536; in the connection URL. I did the changes but i am getting these errors java.sql.SQLException: [Simba][ImpalaJDBCDriver](500051) ERROR processing query/ statement. Error Code: 0, SQL state: TStatus(statusCode:ERROR_STATUS, sqlState:H Y000, errorMessage:Invalid query option: SSP_BATCH_SIZE ), Query: SET SSP_BATCH_SIZE=60536. at com.cloudera.hivecommon.api.HS2Client.executeStatementInternal(Unknow n Source) ~[Impala-JDBC-41-1.0.0.jar!/:na]  and  java.sql.SQLException: [Simba][ImpalaJDBCDriver](500051) ERROR processing query/statement. Error Code: 0, SQL state: TStatus(statusCode:ERROR_STATUS, sqlState:HY000, errorMessage:Invalid query option: TSaslTransportBufSize ), Query: SET TSaslTransportBufSize=4000. Help me set up the property.   Thank You, Bishnu ... View more

Hi @AcharkiMed   I tried setting the Batch size in the connection URL but I didn't get any performance boost in the query fetching time. I have posted my usecase in the cloudera forum. Kindly answer my questions : https://community.cloudera.com/t5/Interactive-Short-cycle-SQL/Impala-concurrent-query-delay/m-p/80228#M4911 https://community.cloudera.com/t5/Interactive-Short-cycle-SQL/Understanding-How-does-impala-handles-concurrent-queries/m-p/80296#M4921     ... View more

Can you tell me the way to set the BATCH_SIZE for impala jdbc connection? I tried but it is not working for me. ... View more