![](https://img-blog.csdnimg.cn/20201014180756780.png?x-oss-process=image/resize,m_fixed,h_64,w_64)
日常改BUG
北慕辰
优秀的发挥,失败的积累,每天都很完美。
展开
-
[Err] 1055 - Expression #1 of ORDER BY clause is not in GROUP BY clause and contains nonaggregated
使用MySQL5.7创建表时报错:[Err] 1055 - Expression #1 of ORDER BY clause is not in GROUP BY clause and contains nonaggregated column ‘information_schema.PROFILING.SEQ’ which is not functionally dependent on columns in GROUP BY clause; this is incompatible with sql_m原创 2021-08-09 14:53:18 · 444 阅读 · 0 评论 -
安装JDK1.8报错Error: could not find java.dll Error: Could not find Java SE Runtime Environment.
最近再给电脑重新安转JDK时,配置好环境变量后,进入cmd运行Java时报错C:\Users\Administrator>javaError: could not find java.dllError: Could not find Java SE Runtime Environment.随后检查了jdk的环境配置看有没有报错发现没错,这就奇了怪了啊,最后询问度娘后发现,原来是这个坑把JDK JRE的路劲上移到这个之前后,再尝试就好了总结:原来是在运行时,系统自动的寻找到这个路径原创 2021-06-21 17:30:44 · 2930 阅读 · 0 评论 -
Hive报错:Execution Error, return code 2 from org.apache.hadoop.hive.ql.exec.mr.MapRedTask MapReduce
最近在做hive练习题时使用hive查询报错Hadoop job information for Stage-3: number of mappers: 0; number of reducers: 02021-05-18 19:23:54,652 Stage-3 map = 0%, reduce = 0%Ended Job = job_1621330130219_0008 with errorsError during job, obtaining debugging information…原创 2021-05-18 23:34:59 · 3269 阅读 · 1 评论 -
hive启动报错/tmp/hive on HDFS should be writable
给hadoop格式化后,重启虚拟机后启动hive报错,,,显示系统用户没有写的权限Caused by: java.lang.RuntimeException: The root scratch dir: /tmp/hive on HDFS should be writable. Currentpermissions are: rwx------ at org.apache.hadoop.hive.ql.session.SessionState.createRootHDFSDir(SessionState原创 2021-05-18 23:00:10 · 1450 阅读 · 0 评论 -
datanode无法启动解决方法
今天运行了hadoop,在执行start-all.sh了后jps没有datanode???查看了日志后发现datanode地址解析出错了,,??然后查看主机和个节点的hosts配置发现没有错,那么这是怎么回事尼?最后决定重新格式化一下看看,首先删除了主机以及各个节点的tmp目录里的内容,再重新格式化hdfs namenode -format 后就又好了,神奇!查看子节点的jps...原创 2021-05-18 19:40:54 · 1337 阅读 · 0 评论