You are viewing a plain text version of this content. The canonical link for it is here.
Posted to issues@hive.apache.org by "Krisztian Kasa (Jira)" <ji...@apache.org> on 2024/10/17 14:53:00 UTC
[jira] [Resolved] (HIVE-28573) Unable to execute HPLSQl queries when hive authorization is enabled.
[ https://issues.apache.org/jira/browse/HIVE-28573?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Krisztian Kasa resolved HIVE-28573.
-----------------------------------
Fix Version/s: 4.1.0
Resolution: Fixed
Merged to master. Thanks [~Dayakar] for the patch and [~difin] for the review.
> Unable to execute HPLSQl queries when hive authorization is enabled.
> --------------------------------------------------------------------
>
> Key: HIVE-28573
> URL: https://issues.apache.org/jira/browse/HIVE-28573
> Project: Hive
> Issue Type: Bug
> Security Level: Public(Viewable by anyone)
> Components: hpl/sql
> Reporter: Dayakar M
> Assignee: Dayakar M
> Priority: Major
> Labels: pull-request-available
> Fix For: 4.1.0
>
>
> Unable to execute HPLSQl queries when hive authorization is enabled.
> Below exception is present in the HS2 logs
> {noformat}
> ERROR [HiveServer2-Background-Pool: Thread-886] hplsql.HplSqlOperation: Error running hive query
> org.apache.hive.service.cli.HiveSQLException: Error running HPL/SQL operation
> at org.apache.hive.service.cli.operation.hplsql.HplSqlOperation.interpret(HplSqlOperation.java:111) ~[hive-service-4.1.0-SNAPSHOT.jar:4.1.0-SNAPSHOT]
> at org.apache.hive.service.cli.operation.hplsql.HplSqlOperation.access$500(HplSqlOperation.java:54) ~[hive-service-4.1.0-SNAPSHOT.jar:4.1.0-SNAPSHOT]
> at org.apache.hive.service.cli.operation.hplsql.HplSqlOperation$BackgroundWork.lambda$run$0(HplSqlOperation.java:207) ~[hive-service-4.1.0-SNAPSHOT.jar:4.1.0-SNAPSHOT]
> at java.security.AccessController.doPrivileged(Native Method) ~[?:1.8.0_292]
> .
> .
> .
> Caused by: java.lang.IllegalArgumentException: Cannot modify QUERY_EXECUTOR at runtime. It is not in list of params that are allowed to be modified at runtime
> at org.apache.hadoop.hive.conf.HiveConf.verifyAndSet(HiveConf.java:6075) ~[hive-common-4.1.0-SNAPSHOT.jar:4.1.0-SNAPSHOT]
> at org.apache.hadoop.hive.ql.QueryState$Builder.build(QueryState.java:342) ~[hive-exec-4.1.0-SNAPSHOT.jar:4.1.0-SNAPSHOT]
> at org.apache.hive.service.cli.operation.Operation.<init>(Operation.java:112) ~[hive-service-4.1.0-SNAPSHOT.jar:4.1.0-SNAPSHOT]
> at org.apache.hive.service.cli.operation.ExecuteStatementOperation.<init>(ExecuteStatementOperation.java:56) ~[hive-service-4.1.0-SNAPSHOT.jar:4.1.0-SNAPSHOT]
> at org.apache.hive.service.cli.operation.SQLOperation.<init>(SQLOperation.java:118) ~[hive-service-4.1.0-SNAPSHOT.jar:4.1.0-SNAPSHOT]
> at org.apache.hive.service.cli.operation.ExecuteStatementOperation.newExecuteStatementOperation(ExecuteStatementOperation.java:96) ~[hive-service-4.1.0-SNAPSHOT.jar:4.1.0-SNAPSHOT]
> at org.apache.hive.service.cli.operation.OperationManager.newExecuteStatementOperation(OperationManager.java:111) ~[hive-service-4.1.0-SNAPSHOT.jar:4.1.0-SNAPSHOT]
> at org.apache.hive.service.cli.session.HiveSessionImpl.executeStatementInternal(HiveSessionImpl.java:554) ~[hive-service-4.1.0-SNAPSHOT.jar:4.1.0-SNAPSHOT]
> at org.apache.hive.service.cli.session.HiveSessionImpl.executeStatement(HiveSessionImpl.java:526) ~[hive-service-4.1.0-SNAPSHOT.jar:4.1.0-SNAPSHOT]
> at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) ~[?:1.8.0_292]
> at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62) ~[?:1.8.0_292]
> at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) ~[?:1.8.0_292]
> at java.lang.reflect.Method.invoke(Method.java:498) ~[?:1.8.0_292]
> at org.apache.hive.service.cli.session.HiveSessionProxy.invoke(HiveSessionProxy.java:78) ~[hive-service-4.1.0-SNAPSHOT.jar:4.1.0-SNAPSHOT]
> at org.apache.hive.service.cli.session.HiveSessionProxy.access$000(HiveSessionProxy.java:36) ~[hive-service-4.1.0-SNAPSHOT.jar:4.1.0-SNAPSHOT]
> at org.apache.hive.service.cli.session.HiveSessionProxy$1.run(HiveSessionProxy.java:63) ~[hive-service-4.1.0-SNAPSHOT.jar:4.1.0-SNAPSHOT]
> at java.security.AccessController.doPrivileged(Native Method) ~[?:1.8.0_292]
> at javax.security.auth.Subject.doAs(Subject.java:422) ~[?:1.8.0_292]
> at org.apache.hadoop.security.UserGroupInformation.doAs(UserGroupInformation.java:1899) ~[hadoop-common-3.3.6.jar:?]
> at org.apache.hive.service.cli.session.HiveSessionProxy.invoke(HiveSessionProxy.java:59) ~[hive-service-4.1.0-SNAPSHOT.jar:4.1.0-SNAPSHOT]
> at com.sun.proxy.$Proxy126.executeStatement(Unknown Source) ~[?:?]
> at org.apache.hive.service.cli.operation.hplsql.HplSqlQueryExecutor.executeQuery(HplSqlQueryExecutor.java:68) ~[hive-service-4.1.0-SNAPSHOT.jar:4.1.0-SNAPSHOT]
> at org.apache.hive.hplsql.Stmt.drop(Stmt.java:408) ~[hive-hplsql-4.1.0-SNAPSHOT.jar:4.1.0-SNAPSHOT]
> at org.apache.hive.hplsql.Exec.visitDrop_stmt(Exec.java:1362) ~[hive-hplsql-4.1.0-SNAPSHOT.jar:4.1.0-SNAPSHOT]
> at org.apache.hive.hplsql.Exec.visitDrop_stmt(Exec.java:96) ~[hive-hplsql-4.1.0-SNAPSHOT.jar:4.1.0-SNAPSHOT]
> at org.apache.hive.hplsql.HplsqlParser$Drop_stmtContext.accept(HplsqlParser.java:10152) ~[hive-hplsql-4.1.0-SNAPSHOT.jar:4.1.0-SNAPSHOT]
> at org.antlr.v4.runtime.tree.AbstractParseTreeVisitor.visitChildren(AbstractParseTreeVisitor.java:46) ~[antlr4-runtime-4.9.3.jar:4.9.3]
> at org.apache.hive.hplsql.Exec.visitStmt(Exec.java:1103) ~[hive-hplsql-4.1.0-SNAPSHOT.jar:4.1.0-SNAPSHOT]
> at org.apache.hive.hplsql.Exec.visitStmt(Exec.java:96) ~[hive-hplsql-4.1.0-SNAPSHOT.jar:4.1.0-SNAPSHOT]
> at org.apache.hive.hplsql.HplsqlParser$StmtContext.accept(HplsqlParser.java:1054) ~[hive-hplsql-4.1.0-SNAPSHOT.jar:4.1.0-SNAPSHOT]
> at org.antlr.v4.runtime.tree.AbstractParseTreeVisitor.visitChildren(AbstractParseTreeVisitor.java:46) ~[antlr4-runtime-4.9.3.jar:4.9.3]
> at org.apache.hive.hplsql.HplsqlBaseVisitor.visitBlock(HplsqlBaseVisitor.java:27) ~[hive-hplsql-4.1.0-SNAPSHOT.jar:4.1.0-SNAPSHOT]
> at org.apache.hive.hplsql.HplsqlParser$BlockContext.accept(HplsqlParser.java:473) ~[hive-hplsql-4.1.0-SNAPSHOT.jar:4.1.0-SNAPSHOT]
> at org.antlr.v4.runtime.tree.AbstractParseTreeVisitor.visitChildren(AbstractParseTreeVisitor.java:46) ~[antlr4-runtime-4.9.3.jar:4.9.3]
> at org.apache.hive.hplsql.Exec.visitProgram(Exec.java:999) ~[hive-hplsql-4.1.0-SNAPSHOT.jar:4.1.0-SNAPSHOT]
> at org.apache.hive.hplsql.Exec.visitProgram(Exec.java:96) ~[hive-hplsql-4.1.0-SNAPSHOT.jar:4.1.0-SNAPSHOT]
> at org.apache.hive.hplsql.HplsqlParser$ProgramContext.accept(HplsqlParser.java:414) ~[hive-hplsql-4.1.0-SNAPSHOT.jar:4.1.0-SNAPSHOT]
> at org.antlr.v4.runtime.tree.AbstractParseTreeVisitor.visit(AbstractParseTreeVisitor.java:18) ~[antlr4-runtime-4.9.3.jar:4.9.3]
> at org.apache.hive.hplsql.Exec.evaluate(Exec.java:817) ~[hive-hplsql-4.1.0-SNAPSHOT.jar:4.1.0-SNAPSHOT]
> at org.apache.hive.hplsql.Exec.parseAndEval(Exec.java:796) ~[hive-hplsql-4.1.0-SNAPSHOT.jar:4.1.0-SNAPSHOT]
> at org.apache.hive.service.cli.operation.hplsql.HplSqlOperation.interpret(HplSqlOperation.java:98) ~[hive-service-4.1.0-SNAPSHOT.jar:4.1.0-SNAPSHOT]
> ... 11 more{noformat}
--
This message was sent by Atlassian Jira
(v8.20.10#820010)