无法通过数据分析在ui中运行配置单元查询(即席查询)

dly7yett  于 2021-06-27  发布在  Hive
关注(0)|答案(0)|浏览(236)

我是按照官方文件安装的。我测试过了。现在我想对Hive进行一些查询。我已将配置单元安装在成功运行的同一主机上。我编辑了hiveserver2\u默认配置为:

Conn Type  : Hive Server 2 Thrift
Host       : localhost
schema     : default
login      : hive
password   :****
port       : 10000

因此,当我在data profiling->ad hoc query中运行任何查询时,我得到以下结果:

TExecuteStatementResp(status=TStatus(errorCode=1, errorMessage=u'Error while processing statement: Cannot modify airflow.ctx.task_id at runtime. It is not in list of params that are allowed to be modified at runtime', sqlState=u'42000', infoMessages=[u'*org.apache.hive.service.cli.HiveSQLException:Error while processing statement: Cannot modify airflow.ctx.task_id at runtime. It is not in list of params that are allowed to be modified at runtime:27:26',
u'org.apache.hive.service.cli.operation.Operation:toSQLException:Operation.java:335',
u'org.apache.hive.service.cli.operation.HiveCommandOperation:runInternal:HiveCommandOperation.java:116',
u'org.apache.hive.service.cli.operation.Operation:run:Operation.java:247',
u'org.apache.hive.service.cli.session.HiveSessionImpl:executeStatementInternal:HiveSessionImpl.java:575',
u'org.apache.hive.service.cli.session.HiveSessionImpl:executeStatement:HiveSessionImpl.java:550',
u'sun.reflect.GeneratedMethodAccessor95:invoke::-1',
u'sun.reflect.DelegatingMethodAccessorImpl:invoke:DelegatingMethodAccessorImpl.java:43',
u'java.lang.reflect.Method:invoke:Method.java:498',
u'org.apache.hive.service.cli.session.HiveSessionProxy:invoke:HiveSessionProxy.java:78',
u'org.apache.hive.service.cli.session.HiveSessionProxy:access$000:HiveSessionProxy.java:36',
u'org.apache.hive.service.cli.session.HiveSessionProxy$1:run:HiveSessionProxy.java:63',
u'java.security.AccessController:doPrivileged:AccessController.java:-2',
u'javax.security.auth.Subject:doAs:Subject.java:422',
u'org.apache.hadoop.security.UserGroupInformation:doAs:UserGroupInformation.java:1730',
u'org.apache.hive.service.cli.session.HiveSessionProxy:invoke:HiveSessionProxy.java:59',
u'com.sun.proxy.$Proxy46:executeStatement::-1',
u'org.apache.hive.service.cli.CLIService:executeStatement:CLIService.java:285',
u'org.apache.hive.service.cli.thrift.ThriftCLIService:ExecuteStatement:ThriftCLIService.java:567',
u'org.apache.hive.service.rpc.thrift.TCLIService$Processor$ExecuteStatement:getResult:TCLIService.java:1557',
u'org.apache.hive.service.rpc.thrift.TCLIService$Processor$ExecuteStatement:getResult:TCLIService.java:1542',
u'org.apache.thrift.ProcessFunction:process:ProcessFunction.java:39',
u'org.apache.thrift.TBaseProcessor:process:TBaseProcessor.java:39',
u'org.apache.hive.service.auth.TSetIpAddressProcessor:process:TSetIpAddressProcessor.java:56',
u'org.apache.thrift.server.TThreadPoolServer$WorkerProcess:run:TThreadPoolServer.java:286',
u'java.util.concurrent.ThreadPoolExecutor:runWorker:ThreadPoolExecutor.java:1142',
u'java.util.concurrent.ThreadPoolExecutor$Worker:run:ThreadPoolExecutor.java:617',
u'java.lang.Thread:run:Thread.java:745'], statusCode=3), operationHandle=None)

我被困在这里了。我必须采取什么步骤来解决这个问题。
p、 我可以成功地运行查询并从mysql数据库获取结果。

暂无答案!

目前还没有任何答案,快来回答吧!

相关问题