wget https://download.jetbrains.com/idea/ideaIU-2017.2.6-no-jdk.tar.gz

tar -zxvf ideaIU-2017.2.6-no-jdk.tar.gz -C /usr/local/

/usr/local/idea-IU-172.4574.11/bin/idea.sh

[root@d1 apache-hive-2.3.3-bin]# bin/schematool -dbType mysql -info
......
Metastore connection URL:        jdbc:mysql://localhost:3306/hive?createDatabaseIfNotExist=true&useSSL=false
Metastore Connection Driver :    com.mysql.jdbc.Driver
Metastore connection User:       hive
org.apache.hadoop.hive.metastore.HiveMetaException: Failed to get schema version, Cause:Table 'hive.VERSION' doesn't exist
Use --verbose for detailed stacktrace.
*** schemaTool failed ***
[root@d1 apache-hive-2.3.3-bin]# bin/schematool -dbType mysql -initSchema
......
Metastore connection URL:        jdbc:mysql://localhost:3306/hive?createDatabaseIfNotExist=true&useSSL=false
Metastore Connection Driver :    com.mysql.jdbc.Driver
Metastore connection User:       hive
Starting metastore schema initialization to 2.3.0
Initialization script hive-schema-2.3.0.mysql.sql
Initialization script completed
schemaTool completed
[root@d1 apache-hive-2.3.3-bin]# bin/schematool -dbType mysql -info      
......
Metastore connection URL:        jdbc:mysql://localhost:3306/hive?createDatabaseIfNotExist=true&useSSL=false
Metastore Connection Driver :    com.mysql.jdbc.Driver
Metastore connection User:       hive
Hive distribution version:       2.3.0
Metastore schema version:        2.3.0
schemaTool completed
[root@d1 apache-hive-2.3.3-bin]#

$HIVE_HOME/bin/hiveserver2 # 或者 $HIVE_HOME/bin/hive --service hiveserver2

$ ${HIVE_HOME}/bin/beeline
beeline> !connect jdbc:hive2://elk1:10000
Connecting to jdbc:hive2://elk1:10000
Enter username for jdbc:hive2://elk1:10000:
Enter password for jdbc:hive2://elk1:10000:
0: jdbc:hive2://elk1:10000> show tables;
INFO  : Compiling command(queryId=root_20200417085546_6d6a4943-74e6-47cf-9df0-b44b57a57841): show tables
INFO  : Concurrency mode is disabled, not creating a lock manager
INFO  : Semantic Analysis Completed (retrial = false)
INFO  : Returning Hive schema: Schema(fieldSchemas:[FieldSchema(name:tab_name, type:string, comment:from deserializer)], properties:null)
INFO  : Completed compiling command(queryId=root_20200417085546_6d6a4943-74e6-47cf-9df0-b44b57a57841); Time taken: 1.111 seconds
INFO  : Concurrency mode is disabled, not creating a lock manager
INFO  : Executing command(queryId=root_20200417085546_6d6a4943-74e6-47cf-9df0-b44b57a57841): show tables
INFO  : Starting task [Stage-0:DDL] in serial mode
INFO  : Completed executing command(queryId=root_20200417085546_6d6a4943-74e6-47cf-9df0-b44b57a57841); Time taken: 0.065 seconds
INFO  : OK
INFO  : Concurrency mode is disabled, not creating a lock manager
+-----------+
| tab_name  |
+-----------+
+-----------+
No rows selected (1.542 seconds)
0: jdbc:hive2://elk1:10000>

<!-- username 改为报错信息中的用户名，本例中为root -->
<property>
  <name>hadoop.proxyuser.username.groups</name>
  <value>*</value>
</property>
<property>
  <name>hadoop.proxyuser.username.hosts</name>
  <value>*</value>
</property>

<property>
  <name>hive.server2.enable.doAs</name>
  <value>FALSE</value>
  <description>
    Setting this property to true will have HiveServer2 execute
    Hive operations as the user making the calls to it.
  </description>
</property>

[root@d1 apache-hive-2.3.3-bin]# bin/hive --debug -hiveconf hive.root.logger=DEBUG,console
which: no hbase in (/usr/local/hadoop-2.9.2/bin:/usr/local/protobuf/bin:/usr/soft/zookeeper-3.4.9/bin:/usr/lib64/qt-3.3/bin:/usr/local/sbin:/usr/local/bin:/sbin:/bin:/usr/sbin:/usr/bin:/usr/local/rvm/bin:/usr/java/default/bin:/usr/soft/maven/bin:/usr/soft/node/bin:/usr/local/go/bin:/root/bin)
Listening for transport dt_socket at address: 8000

# ls ../lib/guava-19.0.jar
../lib/guava-19.0.jar
# ls $HADOOP_HOME/share/hadoop/common/lib/guava-27.0-jre.jar  
/home/liqingzhong/apps/hadoop-3.1.3/share/hadoop/common/lib/guava-27.0-jre.jar
# rm ../lib/guava-19.0.jar
# cp $HADOOP_HOME/share/hadoop/common/lib/guava-27.0-jre.jar  ../lib/