[
https://issues.apache.org/jira/browse/HIVE-29497?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Dayakar M updated HIVE-29497:
-----------------------------
Description:
[HPLSQL] quit is not exiting from execution flow in HPLSQL.
In the below after first insert is failed then it has a quit but still it is
executing second insert which is not correct.
Refer [errorcode handling in HPLSQL|http://hplsql.org/errorcode].
{code:java}
0: jdbc:hive2://localhost> SET hplsql.onerror='seterror';
. . . . . . . . . . . . . . . . . . . . . . .> INSERT INTO abc VALUES('Tbl Not
Exists');
. . . . . . . . . . . . . . . . . . . . . . .> PRINT 'ERRORCODE: ' || ERRORCODE;
. . . . . . . . . . . . . . . . . . . . . . .> PRINT 'SQLCODE: ' || SQLCODE;
. . . . . . . . . . . . . . . . . . . . . . .> .if errorcode <> 0 then .quit 1
. . . . . . . . . . . . . . . . . . . . . . .> INSERT INTO def VALUES('Tbl2 Not
Exists');
. . . . . . . . . . . . . . . . . . . . . . .> /
INFO : Compiling
command(queryId=hive_20260309171813_f9617ffb-796d-418e-a787-0474b49dc134):
INSERT INTO TABLE abc VALUES('Tbl Not Exists')
ERROR : FAILED: SemanticException
org.apache.hadoop.hive.ql.metadata.InvalidTableException: Table not found abc
org.apache.hadoop.hive.ql.parse.SemanticException:
org.apache.hadoop.hive.ql.metadata.InvalidTableException: Table not found abc
at
org.apache.hadoop.hive.ql.parse.SemanticAnalyzer.handleInsertStatementSpecPhase1(SemanticAnalyzer.java:2150)
at
org.apache.hadoop.hive.ql.parse.SemanticAnalyzer.doPhase1(SemanticAnalyzer.java:1846)
at
org.apache.hadoop.hive.ql.parse.SemanticAnalyzer.doPhase1(SemanticAnalyzer.java:2109)
at
org.apache.hadoop.hive.ql.parse.SemanticAnalyzer.doPhase1(SemanticAnalyzer.java:2109)
at
org.apache.hadoop.hive.ql.parse.SemanticAnalyzer.doPhase1(SemanticAnalyzer.java:1744)
at
org.apache.hadoop.hive.ql.parse.SemanticAnalyzer.analyzeAndResolveChildTree(SemanticAnalyzer.java:13057)
at
org.apache.hadoop.hive.ql.parse.SemanticAnalyzer.genResolvedParseTree(SemanticAnalyzer.java:13042)
at
org.apache.hadoop.hive.ql.parse.SemanticAnalyzer.analyzeInternal(SemanticAnalyzer.java:13171)
at
org.apache.hadoop.hive.ql.parse.CalcitePlanner.analyzeInternal(CalcitePlanner.java:481)
at
org.apache.hadoop.hive.ql.parse.BaseSemanticAnalyzer.analyze(BaseSemanticAnalyzer.java:358)
at org.apache.hadoop.hive.ql.Compiler.analyze(Compiler.java:224)
at org.apache.hadoop.hive.ql.Compiler.compile(Compiler.java:109)
at org.apache.hadoop.hive.ql.Driver.compile(Driver.java:498)
at org.apache.hadoop.hive.ql.Driver.compileInternal(Driver.java:450)
at org.apache.hadoop.hive.ql.Driver.compileAndRespond(Driver.java:414)
at org.apache.hadoop.hive.ql.Driver.compileAndRespond(Driver.java:408)
at
org.apache.hadoop.hive.ql.reexec.ReExecDriver.compileAndRespond(ReExecDriver.java:126)
at
org.apache.hive.service.cli.operation.SQLOperation.prepare(SQLOperation.java:205)
at
org.apache.hive.service.cli.operation.SQLOperation.runInternal(SQLOperation.java:268)
at
org.apache.hive.service.cli.operation.Operation.run(Operation.java:286)
at
org.apache.hive.service.cli.session.HiveSessionImpl.executeStatementInternal(HiveSessionImpl.java:558)
at
org.apache.hive.service.cli.session.HiveSessionImpl.executeStatement(HiveSessionImpl.java:526)
at
java.base/jdk.internal.reflect.DirectMethodHandleAccessor.invoke(DirectMethodHandleAccessor.java:103)
at java.base/java.lang.reflect.Method.invoke(Method.java:580)
at
org.apache.hive.service.cli.session.HiveSessionProxy.invoke(HiveSessionProxy.java:78)
at
org.apache.hive.service.cli.session.HiveSessionProxy$1.run(HiveSessionProxy.java:63)
at
java.base/java.security.AccessController.doPrivileged(AccessController.java:714)
at java.base/javax.security.auth.Subject.doAs(Subject.java:525)
at
org.apache.hadoop.security.UserGroupInformation.doAs(UserGroupInformation.java:1953)
at
org.apache.hive.service.cli.session.HiveSessionProxy.invoke(HiveSessionProxy.java:59)
at jdk.proxy2/jdk.proxy2.$Proxy129.executeStatement(Unknown Source)
at
org.apache.hive.service.cli.operation.hplsql.HplSqlQueryExecutor.executeQuery(HplSqlQueryExecutor.java:68)
at org.apache.hive.hplsql.Stmt.insertValues(Stmt.java:821)
at org.apache.hive.hplsql.Stmt.insert(Stmt.java:732)
at org.apache.hive.hplsql.Exec.visitInsert_stmt(Exec.java:1210)
at org.apache.hive.hplsql.Exec.visitInsert_stmt(Exec.java:96)
at
org.apache.hive.hplsql.HplsqlParser$Insert_stmtContext.accept(HplsqlParser.java:10977)
at
org.antlr.v4.runtime.tree.AbstractParseTreeVisitor.visitChildren(AbstractParseTreeVisitor.java:46)
at org.apache.hive.hplsql.Exec.visitStmt(Exec.java:1103)
at org.apache.hive.hplsql.Exec.visitStmt(Exec.java:96)
at
org.apache.hive.hplsql.HplsqlParser$StmtContext.accept(HplsqlParser.java:1054)
at
org.antlr.v4.runtime.tree.AbstractParseTreeVisitor.visitChildren(AbstractParseTreeVisitor.java:46)
at
org.apache.hive.hplsql.HplsqlBaseVisitor.visitBlock(HplsqlBaseVisitor.java:27)
at
org.apache.hive.hplsql.HplsqlParser$BlockContext.accept(HplsqlParser.java:473)
at
org.antlr.v4.runtime.tree.AbstractParseTreeVisitor.visitChildren(AbstractParseTreeVisitor.java:46)
at org.apache.hive.hplsql.Exec.visitProgram(Exec.java:999)
at org.apache.hive.hplsql.Exec.visitProgram(Exec.java:96)
at
org.apache.hive.hplsql.HplsqlParser$ProgramContext.accept(HplsqlParser.java:414)
at
org.antlr.v4.runtime.tree.AbstractParseTreeVisitor.visit(AbstractParseTreeVisitor.java:18)
at org.apache.hive.hplsql.Exec.evaluate(Exec.java:817)
at org.apache.hive.hplsql.Exec.parseAndEval(Exec.java:796)
at
org.apache.hive.service.cli.operation.hplsql.HplSqlOperation.interpret(HplSqlOperation.java:97)
at
org.apache.hive.service.cli.operation.hplsql.HplSqlOperation$BackgroundWork.lambda$run$0(HplSqlOperation.java:206)
at
java.base/java.security.AccessController.doPrivileged(AccessController.java:714)
at java.base/javax.security.auth.Subject.doAs(Subject.java:525)
at
org.apache.hadoop.security.UserGroupInformation.doAs(UserGroupInformation.java:1953)
at
org.apache.hive.service.cli.operation.hplsql.HplSqlOperation$BackgroundWork.run(HplSqlOperation.java:218)
at
java.base/java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:572)
at java.base/java.util.concurrent.FutureTask.run(FutureTask.java:317)
at
java.base/java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1144)
at
java.base/java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:642)
at java.base/java.lang.Thread.run(Thread.java:1583)
Caused by: org.apache.hadoop.hive.ql.metadata.InvalidTableException: Table not
found abc
at org.apache.hadoop.hive.ql.metadata.Hive.getTable(Hive.java:1798)
at
org.apache.hadoop.hive.ql.parse.CalcitePlanner.getTableObjectByName(CalcitePlanner.java:5110)
at
org.apache.hadoop.hive.ql.parse.SemanticAnalyzer.getTableObjectByName(SemanticAnalyzer.java:12766)
at
org.apache.hadoop.hive.ql.parse.SemanticAnalyzer.handleInsertStatementSpecPhase1(SemanticAnalyzer.java:2147)
... 61 more
INFO : Completed compiling
command(queryId=hive_20260309171813_f9617ffb-796d-418e-a787-0474b49dc134); Time
taken: 1.91 seconds
INFO : ERRORCODE: -1
INFO : SQLCODE: -1
INFO : Compiling
command(queryId=hive_20260309171813_f9617ffb-796d-418e-a787-0474b49dc134):
INSERT INTO TABLE def VALUES('Tbl2 Not Exists')
ERROR : FAILED: SemanticException
org.apache.hadoop.hive.ql.metadata.InvalidTableException: Table not found def
org.apache.hadoop.hive.ql.parse.SemanticException:
org.apache.hadoop.hive.ql.metadata.InvalidTableException: Table not found def
at
org.apache.hadoop.hive.ql.parse.SemanticAnalyzer.handleInsertStatementSpecPhase1(SemanticAnalyzer.java:2150)
at
org.apache.hadoop.hive.ql.parse.SemanticAnalyzer.doPhase1(SemanticAnalyzer.java:1846)
at
org.apache.hadoop.hive.ql.parse.SemanticAnalyzer.doPhase1(SemanticAnalyzer.java:2109)
at
org.apache.hadoop.hive.ql.parse.SemanticAnalyzer.doPhase1(SemanticAnalyzer.java:2109)
at
org.apache.hadoop.hive.ql.parse.SemanticAnalyzer.doPhase1(SemanticAnalyzer.java:1744)
at
org.apache.hadoop.hive.ql.parse.SemanticAnalyzer.analyzeAndResolveChildTree(SemanticAnalyzer.java:13057)
at
org.apache.hadoop.hive.ql.parse.SemanticAnalyzer.genResolvedParseTree(SemanticAnalyzer.java:13042)
at
org.apache.hadoop.hive.ql.parse.SemanticAnalyzer.analyzeInternal(SemanticAnalyzer.java:13171)
at
org.apache.hadoop.hive.ql.parse.CalcitePlanner.analyzeInternal(CalcitePlanner.java:481)
at
org.apache.hadoop.hive.ql.parse.BaseSemanticAnalyzer.analyze(BaseSemanticAnalyzer.java:358)
at org.apache.hadoop.hive.ql.Compiler.analyze(Compiler.java:224)
at org.apache.hadoop.hive.ql.Compiler.compile(Compiler.java:109)
at org.apache.hadoop.hive.ql.Driver.compile(Driver.java:498)
at org.apache.hadoop.hive.ql.Driver.compileInternal(Driver.java:450)
at org.apache.hadoop.hive.ql.Driver.compileAndRespond(Driver.java:414)
at org.apache.hadoop.hive.ql.Driver.compileAndRespond(Driver.java:408)
at
org.apache.hadoop.hive.ql.reexec.ReExecDriver.compileAndRespond(ReExecDriver.java:126)
at
org.apache.hive.service.cli.operation.SQLOperation.prepare(SQLOperation.java:205)
at
org.apache.hive.service.cli.operation.SQLOperation.runInternal(SQLOperation.java:268)
at
org.apache.hive.service.cli.operation.Operation.run(Operation.java:286)
at
org.apache.hive.service.cli.session.HiveSessionImpl.executeStatementInternal(HiveSessionImpl.java:558)
at
org.apache.hive.service.cli.session.HiveSessionImpl.executeStatement(HiveSessionImpl.java:526)
at
java.base/jdk.internal.reflect.DirectMethodHandleAccessor.invoke(DirectMethodHandleAccessor.java:103)
at java.base/java.lang.reflect.Method.invoke(Method.java:580)
at
org.apache.hive.service.cli.session.HiveSessionProxy.invoke(HiveSessionProxy.java:78)
at
org.apache.hive.service.cli.session.HiveSessionProxy$1.run(HiveSessionProxy.java:63)
at
java.base/java.security.AccessController.doPrivileged(AccessController.java:714)
at java.base/javax.security.auth.Subject.doAs(Subject.java:525)
at
org.apache.hadoop.security.UserGroupInformation.doAs(UserGroupInformation.java:1953)
at
org.apache.hive.service.cli.session.HiveSessionProxy.invoke(HiveSessionProxy.java:59)
at jdk.proxy2/jdk.proxy2.$Proxy129.executeStatement(Unknown Source)
at
org.apache.hive.service.cli.operation.hplsql.HplSqlQueryExecutor.executeQuery(HplSqlQueryExecutor.java:68)
at org.apache.hive.hplsql.Stmt.insertValues(Stmt.java:821)
at org.apache.hive.hplsql.Stmt.insert(Stmt.java:732)
at org.apache.hive.hplsql.Exec.visitInsert_stmt(Exec.java:1210)
at org.apache.hive.hplsql.Exec.visitInsert_stmt(Exec.java:96)
at
org.apache.hive.hplsql.HplsqlParser$Insert_stmtContext.accept(HplsqlParser.java:10977)
at
org.antlr.v4.runtime.tree.AbstractParseTreeVisitor.visitChildren(AbstractParseTreeVisitor.java:46)
at org.apache.hive.hplsql.Exec.visitStmt(Exec.java:1103)
at org.apache.hive.hplsql.Exec.visitStmt(Exec.java:96)
at
org.apache.hive.hplsql.HplsqlParser$StmtContext.accept(HplsqlParser.java:1054)
at
org.antlr.v4.runtime.tree.AbstractParseTreeVisitor.visitChildren(AbstractParseTreeVisitor.java:46)
at
org.apache.hive.hplsql.HplsqlBaseVisitor.visitBlock(HplsqlBaseVisitor.java:27)
at
org.apache.hive.hplsql.HplsqlParser$BlockContext.accept(HplsqlParser.java:473)
at
org.antlr.v4.runtime.tree.AbstractParseTreeVisitor.visitChildren(AbstractParseTreeVisitor.java:46)
at org.apache.hive.hplsql.Exec.visitProgram(Exec.java:999)
at org.apache.hive.hplsql.Exec.visitProgram(Exec.java:96)
at
org.apache.hive.hplsql.HplsqlParser$ProgramContext.accept(HplsqlParser.java:414)
at
org.antlr.v4.runtime.tree.AbstractParseTreeVisitor.visit(AbstractParseTreeVisitor.java:18)
at org.apache.hive.hplsql.Exec.evaluate(Exec.java:817)
at org.apache.hive.hplsql.Exec.parseAndEval(Exec.java:796)
at
org.apache.hive.service.cli.operation.hplsql.HplSqlOperation.interpret(HplSqlOperation.java:97)
at
org.apache.hive.service.cli.operation.hplsql.HplSqlOperation$BackgroundWork.lambda$run$0(HplSqlOperation.java:206)
at
java.base/java.security.AccessController.doPrivileged(AccessController.java:714)
at java.base/javax.security.auth.Subject.doAs(Subject.java:525)
at
org.apache.hadoop.security.UserGroupInformation.doAs(UserGroupInformation.java:1953)
at
org.apache.hive.service.cli.operation.hplsql.HplSqlOperation$BackgroundWork.run(HplSqlOperation.java:218)
at
java.base/java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:572)
at java.base/java.util.concurrent.FutureTask.run(FutureTask.java:317)
at
java.base/java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1144)
at
java.base/java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:642)
at java.base/java.lang.Thread.run(Thread.java:1583)
Caused by: org.apache.hadoop.hive.ql.metadata.InvalidTableException: Table not
found def
at org.apache.hadoop.hive.ql.metadata.Hive.getTable(Hive.java:1798)
at
org.apache.hadoop.hive.ql.parse.CalcitePlanner.getTableObjectByName(CalcitePlanner.java:5110)
at
org.apache.hadoop.hive.ql.parse.SemanticAnalyzer.getTableObjectByName(SemanticAnalyzer.java:12766)
at
org.apache.hadoop.hive.ql.parse.SemanticAnalyzer.handleInsertStatementSpecPhase1(SemanticAnalyzer.java:2147)
... 61 more
INFO : Completed compiling
command(queryId=hive_20260309171813_f9617ffb-796d-418e-a787-0474b49dc134); Time
taken: 0.025 seconds
ERROR : Unhandled exception in HPL/SQL
ERROR : 1
ERROR : Unhandled exception in HPL/SQL
No rows affected (2.874 seconds)
{code}
was:
[HPLSQL] quit is not exiting from execution flow in HPLSQL.
In the below after first insert is failed then it has a quit but still it is
executing second insert which is not correct.
Refer [errorcode handling in HPLSQL|http://hplsql.org/errorcode].
{code:java}
0: jdbc:hive2://localhost> SET hplsql.onerror='seterror';. . . . . . . . . . .
. . . . . . . . . . . .> INSERT INTO abc VALUES('Tbl Not Exists');. . . . . . .
. . . . . . . . . . . . . . . .> PRINT 'ERRORCODE: ' || ERRORCODE;. . . . . . .
. . . . . . . . . . . . . . . .> PRINT 'SQLCODE: ' || SQLCODE;. . . . . . . . .
. . . . . . . . . . . . . .> .if errorcode <> 0 then .quit 1. . . . . . . . . .
. . . . . . . . . . . . .> INSERT INTO def VALUES('Tbl2 Not Exists');. . . . .
. . . . . . . . . . . . . . . . . .> /INFO : Compiling
command(queryId=hive_20260309171813_f9617ffb-796d-418e-a787-0474b49dc134):
INSERT INTO TABLE abc VALUES('Tbl Not Exists')ERROR : FAILED: SemanticException
org.apache.hadoop.hive.ql.metadata.InvalidTableException: Table not found
abcorg.apache.hadoop.hive.ql.parse.SemanticException:
org.apache.hadoop.hive.ql.metadata.InvalidTableException: Table not found abc
at
org.apache.hadoop.hive.ql.parse.SemanticAnalyzer.handleInsertStatementSpecPhase1(SemanticAnalyzer.java:2150)
at
org.apache.hadoop.hive.ql.parse.SemanticAnalyzer.doPhase1(SemanticAnalyzer.java:1846)
at
org.apache.hadoop.hive.ql.parse.SemanticAnalyzer.doPhase1(SemanticAnalyzer.java:2109)
at
org.apache.hadoop.hive.ql.parse.SemanticAnalyzer.doPhase1(SemanticAnalyzer.java:2109)
at
org.apache.hadoop.hive.ql.parse.SemanticAnalyzer.doPhase1(SemanticAnalyzer.java:1744)
at
org.apache.hadoop.hive.ql.parse.SemanticAnalyzer.analyzeAndResolveChildTree(SemanticAnalyzer.java:13057)
at
org.apache.hadoop.hive.ql.parse.SemanticAnalyzer.genResolvedParseTree(SemanticAnalyzer.java:13042)
at
org.apache.hadoop.hive.ql.parse.SemanticAnalyzer.analyzeInternal(SemanticAnalyzer.java:13171)
at
org.apache.hadoop.hive.ql.parse.CalcitePlanner.analyzeInternal(CalcitePlanner.java:481)
at
org.apache.hadoop.hive.ql.parse.BaseSemanticAnalyzer.analyze(BaseSemanticAnalyzer.java:358)
at org.apache.hadoop.hive.ql.Compiler.analyze(Compiler.java:224) at
org.apache.hadoop.hive.ql.Compiler.compile(Compiler.java:109) at
org.apache.hadoop.hive.ql.Driver.compile(Driver.java:498) at
org.apache.hadoop.hive.ql.Driver.compileInternal(Driver.java:450) at
org.apache.hadoop.hive.ql.Driver.compileAndRespond(Driver.java:414) at
org.apache.hadoop.hive.ql.Driver.compileAndRespond(Driver.java:408) at
org.apache.hadoop.hive.ql.reexec.ReExecDriver.compileAndRespond(ReExecDriver.java:126)
at
org.apache.hive.service.cli.operation.SQLOperation.prepare(SQLOperation.java:205)
at
org.apache.hive.service.cli.operation.SQLOperation.runInternal(SQLOperation.java:268)
at
org.apache.hive.service.cli.operation.Operation.run(Operation.java:286) at
org.apache.hive.service.cli.session.HiveSessionImpl.executeStatementInternal(HiveSessionImpl.java:558)
at
org.apache.hive.service.cli.session.HiveSessionImpl.executeStatement(HiveSessionImpl.java:526)
at
java.base/jdk.internal.reflect.DirectMethodHandleAccessor.invoke(DirectMethodHandleAccessor.java:103)
at java.base/java.lang.reflect.Method.invoke(Method.java:580) at
org.apache.hive.service.cli.session.HiveSessionProxy.invoke(HiveSessionProxy.java:78)
at
org.apache.hive.service.cli.session.HiveSessionProxy$1.run(HiveSessionProxy.java:63)
at
java.base/java.security.AccessController.doPrivileged(AccessController.java:714)
at java.base/javax.security.auth.Subject.doAs(Subject.java:525) at
org.apache.hadoop.security.UserGroupInformation.doAs(UserGroupInformation.java:1953)
at
org.apache.hive.service.cli.session.HiveSessionProxy.invoke(HiveSessionProxy.java:59)
at jdk.proxy2/jdk.proxy2.$Proxy129.executeStatement(Unknown Source)
at
org.apache.hive.service.cli.operation.hplsql.HplSqlQueryExecutor.executeQuery(HplSqlQueryExecutor.java:68)
at org.apache.hive.hplsql.Stmt.insertValues(Stmt.java:821) at
org.apache.hive.hplsql.Stmt.insert(Stmt.java:732) at
org.apache.hive.hplsql.Exec.visitInsert_stmt(Exec.java:1210) at
org.apache.hive.hplsql.Exec.visitInsert_stmt(Exec.java:96) at
org.apache.hive.hplsql.HplsqlParser$Insert_stmtContext.accept(HplsqlParser.java:10977)
at
org.antlr.v4.runtime.tree.AbstractParseTreeVisitor.visitChildren(AbstractParseTreeVisitor.java:46)
at org.apache.hive.hplsql.Exec.visitStmt(Exec.java:1103) at
org.apache.hive.hplsql.Exec.visitStmt(Exec.java:96) at
org.apache.hive.hplsql.HplsqlParser$StmtContext.accept(HplsqlParser.java:1054)
at
org.antlr.v4.runtime.tree.AbstractParseTreeVisitor.visitChildren(AbstractParseTreeVisitor.java:46)
at
org.apache.hive.hplsql.HplsqlBaseVisitor.visitBlock(HplsqlBaseVisitor.java:27)
at
org.apache.hive.hplsql.HplsqlParser$BlockContext.accept(HplsqlParser.java:473)
at
org.antlr.v4.runtime.tree.AbstractParseTreeVisitor.visitChildren(AbstractParseTreeVisitor.java:46)
at org.apache.hive.hplsql.Exec.visitProgram(Exec.java:999) at
org.apache.hive.hplsql.Exec.visitProgram(Exec.java:96) at
org.apache.hive.hplsql.HplsqlParser$ProgramContext.accept(HplsqlParser.java:414)
at
org.antlr.v4.runtime.tree.AbstractParseTreeVisitor.visit(AbstractParseTreeVisitor.java:18)
at org.apache.hive.hplsql.Exec.evaluate(Exec.java:817) at
org.apache.hive.hplsql.Exec.parseAndEval(Exec.java:796) at
org.apache.hive.service.cli.operation.hplsql.HplSqlOperation.interpret(HplSqlOperation.java:97)
at
org.apache.hive.service.cli.operation.hplsql.HplSqlOperation$BackgroundWork.lambda$run$0(HplSqlOperation.java:206)
at
java.base/java.security.AccessController.doPrivileged(AccessController.java:714)
at java.base/javax.security.auth.Subject.doAs(Subject.java:525) at
org.apache.hadoop.security.UserGroupInformation.doAs(UserGroupInformation.java:1953)
at
org.apache.hive.service.cli.operation.hplsql.HplSqlOperation$BackgroundWork.run(HplSqlOperation.java:218)
at
java.base/java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:572)
at java.base/java.util.concurrent.FutureTask.run(FutureTask.java:317) at
java.base/java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1144)
at
java.base/java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:642)
at java.base/java.lang.Thread.run(Thread.java:1583)Caused by:
org.apache.hadoop.hive.ql.metadata.InvalidTableException: Table not found abc
at org.apache.hadoop.hive.ql.metadata.Hive.getTable(Hive.java:1798) at
org.apache.hadoop.hive.ql.parse.CalcitePlanner.getTableObjectByName(CalcitePlanner.java:5110)
at
org.apache.hadoop.hive.ql.parse.SemanticAnalyzer.getTableObjectByName(SemanticAnalyzer.java:12766)
at
org.apache.hadoop.hive.ql.parse.SemanticAnalyzer.handleInsertStatementSpecPhase1(SemanticAnalyzer.java:2147)
... 61 more
INFO : Completed compiling
command(queryId=hive_20260309171813_f9617ffb-796d-418e-a787-0474b49dc134); Time
taken: 1.91 secondsINFO : ERRORCODE: -1INFO : SQLCODE: -1INFO : Compiling
command(queryId=hive_20260309171813_f9617ffb-796d-418e-a787-0474b49dc134):
INSERT INTO TABLE def VALUES('Tbl2 Not Exists')ERROR : FAILED:
SemanticException org.apache.hadoop.hive.ql.metadata.InvalidTableException:
Table not found deforg.apache.hadoop.hive.ql.parse.SemanticException:
org.apache.hadoop.hive.ql.metadata.InvalidTableException: Table not found def
at
org.apache.hadoop.hive.ql.parse.SemanticAnalyzer.handleInsertStatementSpecPhase1(SemanticAnalyzer.java:2150)
at
org.apache.hadoop.hive.ql.parse.SemanticAnalyzer.doPhase1(SemanticAnalyzer.java:1846)
at
org.apache.hadoop.hive.ql.parse.SemanticAnalyzer.doPhase1(SemanticAnalyzer.java:2109)
at
org.apache.hadoop.hive.ql.parse.SemanticAnalyzer.doPhase1(SemanticAnalyzer.java:2109)
at
org.apache.hadoop.hive.ql.parse.SemanticAnalyzer.doPhase1(SemanticAnalyzer.java:1744)
at
org.apache.hadoop.hive.ql.parse.SemanticAnalyzer.analyzeAndResolveChildTree(SemanticAnalyzer.java:13057)
at
org.apache.hadoop.hive.ql.parse.SemanticAnalyzer.genResolvedParseTree(SemanticAnalyzer.java:13042)
at
org.apache.hadoop.hive.ql.parse.SemanticAnalyzer.analyzeInternal(SemanticAnalyzer.java:13171)
at
org.apache.hadoop.hive.ql.parse.CalcitePlanner.analyzeInternal(CalcitePlanner.java:481)
at
org.apache.hadoop.hive.ql.parse.BaseSemanticAnalyzer.analyze(BaseSemanticAnalyzer.java:358)
at org.apache.hadoop.hive.ql.Compiler.analyze(Compiler.java:224) at
org.apache.hadoop.hive.ql.Compiler.compile(Compiler.java:109) at
org.apache.hadoop.hive.ql.Driver.compile(Driver.java:498) at
org.apache.hadoop.hive.ql.Driver.compileInternal(Driver.java:450) at
org.apache.hadoop.hive.ql.Driver.compileAndRespond(Driver.java:414) at
org.apache.hadoop.hive.ql.Driver.compileAndRespond(Driver.java:408) at
org.apache.hadoop.hive.ql.reexec.ReExecDriver.compileAndRespond(ReExecDriver.java:126)
at
org.apache.hive.service.cli.operation.SQLOperation.prepare(SQLOperation.java:205)
at
org.apache.hive.service.cli.operation.SQLOperation.runInternal(SQLOperation.java:268)
at
org.apache.hive.service.cli.operation.Operation.run(Operation.java:286) at
org.apache.hive.service.cli.session.HiveSessionImpl.executeStatementInternal(HiveSessionImpl.java:558)
at
org.apache.hive.service.cli.session.HiveSessionImpl.executeStatement(HiveSessionImpl.java:526)
at
java.base/jdk.internal.reflect.DirectMethodHandleAccessor.invoke(DirectMethodHandleAccessor.java:103)
at java.base/java.lang.reflect.Method.invoke(Method.java:580) at
org.apache.hive.service.cli.session.HiveSessionProxy.invoke(HiveSessionProxy.java:78)
at
org.apache.hive.service.cli.session.HiveSessionProxy$1.run(HiveSessionProxy.java:63)
at
java.base/java.security.AccessController.doPrivileged(AccessController.java:714)
at java.base/javax.security.auth.Subject.doAs(Subject.java:525) at
org.apache.hadoop.security.UserGroupInformation.doAs(UserGroupInformation.java:1953)
at
org.apache.hive.service.cli.session.HiveSessionProxy.invoke(HiveSessionProxy.java:59)
at jdk.proxy2/jdk.proxy2.$Proxy129.executeStatement(Unknown Source)
at
org.apache.hive.service.cli.operation.hplsql.HplSqlQueryExecutor.executeQuery(HplSqlQueryExecutor.java:68)
at org.apache.hive.hplsql.Stmt.insertValues(Stmt.java:821) at
org.apache.hive.hplsql.Stmt.insert(Stmt.java:732) at
org.apache.hive.hplsql.Exec.visitInsert_stmt(Exec.java:1210) at
org.apache.hive.hplsql.Exec.visitInsert_stmt(Exec.java:96) at
org.apache.hive.hplsql.HplsqlParser$Insert_stmtContext.accept(HplsqlParser.java:10977)
at
org.antlr.v4.runtime.tree.AbstractParseTreeVisitor.visitChildren(AbstractParseTreeVisitor.java:46)
at org.apache.hive.hplsql.Exec.visitStmt(Exec.java:1103) at
org.apache.hive.hplsql.Exec.visitStmt(Exec.java:96) at
org.apache.hive.hplsql.HplsqlParser$StmtContext.accept(HplsqlParser.java:1054)
at
org.antlr.v4.runtime.tree.AbstractParseTreeVisitor.visitChildren(AbstractParseTreeVisitor.java:46)
at
org.apache.hive.hplsql.HplsqlBaseVisitor.visitBlock(HplsqlBaseVisitor.java:27)
at
org.apache.hive.hplsql.HplsqlParser$BlockContext.accept(HplsqlParser.java:473)
at
org.antlr.v4.runtime.tree.AbstractParseTreeVisitor.visitChildren(AbstractParseTreeVisitor.java:46)
at org.apache.hive.hplsql.Exec.visitProgram(Exec.java:999) at
org.apache.hive.hplsql.Exec.visitProgram(Exec.java:96) at
org.apache.hive.hplsql.HplsqlParser$ProgramContext.accept(HplsqlParser.java:414)
at
org.antlr.v4.runtime.tree.AbstractParseTreeVisitor.visit(AbstractParseTreeVisitor.java:18)
at org.apache.hive.hplsql.Exec.evaluate(Exec.java:817) at
org.apache.hive.hplsql.Exec.parseAndEval(Exec.java:796) at
org.apache.hive.service.cli.operation.hplsql.HplSqlOperation.interpret(HplSqlOperation.java:97)
at
org.apache.hive.service.cli.operation.hplsql.HplSqlOperation$BackgroundWork.lambda$run$0(HplSqlOperation.java:206)
at
java.base/java.security.AccessController.doPrivileged(AccessController.java:714)
at java.base/javax.security.auth.Subject.doAs(Subject.java:525) at
org.apache.hadoop.security.UserGroupInformation.doAs(UserGroupInformation.java:1953)
at
org.apache.hive.service.cli.operation.hplsql.HplSqlOperation$BackgroundWork.run(HplSqlOperation.java:218)
at
java.base/java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:572)
at java.base/java.util.concurrent.FutureTask.run(FutureTask.java:317) at
java.base/java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1144)
at
java.base/java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:642)
at java.base/java.lang.Thread.run(Thread.java:1583)Caused by:
org.apache.hadoop.hive.ql.metadata.InvalidTableException: Table not found def
at org.apache.hadoop.hive.ql.metadata.Hive.getTable(Hive.java:1798) at
org.apache.hadoop.hive.ql.parse.CalcitePlanner.getTableObjectByName(CalcitePlanner.java:5110)
at
org.apache.hadoop.hive.ql.parse.SemanticAnalyzer.getTableObjectByName(SemanticAnalyzer.java:12766)
at
org.apache.hadoop.hive.ql.parse.SemanticAnalyzer.handleInsertStatementSpecPhase1(SemanticAnalyzer.java:2147)
... 61 more
INFO : Completed compiling
command(queryId=hive_20260309171813_f9617ffb-796d-418e-a787-0474b49dc134); Time
taken: 0.025 secondsERROR : Unhandled exception in HPL/SQLERROR : 1ERROR :
Unhandled exception in HPL/SQLNo rows affected (2.874 seconds)0:
jdbc:hive2://localhost> {code}
> [HPLSQL] quit is not exiting from execution flow in HPLSQL.
> -----------------------------------------------------------
>
> Key: HIVE-29497
> URL: https://issues.apache.org/jira/browse/HIVE-29497
> Project: Hive
> Issue Type: Bug
> Components: hpl/sql
> Reporter: Dayakar M
> Assignee: Dayakar M
> Priority: Major
>
> [HPLSQL] quit is not exiting from execution flow in HPLSQL.
> In the below after first insert is failed then it has a quit but still it is
> executing second insert which is not correct.
> Refer [errorcode handling in HPLSQL|http://hplsql.org/errorcode].
> {code:java}
> 0: jdbc:hive2://localhost> SET hplsql.onerror='seterror';
> . . . . . . . . . . . . . . . . . . . . . . .> INSERT INTO abc VALUES('Tbl
> Not Exists');
> . . . . . . . . . . . . . . . . . . . . . . .> PRINT 'ERRORCODE: ' ||
> ERRORCODE;
> . . . . . . . . . . . . . . . . . . . . . . .> PRINT 'SQLCODE: ' || SQLCODE;
> . . . . . . . . . . . . . . . . . . . . . . .> .if errorcode <> 0 then .quit 1
> . . . . . . . . . . . . . . . . . . . . . . .> INSERT INTO def VALUES('Tbl2
> Not Exists');
> . . . . . . . . . . . . . . . . . . . . . . .> /
> INFO : Compiling
> command(queryId=hive_20260309171813_f9617ffb-796d-418e-a787-0474b49dc134):
> INSERT INTO TABLE abc VALUES('Tbl Not Exists')
> ERROR : FAILED: SemanticException
> org.apache.hadoop.hive.ql.metadata.InvalidTableException: Table not found abc
> org.apache.hadoop.hive.ql.parse.SemanticException:
> org.apache.hadoop.hive.ql.metadata.InvalidTableException: Table not found abc
> at
> org.apache.hadoop.hive.ql.parse.SemanticAnalyzer.handleInsertStatementSpecPhase1(SemanticAnalyzer.java:2150)
> at
> org.apache.hadoop.hive.ql.parse.SemanticAnalyzer.doPhase1(SemanticAnalyzer.java:1846)
> at
> org.apache.hadoop.hive.ql.parse.SemanticAnalyzer.doPhase1(SemanticAnalyzer.java:2109)
> at
> org.apache.hadoop.hive.ql.parse.SemanticAnalyzer.doPhase1(SemanticAnalyzer.java:2109)
> at
> org.apache.hadoop.hive.ql.parse.SemanticAnalyzer.doPhase1(SemanticAnalyzer.java:1744)
> at
> org.apache.hadoop.hive.ql.parse.SemanticAnalyzer.analyzeAndResolveChildTree(SemanticAnalyzer.java:13057)
> at
> org.apache.hadoop.hive.ql.parse.SemanticAnalyzer.genResolvedParseTree(SemanticAnalyzer.java:13042)
> at
> org.apache.hadoop.hive.ql.parse.SemanticAnalyzer.analyzeInternal(SemanticAnalyzer.java:13171)
> at
> org.apache.hadoop.hive.ql.parse.CalcitePlanner.analyzeInternal(CalcitePlanner.java:481)
> at
> org.apache.hadoop.hive.ql.parse.BaseSemanticAnalyzer.analyze(BaseSemanticAnalyzer.java:358)
> at org.apache.hadoop.hive.ql.Compiler.analyze(Compiler.java:224)
> at org.apache.hadoop.hive.ql.Compiler.compile(Compiler.java:109)
> at org.apache.hadoop.hive.ql.Driver.compile(Driver.java:498)
> at org.apache.hadoop.hive.ql.Driver.compileInternal(Driver.java:450)
> at org.apache.hadoop.hive.ql.Driver.compileAndRespond(Driver.java:414)
> at org.apache.hadoop.hive.ql.Driver.compileAndRespond(Driver.java:408)
> at
> org.apache.hadoop.hive.ql.reexec.ReExecDriver.compileAndRespond(ReExecDriver.java:126)
> at
> org.apache.hive.service.cli.operation.SQLOperation.prepare(SQLOperation.java:205)
> at
> org.apache.hive.service.cli.operation.SQLOperation.runInternal(SQLOperation.java:268)
> at
> org.apache.hive.service.cli.operation.Operation.run(Operation.java:286)
> at
> org.apache.hive.service.cli.session.HiveSessionImpl.executeStatementInternal(HiveSessionImpl.java:558)
> at
> org.apache.hive.service.cli.session.HiveSessionImpl.executeStatement(HiveSessionImpl.java:526)
> at
> java.base/jdk.internal.reflect.DirectMethodHandleAccessor.invoke(DirectMethodHandleAccessor.java:103)
> at java.base/java.lang.reflect.Method.invoke(Method.java:580)
> at
> org.apache.hive.service.cli.session.HiveSessionProxy.invoke(HiveSessionProxy.java:78)
> at
> org.apache.hive.service.cli.session.HiveSessionProxy$1.run(HiveSessionProxy.java:63)
> at
> java.base/java.security.AccessController.doPrivileged(AccessController.java:714)
> at java.base/javax.security.auth.Subject.doAs(Subject.java:525)
> at
> org.apache.hadoop.security.UserGroupInformation.doAs(UserGroupInformation.java:1953)
> at
> org.apache.hive.service.cli.session.HiveSessionProxy.invoke(HiveSessionProxy.java:59)
> at jdk.proxy2/jdk.proxy2.$Proxy129.executeStatement(Unknown Source)
> at
> org.apache.hive.service.cli.operation.hplsql.HplSqlQueryExecutor.executeQuery(HplSqlQueryExecutor.java:68)
> at org.apache.hive.hplsql.Stmt.insertValues(Stmt.java:821)
> at org.apache.hive.hplsql.Stmt.insert(Stmt.java:732)
> at org.apache.hive.hplsql.Exec.visitInsert_stmt(Exec.java:1210)
> at org.apache.hive.hplsql.Exec.visitInsert_stmt(Exec.java:96)
> at
> org.apache.hive.hplsql.HplsqlParser$Insert_stmtContext.accept(HplsqlParser.java:10977)
> at
> org.antlr.v4.runtime.tree.AbstractParseTreeVisitor.visitChildren(AbstractParseTreeVisitor.java:46)
> at org.apache.hive.hplsql.Exec.visitStmt(Exec.java:1103)
> at org.apache.hive.hplsql.Exec.visitStmt(Exec.java:96)
> at
> org.apache.hive.hplsql.HplsqlParser$StmtContext.accept(HplsqlParser.java:1054)
> at
> org.antlr.v4.runtime.tree.AbstractParseTreeVisitor.visitChildren(AbstractParseTreeVisitor.java:46)
> at
> org.apache.hive.hplsql.HplsqlBaseVisitor.visitBlock(HplsqlBaseVisitor.java:27)
> at
> org.apache.hive.hplsql.HplsqlParser$BlockContext.accept(HplsqlParser.java:473)
> at
> org.antlr.v4.runtime.tree.AbstractParseTreeVisitor.visitChildren(AbstractParseTreeVisitor.java:46)
> at org.apache.hive.hplsql.Exec.visitProgram(Exec.java:999)
> at org.apache.hive.hplsql.Exec.visitProgram(Exec.java:96)
> at
> org.apache.hive.hplsql.HplsqlParser$ProgramContext.accept(HplsqlParser.java:414)
> at
> org.antlr.v4.runtime.tree.AbstractParseTreeVisitor.visit(AbstractParseTreeVisitor.java:18)
> at org.apache.hive.hplsql.Exec.evaluate(Exec.java:817)
> at org.apache.hive.hplsql.Exec.parseAndEval(Exec.java:796)
> at
> org.apache.hive.service.cli.operation.hplsql.HplSqlOperation.interpret(HplSqlOperation.java:97)
> at
> org.apache.hive.service.cli.operation.hplsql.HplSqlOperation$BackgroundWork.lambda$run$0(HplSqlOperation.java:206)
> at
> java.base/java.security.AccessController.doPrivileged(AccessController.java:714)
> at java.base/javax.security.auth.Subject.doAs(Subject.java:525)
> at
> org.apache.hadoop.security.UserGroupInformation.doAs(UserGroupInformation.java:1953)
> at
> org.apache.hive.service.cli.operation.hplsql.HplSqlOperation$BackgroundWork.run(HplSqlOperation.java:218)
> at
> java.base/java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:572)
> at java.base/java.util.concurrent.FutureTask.run(FutureTask.java:317)
> at
> java.base/java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1144)
> at
> java.base/java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:642)
> at java.base/java.lang.Thread.run(Thread.java:1583)
> Caused by: org.apache.hadoop.hive.ql.metadata.InvalidTableException: Table
> not found abc
> at org.apache.hadoop.hive.ql.metadata.Hive.getTable(Hive.java:1798)
> at
> org.apache.hadoop.hive.ql.parse.CalcitePlanner.getTableObjectByName(CalcitePlanner.java:5110)
> at
> org.apache.hadoop.hive.ql.parse.SemanticAnalyzer.getTableObjectByName(SemanticAnalyzer.java:12766)
> at
> org.apache.hadoop.hive.ql.parse.SemanticAnalyzer.handleInsertStatementSpecPhase1(SemanticAnalyzer.java:2147)
> ... 61 more
> INFO : Completed compiling
> command(queryId=hive_20260309171813_f9617ffb-796d-418e-a787-0474b49dc134);
> Time taken: 1.91 seconds
> INFO : ERRORCODE: -1
> INFO : SQLCODE: -1
> INFO : Compiling
> command(queryId=hive_20260309171813_f9617ffb-796d-418e-a787-0474b49dc134):
> INSERT INTO TABLE def VALUES('Tbl2 Not Exists')
> ERROR : FAILED: SemanticException
> org.apache.hadoop.hive.ql.metadata.InvalidTableException: Table not found def
> org.apache.hadoop.hive.ql.parse.SemanticException:
> org.apache.hadoop.hive.ql.metadata.InvalidTableException: Table not found def
> at
> org.apache.hadoop.hive.ql.parse.SemanticAnalyzer.handleInsertStatementSpecPhase1(SemanticAnalyzer.java:2150)
> at
> org.apache.hadoop.hive.ql.parse.SemanticAnalyzer.doPhase1(SemanticAnalyzer.java:1846)
> at
> org.apache.hadoop.hive.ql.parse.SemanticAnalyzer.doPhase1(SemanticAnalyzer.java:2109)
> at
> org.apache.hadoop.hive.ql.parse.SemanticAnalyzer.doPhase1(SemanticAnalyzer.java:2109)
> at
> org.apache.hadoop.hive.ql.parse.SemanticAnalyzer.doPhase1(SemanticAnalyzer.java:1744)
> at
> org.apache.hadoop.hive.ql.parse.SemanticAnalyzer.analyzeAndResolveChildTree(SemanticAnalyzer.java:13057)
> at
> org.apache.hadoop.hive.ql.parse.SemanticAnalyzer.genResolvedParseTree(SemanticAnalyzer.java:13042)
> at
> org.apache.hadoop.hive.ql.parse.SemanticAnalyzer.analyzeInternal(SemanticAnalyzer.java:13171)
> at
> org.apache.hadoop.hive.ql.parse.CalcitePlanner.analyzeInternal(CalcitePlanner.java:481)
> at
> org.apache.hadoop.hive.ql.parse.BaseSemanticAnalyzer.analyze(BaseSemanticAnalyzer.java:358)
> at org.apache.hadoop.hive.ql.Compiler.analyze(Compiler.java:224)
> at org.apache.hadoop.hive.ql.Compiler.compile(Compiler.java:109)
> at org.apache.hadoop.hive.ql.Driver.compile(Driver.java:498)
> at org.apache.hadoop.hive.ql.Driver.compileInternal(Driver.java:450)
> at org.apache.hadoop.hive.ql.Driver.compileAndRespond(Driver.java:414)
> at org.apache.hadoop.hive.ql.Driver.compileAndRespond(Driver.java:408)
> at
> org.apache.hadoop.hive.ql.reexec.ReExecDriver.compileAndRespond(ReExecDriver.java:126)
> at
> org.apache.hive.service.cli.operation.SQLOperation.prepare(SQLOperation.java:205)
> at
> org.apache.hive.service.cli.operation.SQLOperation.runInternal(SQLOperation.java:268)
> at
> org.apache.hive.service.cli.operation.Operation.run(Operation.java:286)
> at
> org.apache.hive.service.cli.session.HiveSessionImpl.executeStatementInternal(HiveSessionImpl.java:558)
> at
> org.apache.hive.service.cli.session.HiveSessionImpl.executeStatement(HiveSessionImpl.java:526)
> at
> java.base/jdk.internal.reflect.DirectMethodHandleAccessor.invoke(DirectMethodHandleAccessor.java:103)
> at java.base/java.lang.reflect.Method.invoke(Method.java:580)
> at
> org.apache.hive.service.cli.session.HiveSessionProxy.invoke(HiveSessionProxy.java:78)
> at
> org.apache.hive.service.cli.session.HiveSessionProxy$1.run(HiveSessionProxy.java:63)
> at
> java.base/java.security.AccessController.doPrivileged(AccessController.java:714)
> at java.base/javax.security.auth.Subject.doAs(Subject.java:525)
> at
> org.apache.hadoop.security.UserGroupInformation.doAs(UserGroupInformation.java:1953)
> at
> org.apache.hive.service.cli.session.HiveSessionProxy.invoke(HiveSessionProxy.java:59)
> at jdk.proxy2/jdk.proxy2.$Proxy129.executeStatement(Unknown Source)
> at
> org.apache.hive.service.cli.operation.hplsql.HplSqlQueryExecutor.executeQuery(HplSqlQueryExecutor.java:68)
> at org.apache.hive.hplsql.Stmt.insertValues(Stmt.java:821)
> at org.apache.hive.hplsql.Stmt.insert(Stmt.java:732)
> at org.apache.hive.hplsql.Exec.visitInsert_stmt(Exec.java:1210)
> at org.apache.hive.hplsql.Exec.visitInsert_stmt(Exec.java:96)
> at
> org.apache.hive.hplsql.HplsqlParser$Insert_stmtContext.accept(HplsqlParser.java:10977)
> at
> org.antlr.v4.runtime.tree.AbstractParseTreeVisitor.visitChildren(AbstractParseTreeVisitor.java:46)
> at org.apache.hive.hplsql.Exec.visitStmt(Exec.java:1103)
> at org.apache.hive.hplsql.Exec.visitStmt(Exec.java:96)
> at
> org.apache.hive.hplsql.HplsqlParser$StmtContext.accept(HplsqlParser.java:1054)
> at
> org.antlr.v4.runtime.tree.AbstractParseTreeVisitor.visitChildren(AbstractParseTreeVisitor.java:46)
> at
> org.apache.hive.hplsql.HplsqlBaseVisitor.visitBlock(HplsqlBaseVisitor.java:27)
> at
> org.apache.hive.hplsql.HplsqlParser$BlockContext.accept(HplsqlParser.java:473)
> at
> org.antlr.v4.runtime.tree.AbstractParseTreeVisitor.visitChildren(AbstractParseTreeVisitor.java:46)
> at org.apache.hive.hplsql.Exec.visitProgram(Exec.java:999)
> at org.apache.hive.hplsql.Exec.visitProgram(Exec.java:96)
> at
> org.apache.hive.hplsql.HplsqlParser$ProgramContext.accept(HplsqlParser.java:414)
> at
> org.antlr.v4.runtime.tree.AbstractParseTreeVisitor.visit(AbstractParseTreeVisitor.java:18)
> at org.apache.hive.hplsql.Exec.evaluate(Exec.java:817)
> at org.apache.hive.hplsql.Exec.parseAndEval(Exec.java:796)
> at
> org.apache.hive.service.cli.operation.hplsql.HplSqlOperation.interpret(HplSqlOperation.java:97)
> at
> org.apache.hive.service.cli.operation.hplsql.HplSqlOperation$BackgroundWork.lambda$run$0(HplSqlOperation.java:206)
> at
> java.base/java.security.AccessController.doPrivileged(AccessController.java:714)
> at java.base/javax.security.auth.Subject.doAs(Subject.java:525)
> at
> org.apache.hadoop.security.UserGroupInformation.doAs(UserGroupInformation.java:1953)
> at
> org.apache.hive.service.cli.operation.hplsql.HplSqlOperation$BackgroundWork.run(HplSqlOperation.java:218)
> at
> java.base/java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:572)
> at java.base/java.util.concurrent.FutureTask.run(FutureTask.java:317)
> at
> java.base/java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1144)
> at
> java.base/java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:642)
> at java.base/java.lang.Thread.run(Thread.java:1583)
> Caused by: org.apache.hadoop.hive.ql.metadata.InvalidTableException: Table
> not found def
> at org.apache.hadoop.hive.ql.metadata.Hive.getTable(Hive.java:1798)
> at
> org.apache.hadoop.hive.ql.parse.CalcitePlanner.getTableObjectByName(CalcitePlanner.java:5110)
> at
> org.apache.hadoop.hive.ql.parse.SemanticAnalyzer.getTableObjectByName(SemanticAnalyzer.java:12766)
> at
> org.apache.hadoop.hive.ql.parse.SemanticAnalyzer.handleInsertStatementSpecPhase1(SemanticAnalyzer.java:2147)
> ... 61 more
> INFO : Completed compiling
> command(queryId=hive_20260309171813_f9617ffb-796d-418e-a787-0474b49dc134);
> Time taken: 0.025 seconds
> ERROR : Unhandled exception in HPL/SQL
> ERROR : 1
> ERROR : Unhandled exception in HPL/SQL
> No rows affected (2.874 seconds)
> {code}
--
This message was sent by Atlassian Jira
(v8.20.10#820010)
