question Re: Impala JDBC driver thrown unintelligible error on prepareStatement in Support Questions

Impala JDBC driver thrown unintelligible error on prepareStatement

michalwojtowicz — Fri, 20 Sep 2024 16:23:48 GMT

Logged SELECT statement targets table with 10736979 rows. What can the reason for this error? Is it related to query timeout? What is the default driver query timeout? prepareStatement has been running for around 3 hours before driver thrown the error.

Caused by: java.sql.SQLException: [Cloudera][ImpalaJDBCDriver](500051) ERROR processing query/statement. Error Code: 0, SQL state: TStatus(statusCode:ERROR_STATUS, sqlState:HY000, errorMessage:Invalid session id: 854422e228b99fe7:8a73e8f716a58fbf ), Query: SELECT `type_enr`, `num_enr`, `num_carte`, `seq_carte`, `type_carte`, `cd_pdt_pilotage`, `code_tarif`, `num_cpt`, `letr_cle`, `numero_personne_host`, `nom_porteur`, `typ_porteur`, `autoris_comerc`, `statu_crt`, `dt_statut`, `dt_saisie`, `dt_vente`, `dt_eche`, `dt_der_fab`, `dt_der_fact`, `code_renouv`, `code_suivi`, `date_suivi`, `nbr_recalcul`, `dt_recalcul`, `nbr_relance`, `dt_relance`, `opt_releve`, `num_dern_rlv`, `matr_vend`, `cd_motif`, `usr_crea`, `trm_crea`, `usr_valid`, `trm_valid`, `usr_maj`, `trm_maj`, `num_lot`, `crt_imp`, `frais`, `origine`, `crt_ppl`, `formule`, `design`, `date_prelv`, `matr_vendeur`, `dt_modif_rec`, `agc_com`, `filler`, `time` FROM `awb_preprod`.`orc_mn_porteur`. at com.cloudera.impala.hivecommon.api.HS2Client.executeStatementInternal(Unknown Source) at com.cloudera.impala.hivecommon.api.HS2Client.executeStatement(Unknown Source) at com.cloudera.impala.hivecommon.dataengine.HiveJDBCNativeQueryExecutor.executeQuery(Unknown Source) at com.cloudera.impala.hivecommon.dataengine.HiveJDBCNativeQueryExecutor.<init>(Unknown Source) at com.cloudera.impala.hivecommon.dataengine.HiveJDBCDataEngine.prepare(Unknown Source) at com.cloudera.impala.jdbc.common.SPreparedStatement.<init>(Unknown Source) at com.cloudera.impala.jdbc.jdbc41.S41PreparedStatement.<init>(Unknown Source) at com.cloudera.impa

Re: Impala JDBC driver thrown unintelligible error on prepareStatement

DianaTorres — Fri, 20 Sep 2024 16:26:24 GMT

@michalwojtowicz Welcome to the Cloudera Community!

To help you get the best possible solution, I have tagged our Impala experts @mszurap @ezerihun who may be able to assist you further.

Please keep us updated on your post, and we hope you find a satisfactory solution to your query.

Re: Impala JDBC driver thrown unintelligible error on prepareStatement

kbanik — Tue, 19 Nov 2024 13:39:24 GMT

@michalwojtowicz

Mentioned error seem to be complaining about expired session which either gets terminated by client or server.

Now, to answer your question driver config has SocketTimeout which controls TCP connection: "The number of seconds that the TCP socket waits for a response from the server before raising an error on the request." and default value of the same is 0(i.e the connection does not time out.)

Refer: https://docs.cloudera.com/documentation/other/connectors/impala-jdbc/2-6-34/Cloudera-JDBC-Connector-for-Apache-Impala-Install-Guide.pdf

However, could you confirm whether you have loadbalancer in place for impala through which you are connecting using JDBC driver?

If yes, consider reviewing LB settings which should have timeout configurations allowing server to close the connection for long running queries, for instance:

===

timeout connect

timeout client

timeout server

===