Dayakar M created HIVE-29555:
--------------------------------
Summary: [HPLSQL]Errorcode handling is not proper in HPLSQL.
Key: HIVE-29555
URL: https://issues.apache.org/jira/browse/HIVE-29555
Project: Hive
Issue Type: Bug
Components: hpl/sql
Reporter: Dayakar M
Assignee: Dayakar M
When _seterror_ is configured for _hplsql.onerror_ then for the failed
statement the errorcode is coming as -1 which is proper but after that
executing proper statement giving results but still the errorcode is coming as
-1. This is happening only the statements are executed using EXECUTE or EXECUTE
IMMEDIATE.
Please below example:
{code:java}
0: jdbc:hive2://localhost> SET hplsql.onerror='seterror';
. . . . . . . . . . . . .> EXECUTE 'select * from unknown';
. . . . . . . . . . . . .> PRINT 'Unknon Table Errorcode: ' || errorcode;
. . . . . . . . . . . . .> EXECUTE 'select * from known';
. . . . . . . . . . . . .> PRINT 'Known Table Errorcode: ' || errorcode;
. . . . . . . . . . . . .> /
INFO : Compiling
command(queryId=hive_20260409144854_ae55f178-ab87-4c6c-ae49-a618e7c80be8):
select * from unknown
ERROR : FAILED: SemanticException [Error 10001]: Line 1:14 Table not found
'unknown'
org.apache.hadoop.hive.ql.parse.SemanticException: Line 1:14 Table not found
'unknown'
at
org.apache.hadoop.hive.ql.parse.SemanticAnalyzer.getMetaData(SemanticAnalyzer.java:2479)
at
org.apache.hadoop.hive.ql.parse.SemanticAnalyzer.getMetaData(SemanticAnalyzer.java:2393)
at
org.apache.hadoop.hive.ql.parse.SemanticAnalyzer.genResolvedParseTree(SemanticAnalyzer.java:13404)
at
org.apache.hadoop.hive.ql.parse.SemanticAnalyzer.analyzeInternal(SemanticAnalyzer.java:13514)
at
org.apache.hadoop.hive.ql.parse.CalcitePlanner.analyzeInternal(CalcitePlanner.java:487)
at
org.apache.hadoop.hive.ql.parse.BaseSemanticAnalyzer.analyze(BaseSemanticAnalyzer.java:324)
at org.apache.hadoop.hive.ql.Compiler.analyze(Compiler.java:227)
at org.apache.hadoop.hive.ql.Compiler.compile(Compiler.java:108)
at org.apache.hadoop.hive.ql.Driver.compile(Driver.java:203)
at org.apache.hadoop.hive.ql.Driver.compileInternal(Driver.java:659)
at org.apache.hadoop.hive.ql.Driver.compileAndRespond(Driver.java:604)
at org.apache.hadoop.hive.ql.Driver.compileAndRespond(Driver.java:598)
at
org.apache.hadoop.hive.ql.reexec.ReExecDriver.compileAndRespond(ReExecDriver.java:126)
at
org.apache.hive.service.cli.operation.SQLOperation.prepare(SQLOperation.java:210)
at
org.apache.hive.service.cli.operation.SQLOperation.runInternal(SQLOperation.java:274)
at org.apache.hive.service.cli.operation.Operation.run(Operation.java:288)
at
org.apache.hive.service.cli.session.HiveSessionImpl.executeStatementInternal(HiveSessionImpl.java:574)
at
org.apache.hive.service.cli.session.HiveSessionImpl.executeStatement(HiveSessionImpl.java:543)
at
org.apache.hive.service.cli.operation.hplsql.HplSqlQueryExecutor.executeQuery(HplSqlQueryExecutor.java:68)
at org.apache.hive.hplsql.Stmt.exec(Stmt.java:1059)
at org.apache.hive.hplsql.Exec.visitExec_stmt(Exec.java:2064)
at org.apache.hive.hplsql.Exec.visitExec_stmt(Exec.java:96)
at
org.apache.hive.hplsql.HplsqlParser$Exec_stmtContext.accept(HplsqlParser.java:10369)
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:98)
at
org.apache.hive.service.cli.operation.hplsql.HplSqlOperation.access$400(HplSqlOperation.java:54)
at
org.apache.hive.service.cli.operation.hplsql.HplSqlOperation$BackgroundWork.lambda$run$0(HplSqlOperation.java:207)
at java.security.AccessController.doPrivileged(Native Method)
at javax.security.auth.Subject.doAs(Subject.java:422)
at
org.apache.hadoop.security.UserGroupInformation.doAs(UserGroupInformation.java:1910)
at
org.apache.hive.service.cli.operation.hplsql.HplSqlOperation$BackgroundWork.run(HplSqlOperation.java:219)
at java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:511)
at java.util.concurrent.FutureTask.run(FutureTask.java:266)
at
java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1149)
at
java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:624)
at java.lang.Thread.run(Thread.java:748)INFO : Completed compiling
command(queryId=hive_20260409144854_ae55f178-ab87-4c6c-ae49-a618e7c80be8); Time
taken: 2.918 seconds
INFO : Unknon Table Errorcode: -1
INFO : Compiling
command(queryId=hive_20260409144854_ae55f178-ab87-4c6c-ae49-a618e7c80be8):
select * from known
INFO : Semantic Analysis Completed (retrial = false)
INFO : Created Hive schema: Schema(fieldSchemas:[FieldSchema(name:known.id,
type:int, comment:null), FieldSchema(name:known.name, type:string,
comment:null)], properties:null)
INFO : Completed compiling
command(queryId=hive_20260409144854_ae55f178-ab87-4c6c-ae49-a618e7c80be8); Time
taken: 2.978 seconds
INFO : Executing
command(queryId=hive_20260409144854_ae55f178-ab87-4c6c-ae49-a618e7c80be8):
select * from known
INFO : Completed executing
command(queryId=hive_20260409144854_ae55f178-ab87-4c6c-ae49-a618e7c80be8); Time
taken: 0.092 seconds
INFO : OK
INFO : 100
INFO : ABC
INFO :
INFO : 200
INFO : XYZ
INFO :
INFO : Known Table Errorcode: -1
ERROR : Unhandled exception in HPL/SQL
No rows affected (7.612 seconds){code}
Here for for _Unknown_ table selection the errorcode is coming as -1 as the
Unlnwon table is not there
{noformat}
INFO : Unknon Table Errorcode: -1
{noformat}
but for the _Known_ table selection also the error code is coming as -1, here
the table exists and the contents also getting displayed
{noformat}
INFO : OK
INFO : 100
INFO : ABC
INFO :
INFO : 200
INFO : XYZ
INFO :
INFO : Known Table Errorcode: -1
{noformat}
--
This message was sent by Atlassian Jira
(v8.20.10#820010)
