Support Questions

Find answers, ask questions, and share your expertise

Impala JDBC driver thrown unintelligible error on prepareStatement

avatar
New Contributor

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

 

 

 

1 REPLY 1

avatar
Community Manager

@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.


Regards,

Diana Torres,
Community Moderator


Was your question answered? Make sure to mark the answer as the accepted solution.
If you find a reply useful, say thanks by clicking on the thumbs up button.
Learn more about the Cloudera Community: