为什么“分析表”没有任何输出?

发布于 2025-01-14 19:15:06 字数 1438 浏览 0 评论 0原文

我在表上使用分析命令,但结果除了 OK 之外没有显示任何内容。这是为什么呢? 表business包含一些具有原始类型的简单列。

hive> ANALYZE TABLE business COMPUTE STATISTICS FOR COLUMNS;
Query ID = cloudera_20220315214949_eb44f89e-0c4c-44d1-bf7e-7c15a9f6af61
Total jobs = 1
Launching Job 1 out of 1
Number of reduce tasks determined at compile time: 1
In order to change the average load for a reducer (in bytes):
  set hive.exec.reducers.bytes.per.reducer=<number>
In order to limit the maximum number of reducers:
  set hive.exec.reducers.max=<number>
In order to set a constant number of reducers:
  set mapreduce.job.reduces=<number>
Starting Job = job_1647302088953_0004, Tracking URL = http://quickstart.cloudera:8088/proxy/application_1647302088953_0004/
Kill Command = /usr/lib/hadoop/bin/hadoop job  -kill job_1647302088953_0004
Hadoop job information for Stage-0: number of mappers: 1; number of reducers: 1
2022-03-15 21:49:45,229 Stage-0 map = 0%,  reduce = 0%
2022-03-15 21:49:49,328 Stage-0 map = 100%,  reduce = 0%, Cumulative CPU 1.43 sec
2022-03-15 21:49:53,424 Stage-0 map = 100%,  reduce = 100%, Cumulative CPU 2.31 sec
MapReduce Total cumulative CPU time: 2 seconds 310 msec
Ended Job = job_1647302088953_0004
MapReduce Jobs Launched: 
Stage-Stage-0: Map: 1  Reduce: 1   Cumulative CPU: 2.31 sec   HDFS Read: 10383 HDFS Write: 53 SUCCESS
Total MapReduce CPU Time Spent: 2 seconds 310 msec
OK
Time taken: 14.166 seconds
hive>

I am using analyze command on table, but the results shows nothing except OK. This is why?
The table business contains some simple columns with primitive type.

hive> ANALYZE TABLE business COMPUTE STATISTICS FOR COLUMNS;
Query ID = cloudera_20220315214949_eb44f89e-0c4c-44d1-bf7e-7c15a9f6af61
Total jobs = 1
Launching Job 1 out of 1
Number of reduce tasks determined at compile time: 1
In order to change the average load for a reducer (in bytes):
  set hive.exec.reducers.bytes.per.reducer=<number>
In order to limit the maximum number of reducers:
  set hive.exec.reducers.max=<number>
In order to set a constant number of reducers:
  set mapreduce.job.reduces=<number>
Starting Job = job_1647302088953_0004, Tracking URL = http://quickstart.cloudera:8088/proxy/application_1647302088953_0004/
Kill Command = /usr/lib/hadoop/bin/hadoop job  -kill job_1647302088953_0004
Hadoop job information for Stage-0: number of mappers: 1; number of reducers: 1
2022-03-15 21:49:45,229 Stage-0 map = 0%,  reduce = 0%
2022-03-15 21:49:49,328 Stage-0 map = 100%,  reduce = 0%, Cumulative CPU 1.43 sec
2022-03-15 21:49:53,424 Stage-0 map = 100%,  reduce = 100%, Cumulative CPU 2.31 sec
MapReduce Total cumulative CPU time: 2 seconds 310 msec
Ended Job = job_1647302088953_0004
MapReduce Jobs Launched: 
Stage-Stage-0: Map: 1  Reduce: 1   Cumulative CPU: 2.31 sec   HDFS Read: 10383 HDFS Write: 53 SUCCESS
Total MapReduce CPU Time Spent: 2 seconds 310 msec
OK
Time taken: 14.166 seconds
hive>

如果你对这篇内容有疑问,欢迎到本站社区发帖提问 参与讨论,获取更多帮助,或者扫码二维码加入 Web 技术交流群。

扫码二维码加入Web技术交流群

发布评论

需要 登录 才能够评论, 你可以免费 注册 一个本站的账号。
列表为空,暂无数据
我们使用 Cookies 和其他技术来定制您的体验包括您的登录状态等。通过阅读我们的 隐私政策 了解更多相关信息。 单击 接受 或继续使用网站,即表示您同意使用 Cookies 和您的相关数据。
原文