Hive 中 ANALYZE能执行但看不到统计的结果?如何才能看到统计的信息?

万木青 发布于 2018/10/19 11:14
阅读 309
收藏 0

hive> select * from adsh;
OK
1    小明    {"city":"汕头","province":"广东","area":"东部","code":118}
2    小白    {"city":"泉州","province":"福建","area":"西部","code":128}
3    小黑    {"city":"广州","province":"广东","area":"中部","code":20}
Time taken: 5.991 seconds, Fetched: 3 row(s)
hive> analyze table adsh compute statistics;
WARNING: Hive-on-MR is deprecated in Hive 2 and may not be available in the future versions. Consider using a different execution engine (i.e. spark, tez) or using Hive 1.X releases.
Query ID = hadoop_20181019110233_04c0be6b-0098-4a53-8dc1-682a37ebec49
Total jobs = 1
Launching Job 1 out of 1
Number of reduce tasks is set to 0 since there's no reduce operator
Job running in-process (local Hadoop)
2018-10-19 11:02:38,678 Stage-0 map = 0%,  reduce = 0%
2018-10-19 11:02:40,848 Stage-0 map = 100%,  reduce = 0%
Ended Job = job_local115551348_0001
MapReduce Jobs Launched: 
Stage-Stage-0:  HDFS Read: 204 HDFS Write: 65 SUCCESS
Total MapReduce CPU Time Spent: 0 msec
OK
Time taken: 8.479 seconds
 

加载中
返回顶部
顶部