9. 修改mysql编码
只需要修改
[mysqlid]即可



ERROR 1 (HY000): Can't create/write to file './hive/db.opt' (Errcode: 2 - No such file or directory)

1) 创建目录 /var/lib/mysql/tmp

2)授权 chown mysql:mysql /var/lib/mysql/tmp

3) 在/etc/my.cnf中 [mysqld] 部分添加: tmpdir = /var/lib/mysql/tmp

4) 重启mysql

sudo systemctl restart mysqld

由于版本的原因出现下面错误

1. [ERROR] Terminal initialization failed; falling back to unsupported
   
2. java.lang.IncompatibleClassChangeError: Found class jline.Terminal, but interface was expected
   
3.         at jline.TerminalFactory.create(TerminalFactory.java:101)
   
4.         at jline.TerminalFactory.get(TerminalFactory.java:158)
   
5.         at jline.console.ConsoleReader.<init>(ConsoleReader.java:229)
   
6.         at jline.console.ConsoleReader.<init>(ConsoleReader.java:221)
   
7.         at jline.console.ConsoleReader.<init>(ConsoleReader.java:209)
   
8.         at org.apache.hadoop.hive.cli.CliDriver.setupConsoleReader(CliDriver.java:787)
   
9.         at org.apache.hadoop.hive.cli.CliDriver.executeDriver(CliDriver.java:721)
   
10.         at org.apache.hadoop.hive.cli.CliDriver.run(CliDriver.java:681)
    
11.         at org.apache.hadoop.hive.cli.CliDriver.main(CliDriver.java:621)
    
12.         at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
    
13.         at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
    
14.         at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
    
15.         at java.lang.reflect.Method.invoke(Method.java:497)
    
16.         at org.apache.hadoop.util.RunJar.run(RunJar.java:221)
    
17.         at org.apache.hadoop.util.RunJar.main(RunJar.java:136)
    
18. 
    
19. Exception in thread "main" java.lang.IncompatibleClassChangeError: Found class jline.Terminal, but interface was expected
    
20.         at jline.console.ConsoleReader.<init>(ConsoleReader.java:230)
    
21.         at jline.console.ConsoleReader.<init>(ConsoleReader.java:221)
    
22.         at jline.console.ConsoleReader.<init>(ConsoleReader.java:209)
    
23.         at org.apache.hadoop.hive.cli.CliDriver.setupConsoleReader(CliDriver.java:787)
    
24. 
    
25. 
    

复制代码

解决办法：
进入/data/hadoop/share/hadoop/yarn/lib找到 jline-0.9.94.jar 文件删除。然后在启动