DDL: Table creation statement - CREATE TABLE TAB_SCAPI_DIGNASMBP_1728048648203(C1 INT, C2 VARCHAR(20)) ROW FORMAT DELIMITED FIELDS TERMINATED BY ',' LINES TERMINATED BY ' ' STORED AS TEXTFILE Prepared statement for insertion - INSERT INTO TAB_SCAPI_DIGNASMBP_1728048648203 (C1, C2) VALUES (?, ?) Values inserting - 1|VALUE ONE; 2|VALUE TWO; 3|NULL; 4|VALUE FOUR; 5|VALUE FIVE; Upon executing the command "INSERT INTO TAB_SCAPI_DIGNASMBP_1728048648203 (C1, C2) VALUES (3, NULL); we are receiving following error: org.jkiss.dbeaver.model.sql.DBSQLException: SQL Error [1] [08S01]: Error while compiling statement: FAILED: Execution Error, return code 1 from org.apache.hadoop.hive.ql.exec.tez.TezTask at org.jkiss.dbeaver.model.impl.jdbc.exec.JDBCStatementImpl.executeStatement(JDBCStatementImpl.java:133) at org.jkiss.dbeaver.ui.editors.sql.execute.SQLQueryJob.executeStatement(SQLQueryJob.java:582) at org.jkiss.dbeaver.ui.editors.sql.execute.SQLQueryJob.lambda$1(SQLQueryJob.java:491) at org.jkiss.dbeaver.ui.editors.sql.execute.SQLQueryJob.executeSingleQuery(SQLQueryJob.java:501) at org.jkiss.dbeaver.ui.editors.sql.execute.SQLQueryJob.extractData(SQLQueryJob.java:934) at org.jkiss.dbeaver.ui.editors.sql.SQLEditor$QueryResultsContainer.readData(SQLEditor.java:3940) at org.jkiss.dbeaver.ui.controls.resultset.ResultSetJobDataRead.lambda$0(ResultSetJobDataRead.java:123) at org.jkiss.dbeaver.model.exec.DBExecUtils.tryExecuteRecover(DBExecUtils.java:190) at org.jkiss.dbeaver.ui.controls.resultset.ResultSetJobDataRead.run(ResultSetJobDataRead.java:121) at org.jkiss.dbeaver.ui.controls.resultset.ResultSetViewer$ResultSetDataPumpJob.run(ResultSetViewer.java:5142) at org.jkiss.dbeaver.model.runtime.AbstractJob.run(AbstractJob.java:105) at org.eclipse.core.internal.jobs.Worker.run(Worker.java:63) Caused by: java.sql.SQLException: Error while compiling statement: FAILED: Execution Error, return code 1 from org.apache.hadoop.hive.ql.exec.tez.TezTask at org.apache.hive.jdbc.HiveStatement.waitForOperationToComplete(HiveStatement.java:354) at org.apache.hive.jdbc.HiveStatement.execute(HiveStatement.java:245) at org.jkiss.dbeaver.model.impl.jdbc.exec.JDBCStatementImpl.execute(JDBCStatementImpl.java:330) at org.jkiss.dbeaver.model.impl.jdbc.exec.JDBCStatementImpl.executeStatement(JDBCStatementImpl.java:131) ... View more

  2024-10-04 11:44:39.765: [TargetConnector.0][hive] CDICO2024E: Batch of 5 records could not be written to the data source: [SQLSTATE HY000] c error: [IBM][Hive JDBC Driver][Hive]Error while compiling statement: FAILED: Execution Error, return code 1 from org.apache.hadoop.hive.ql.exec.tez.TezTask com.ibm.connect.api.SQLErrorException: CDICO2024E: Batch of 5 records could not be written to the data source: [SQLSTATE HY000] c error: [IBM][Hive JDBC Driver][Hive]Error while compiling statement: FAILED: Execution Error, return code 1 from org.apache.hadoop.hive.ql.exec.tez.TezTask (error code: DATA_IO_ERROR) at com.ibm.connect.base.util.Utils.toSQLErrorException(Utils.java:331) at com.ibm.connect.jdbc.AbstractJdbcOutputInteraction.handleAndThrowBatchError(AbstractJdbcOutputInteraction.java:1142) at com.ibm.connect.jdbc.AbstractJdbcOutputInteraction.flushBatch(AbstractJdbcOutputInteraction.java:1025) at com.ibm.connect.jdbc.AbstractJdbcConnector.commit(AbstractJdbcConnector.java:598) at com.ibm.connect.test.steps.ConnectorWriteStep.lambda$performLastCommit$1(ConnectorWriteStep.java:641) at java.base/java.lang.Iterable.forEach(Iterable.java:75) at com.ibm.connect.test.steps.ConnectorWriteStep.performLastCommit(ConnectorWriteStep.java:640) at com.ibm.connect.test.steps.ConnectorWriteStep.writePredefinedRecords(ConnectorWriteStep.java:515) at com.ibm.connect.test.steps.ConnectorWriteStep.writePredefined(ConnectorWriteStep.java:1021) at com.ibm.connect.test.steps.ConnectorWriteStep.writeRecords(ConnectorWriteStep.java:1032) at com.ibm.connect.test.steps.ConnectorWriteStep.run(ConnectorWriteStep.java:382) at com.ibm.connect.test.Test.run(Test.java:504) at com.ibm.connect.test.TestRun.runTest(TestRun.java:158) at com.ibm.connect.test.Framework.run(Framework.java:638) at com.ibm.connect.test.Framework.exec(Framework.java:192) at com.ibm.connect.test.Framework.main(Framework.java:115) at hive.scapi.kerberos.Test003_KerberosConnection.test(Test003_KerberosConnection.java:9) at java.base/jdk.internal.reflect.DirectMethodHandleAccessor.invoke(DirectMethodHandleAccessor.java:103) at java.base/java.lang.reflect.Method.invoke(Method.java:586) at org.junit.runners.model.FrameworkMethod$1.runReflectiveCall(FrameworkMethod.java:59) at org.junit.internal.runners.model.ReflectiveCallable.run(ReflectiveCallable.java:12) at org.junit.runners.model.FrameworkMethod.invokeExplosively(FrameworkMethod.java:56) at org.junit.internal.runners.statements.InvokeMethod.evaluate(InvokeMethod.java:17) at org.junit.internal.runners.statements.FailOnTimeout$CallableStatement.call(FailOnTimeout.java:299) at org.junit.internal.runners.statements.FailOnTimeout$CallableStatement.call(FailOnTimeout.java:293) at java.base/java.util.concurrent.FutureTask.run(FutureTask.java:317) at java.base/java.lang.Thread.run(Thread.java:1595) Caused by: com.ibm.connect.driver.jdbc.hive.base.c: [IBM][Hive JDBC Driver][Hive]Error while compiling statement: FAILED: Execution Error, return code 1 from org.apache.hadoop.hive.ql.exec.tez.TezTask at com.ibm.connect.driver.jdbc.hive.base.BasePreparedStatement.executeBatch(|Hive|6.0.1.1383|:777) at com.ibm.connect.jdbc.AbstractJdbcOutputInteraction.flushBatch(AbstractJdbcOutputInteraction.java:993) ... 24 more 2024-10-04 11:44:39.769: [TargetConnector.0][hive] CDICO2024E: Batch of 5 records could not be written to the data source: [SQLSTATE HY000] c error: [IBM][Hive JDBC Driver][Hive]Error while compiling statement: FAILED: Execution Error, return code 1 from org.apache.hadoop.hive.ql.exec.tez.TezTask com.ibm.connect.api.SQLErrorException: CDICO2024E: Batch of 5 records could not be written to the data source: [SQLSTATE HY000] c error: [IBM][Hive JDBC Driver][Hive]Error while compiling statement: FAILED: Execution Error, return code 1 from org.apache.hadoop.hive.ql.exec.tez.TezTask (error code: DATA_IO_ERROR) at com.ibm.connect.base.util.Utils.toSQLErrorException(Utils.java:331) at com.ibm.connect.jdbc.AbstractJdbcOutputInteraction.handleAndThrowBatchError(AbstractJdbcOutputInteraction.java:1142) at com.ibm.connect.jdbc.AbstractJdbcOutputInteraction.flushBatch(AbstractJdbcOutputInteraction.java:1025) at com.ibm.connect.jdbc.AbstractJdbcConnector.commit(AbstractJdbcConnector.java:598) at com.ibm.connect.test.steps.ConnectorWriteStep.lambda$performLastCommit$1(ConnectorWriteStep.java:641) at java.base/java.lang.Iterable.forEach(Iterable.java:75) at com.ibm.connect.test.steps.ConnectorWriteStep.performLastCommit(ConnectorWriteStep.java:640) at com.ibm.connect.test.steps.ConnectorWriteStep.writePredefinedRecords(ConnectorWriteStep.java:515) at com.ibm.connect.test.steps.ConnectorWriteStep.writePredefined(ConnectorWriteStep.java:1021) at com.ibm.connect.test.steps.ConnectorWriteStep.writeRecords(ConnectorWriteStep.java:1032) at com.ibm.connect.test.steps.ConnectorWriteStep.run(ConnectorWriteStep.java:382) at com.ibm.connect.test.Test.run(Test.java:504) at com.ibm.connect.test.TestRun.runTest(TestRun.java:158) at com.ibm.connect.test.Framework.run(Framework.java:638) at com.ibm.connect.test.Framework.exec(Framework.java:192) at com.ibm.connect.test.Framework.main(Framework.java:115) at hive.scapi.kerberos.Test003_KerberosConnection.test(Test003_KerberosConnection.java:9) at java.base/jdk.internal.reflect.DirectMethodHandleAccessor.invoke(DirectMethodHandleAccessor.java:103) at java.base/java.lang.reflect.Method.invoke(Method.java:586) at org.junit.runners.model.FrameworkMethod$1.runReflectiveCall(FrameworkMethod.java:59) at org.junit.internal.runners.model.ReflectiveCallable.run(ReflectiveCallable.java:12) at org.junit.runners.model.FrameworkMethod.invokeExplosively(FrameworkMethod.java:56) at org.junit.internal.runners.statements.InvokeMethod.evaluate(InvokeMethod.java:17) at org.junit.internal.runners.statements.FailOnTimeout$CallableStatement.call(FailOnTimeout.java:299) at org.junit.internal.runners.statements.FailOnTimeout$CallableStatement.call(FailOnTimeout.java:293) at java.base/java.util.concurrent.FutureTask.run(FutureTask.java:317) at java.base/java.lang.Thread.run(Thread.java:1595) Caused by: com.ibm.connect.driver.jdbc.hive.base.c: [IBM][Hive JDBC Driver][Hive]Error while compiling statement: FAILED: Execution Error, return code 1 from org.apache.hadoop.hive.ql.exec.tez.TezTask at com.ibm.connect.driver.jdbc.hive.base.BasePreparedStatement.executeBatch(|Hive|6.0.1.1383|:777) at com.ibm.connect.jdbc.AbstractJdbcOutputInteraction.flushBatch(AbstractJdbcOutputInteraction.java:993) ... 24 more 2024-10-04 11:44:39.772: Exception encountered while writing records: com.ibm.connect.api.SQLErrorException: CDICO2024E: Batch of 5 records could not be written to the data source: [SQLSTATE HY000] c error: [IBM][Hive JDBC Driver][Hive]Error while compiling statement: FAILED: Execution Error, return code 1 from org.apache.hadoop.hive.ql.exec.tez.TezTask (error code: DATA_IO_ERROR) ... View more