Hi, I am looking for explanation for below error. It fails on getColumns call.     Caused by: java.sql.SQLException: [Cloudera][ImpalaJDBCDriver](500001) Error setting metadata information: Metadata Initialization Error. at com.cloudera.impala.hivecommon.dataengine.metadata.HiveJDBCColumnsMetadataSource.initializeColumn(Unknown Source) at com.cloudera.impala.hivecommon.dataengine.metadata.HiveJDBCColumnsMetadataSource.(Unknown Source) at com.cloudera.impala.hivecommon.dataengine.HiveJDBCDataEngine.makeNewMetadataSource(Unknown Source) at com.cloudera.impala.dsi.dataengine.impl.DSIDataEngine.makeNewMetadataResult(Unknown Source) at com.cloudera.impala.hivecommon.dataengine.HiveJDBCDataEngine.makeNewMetadataResult(Unknown Source) at com.cloudera.impala.jdbc.jdbc41.S41DatabaseMetaData.createMetaDataResult(Unknown Source) at com.cloudera.impala.jdbc.common.SDatabaseMetaData.getColumns(Unknown Source) ... Caused by: com.cloudera.impala.support.exceptions.GeneralException: [Cloudera][ImpalaJDBCDriver](500001) Error setting metadata information: Metadata Initialization Error. ... 46 more Caused by: com.cloudera.impala.support.exceptions.GeneralException: HIVE_METADATA_SCHEMA_ERR at com.cloudera.impala.hivecommon.api.HS2Client.getSchemas(Unknown Source) ... 46 more Caused by: com.cloudera.impala.support.exceptions.GeneralException: HIVE_QUERY_EXE_ERR 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.api.HS2Client.runCatalogFunction(Unknown Source) ... 47 more   ... View more

Hi, I am looking for explanation for below error. Why driver is trying to convert LIMIT into TOP? This log comes from LogLevel=5. Sep 18 16:51:32.339 DEBUG 73090 com.cloudera.impala.jdbc.core..call: establishConnection() in a new thread: 73090 Sep 18 16:51:32.342 INFO 73090 com.cloudera.impala.hivecommon.core.HiveJDBCCommonConnection.establishConnection: Schema is set to default: default Sep 18 16:51:32.343 DEBUG 73090 com.cloudera.impala.hivecommon.core.HiveJDBCCommonConnection.establishConnection: socketTimeout = 0, loginTimeout = 60 Sep 18 16:51:32.343 DEBUG 73090 com.cloudera.impala.hivecommon.core.HiveJDBCCommonConnection.establishConnection: SocketTimeout is: 60 seconds for test Sep 18 16:51:34.408 DEBUG 73090 com.cloudera.impala.hivecommon.core.HiveJDBCCommonConnection.establishConnection: socketTimeout is set back to 0 seconds Sep 18 16:51:34.408 DEBUG 73090 com.cloudera.impala.hivecommon.core.HiveJDBCCommonConnection.setServersideProperties: {LoginTimeout=60, SSLTrustStoreType=JKS} Sep 18 16:51:34.934 INFO 73084 com.cloudera.impala.jdbc.common.SConnection.SConnection: Driver version is: 02.06.15.1017 Sep 18 16:51:34.935 INFO 73084 com.cloudera.impala.jdbc.common.SConnection.SConnection: Datasource version is: 02.06.15.1017 Sep 18 16:51:36.228 INFO 73084 com.cloudera.impala.hivecommon.dataengine.HiveJDBCDataEngine.prepare: Removing semicolons from query: SELECT * FROM `awb_preprod`.`orc_mn_porteur` LIMIT 1000 Sep 18 16:51:36.946 WARN 73084 com.cloudera.impala.hivecommon.dataengine.HiveJDBCDataEngineWithLimitZeroPreparedStatementMetadata.prepare: [Cloudera][JSQLEngine](13420) Both TOP and LIMIT appear in the same SELECT query. com.cloudera.impala.sqlengine.exceptions.SQLEngineException: [Cloudera][JSQLEngine](13420) Both TOP and LIMIT appear in the same SELECT query. at com.cloudera.impala.sqlengine.parser.generated.Parser.transformLimitToTop(Unknown Source) at com.cloudera.impala.sqlengine.parser.generated.Parser.yyparse(Unknown Source) at com.cloudera.impala.sqlengine.parser.generated.Parser.parse(Unknown Source) at com.cloudera.impala.sqlengine.parser.PTParser.parse(Unknown Source) at com.cloudera.impala.sqlengine.dsiext.dataengine.SqlDataEngine.prepare(Unknown Source) at com.cloudera.impala.hivecommon.dataengine.HiveJDBCDataEngineWithLimitZeroPreparedStatementMetadata.prepare(Unknown Source) at com.cloudera.impala.hivecommon.dataengine.HiveJDBCDataEngine.createQueryExecutor(Unknown Source) at com.cloudera.impala.hivecommon.dataengine.HiveJDBCDataEngine.createQueryExecutor(Unknown Source) at com.cloudera.impala.sqlengine.dsiext.dataengine.SqlDataEngine.prepare(Unknown Source) at com.cloudera.impala.hivecommon.dataengine.HiveJDBCDataEngine.translateThroughEngine(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.impala.hivecommon.jdbc41.Hive41PreparedStatement.<init>(Unknown Source) at com.cloudera.impala.impala.common.ImpalaJDBCObjectFactory.createPreparedStatement(Unknown Source) at com.cloudera.impala.jdbc.common.SConnection.prepareStatement(Unknown Source) at com.cloudera.impala.jdbc.common.SConnection.prepareStatement(Unknown Source)   ... View more

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       ... View more