Hadoop
binbincoder
生而无畏、战至终章
展开
-
Hive-函数大全1
1,小数的精确度round注意:精度在hive中是个很大的问题,类似这样的操作最好通过round指定精度hive> select round(8.4 % 4 , 2) from lxw_dual;hive>round(sum(score)/sum(question_total_score)100,2) accuracy_rate2,用不到的groupby的字段的显示collec...原创 2018-12-26 19:30:13 · 182 阅读 · 0 评论 -
Flume采集数据集成到Hive分桶表问题总结
Exception in thread “main” java.lang.NoClassDefFoundError: org/antlr/runtime/RecognitionException解决:拷贝hive中的jar到flume的lib下antlr-3.4.jarantlr-runtime-3.4.jarCaused by: java.lang.NullPointerExceptio...原创 2019-05-30 11:52:19 · 586 阅读 · 0 评论 -
IO error: /var/lib/hadoop-yarn/yarn-nm-recovery/yarn-nm-state/LOCK: 权限不够
Cloudera Manager启动Yarn阿报错错误日志如下:解决方案:login the related node server, check the permission and ownership of those directories /var/lib/hadoop-*, I got the following infothey are not right. so we need ...原创 2019-09-09 14:28:17 · 1592 阅读 · 0 评论