1、进入hive目录
cd /usr/local/hive
2、开启hiveserver2
./bin/hive --service hiveserver2
3、打开beeline
beeline
4、连接
!connect jdbc:hive2://brace:10000
如果显示
Error: Could not open client transport with JDBC Uri: jdbc:hive2://192.168.164.134:10000: java.net .ConnectException: Connection refused (Connection refused) (state=08S01,code=0)
等待hiveserver2多运行几个sessionid,要几分钟,再试一次就可以了
查看状态:
sudo netstat -anp|grep 10000
5、在idea上连接hive数据库进行操作