# UserName & Password
sylgg0918 IamGeek0

# start Hadoop
/home/sylgg0918/bin/myhadoop.sh start

# start mysql
service mysqld start

# start hiveserver2
nohup hive --service hiveserver2 &

# start metastore service
nohup hive --service metastore &

# connect hive
beeline
!connect jdbc:hive2://hadoop102:10000
sylgg0918
You can just press Enter without entering a password.

#########################################
# During the testing phase, if the execution is too slow, you can enable local mode. Enter the following command in the Hive command line (effective only for the current session).
set mapreduce.framework.name=local;

# Log location
# hiveserver2 Log location /opt/module/hive-3.1.3/logs

Untitled

1. Introduction to Hive

2. Hive Installation

3. Hive Tips and Tricks

4. DDL(Data Definition Language)

5. DML(Data Manipulation Language)

6. Query

7. Functions

8. Partitioned tables and bucketed tables.

9. File formats and compression.

10. Enterprise-level tuning.