hive为聚合函数抛出错误

fruv7luv  于 2021-06-26  发布在  Hive
关注(0)|答案(1)|浏览(326)

当我尝试使用配置单元执行非聚合命令时,查询似乎工作正常,如下所示:
从airlines\u analysis.airline中选择*;从airlines\u analysis.airline中选择airline.month;
但当我执行聚合命令时,如下所示:
从airlines\u analysis.airline中选择count(distinct uniquecarrier);
我面临以下问题:
org.apache.hive.service.cli.hivesqlexception:处理语句时出错:失败:执行错误,从org.apache.hive.service.cli.operation.operation.tosqlexception(操作)中的org.apache.hadoop.hive.ql.exec.tez.teztask返回代码1。java:380)在org.apache.hive.service.cli.operation.sqloperation.runquery(sqloperation。java:257)在org.apache.hive.service.cli.operation.sqloperation.access$800(sqloperation。java:91)在org.apache.hive.service.cli.operation.sqloperation$backgroundwork$1.run(sqloperation。java:348)位于javax.security.auth.subject.doas(subject)的java.security.accesscontroller.doprivileged(本机方法)。java:422)在org.apache.hadoop.security.usergroupinformation.doas(usergroupinformation。java:1698)在org.apache.hive.service.cli.operation.sqloperation$backgroundwork.run(sqloperation。java:362)在java.util.concurrent.executors$runnableadapter.call(executors。java:511)在java.util.concurrent.futuretask.run(futuretask。java:266)位于java.util.concurrent.threadpoolexecutor.runworker(threadpoolexecutor。java:1149)在java.util.concurrent.threadpoolexecutor$worker.run(threadpoolexecutor。java:624)在java.lang.thread.run(线程。java:748)

camsedfj

camsedfj1#

这是哪个版本的Hive?你用的是tez引擎吗?在处理庞大的数据集时,tez有时表现得很怪异。试试这个

set hive.execution.engine=mr;
select count(distinct uniquecarrier) from airlines_analysis.airline;

相关问题