hive beeline使用

1.hadoop叢集啟用 start-all.sh

2.注意開啟hiveserver2

3.重新開啟一個連接配接，輸入beeline指令：

再輸入： !connect jdbc:hive2://hadoop1:10000/default

緊接着輸入使用者名、密碼

[[email protected] root]$ beeline 
	Beeline version 1.2.1 by Apache Hive
	beeline> !connect jdbc:hive2://hadoop1:10000/default
	Connecting to jdbc:hive2://hadoop1:10000/default
	Enter username for jdbc:hive2://hadoop1:10000/default: atguigu
	Enter password for jdbc:hive2://hadoop1:10000/default: ******
	Connected to: Apache Hive (version 1.2.1)
	Driver: Hive JDBC (version 1.2.1)
	Transaction isolation: TRANSACTION_REPEATABLE_READ
	0: jdbc:hive2://hadoop1:10000/default> [[email protected] root]$ 
           

4.第二種方式：

[[email protected] root]$ beeline -u "jdbc:hive2://localhost:10000"  -n atguigu -p  123456       
	Connecting to jdbc:hive2://localhost:10000
	Connected to: Apache Hive (version 1.2.1)
	Driver: Hive JDBC (version 1.2.1)
	Transaction isolation: TRANSACTION_REPEATABLE_READ
	Beeline version 1.2.1 by Apache Hive
	0: jdbc:hive2://localhost:10000> select * from emp;