hive只是一个客户端，没有集群的概念
Hive常用的客户端：hive/webui/beeline/Java API
beeline/Java API连上HiveServer2（HS2）就可以操作hive
1.beeline和HiveServer2配合使用
[hadoop@hadoop001 ~]$ cd $HIVE_HOME/bin
[hadoop@hadoop001 bin]$ ./hiveserver2
which: no hbase in (/home/hadoop/app/scala-2.11.8/bin:/home/hadoop/app/sqoop-1.4.6-cdh5.7.0/bin:/usr/local/protobuf/bin:/home/hadoop/app/findbugs-1.3.9/bin:/home/hadoop/app/apache-maven-3.3.9/bin:/home/hadoop/app/hive-1.1.0-cdh5.7.0/bin:/home/hadoop/app/hadoop-2.6.0/bin:/usr/java/jdk1.8.0_45/bin:/usr/java/jdk1.7.0_80/bin:/usr/lib64/qt-3.3/bin:/usr/local/bin:/bin:/usr/bin:/usr/local/sbin:/usr/sbin:/sbin:/home/hadoop/bin)
打开另一个session
1）第一种方法
[hadoop@hadoop001 ~]$ cd $HIVE_HOME/bin
[hadoop@hadoop001 bin]$ ./beeline
which: no hbase in (/home/hadoop/app/scala-2.11.8/bin:/home/hadoop/app/sqoop-1.4.6-cdh5.7.0/bin:/usr/local/protobuf/bin:/home/hadoop/app/findbugs-1.3.9/bin:/home/hadoop/app/apache-maven-3.3.9/bin:/home/hadoop/app/hive-1.1.0-cdh5.7.0/bin:/home/hadoop/app/hadoop-2.6.0/bin:/usr/java/jdk1.8.0_45/bin:/usr/java/jdk1.7.0_80/bin:/usr/lib64/qt-3.3/bin:/usr/local/bin:/bin:/usr/bin:/usr/local/sbin:/usr/sbin:/sbin:/home/hadoop/bin)
Beeline version 1.1.0-cdh5.7.0 by Apache Hive
beeline> !connect jdbc:hive2://localhost:10000 hadoop
scan complete in 17ms
Connecting to jdbc:hive2://localhost:10000
Enter password for jdbc:hive2://localhost:10000:
Connected to: Apache Hive (version 1.1.0-cdh5.7.0)
Driver: Hive JDBC (version 1.1.0-cdh5.7.0)
Transaction isolation: TRANSACTION_REPEATABLE_READ
0: jdbc:hive2://localhost:10000>
2）第二种方法
[hadoop@hadoop001 ~]$ cd $HIVE_HOME/bin
[hadoop@hadoop001 bin]$ ./beeline -u jdbc:hive2://localhost:10000 -n hadoop
which: no hbase in (/home/hadoop/app/scala-2.11.8/bin:/home/hadoop/app/sqoop-1.4.6-cdh5.7.0/bin:/usr/local/protobuf/bin:/home/hadoop/app/findbugs-1.3.9/bin:/home/hadoop/app/apache-maven-3.3.9/bin:/home/hadoop/app/hive-1.1.0-cdh5.7.0/bin:/home/hadoop/app/hadoop-2.6.0/bin:/usr/java/jdk1.8.0_45/bin:/usr/java/jdk1.7.0_80/bin:/usr/lib64/qt-3.3/bin:/usr/local/bin:/bin:/usr/bin:/usr/local/sbin:/usr/sbin:/sbin:/home/hadoop/bin)
scan complete in 13ms
Connecting to jdbc:hive2://localhost:10000
Connected to: Apache Hive (version 1.1.0-cdh5.7.0)
Driver: Hive JDBC (version 1.1.0-cdh5.7.0)
Transaction isolation: TRANSACTION_REPEATABLE_READ
Beeline version 1.1.0-cdh5.7.0 by Apache Hive
0: jdbc:hive2://localhost:10000>
查看信息
0: jdbc:hive2://localhost:10000> show tables;
+------------------+--+
| tab_name |
+------------------+--+
| hive_rownumber |
| hive_wc |
| rating_json |
| user_click1 |
| user_click_tmp1 |
| zh |
+------------------+--+
6 rows selected (12.5 seconds)
INFO : Compiling command(queryId=hadoop_20180729143030_89696039-274b-40e5-b93f-cd7ee1ea1bfb): show tables
INFO : Semantic Analysis Completed
INFO : Returning Hive schema: Schema(fieldSchemas:[FieldSchema(name:tab_name, type:string, comment:from deserializer)], properties:null)
INFO : Completed compiling command(queryId=hadoop_20180729143030_89696039-274b-40e5-b93f-cd7ee1ea1bfb); Time taken: 8.538 seconds
INFO : Concurrency mode is disabled, not creating a lock manager
INFO : Executing command(queryId=hadoop_20180729143030_89696039-274b-40e5-b93f-cd7ee1ea1bfb): show tables
INFO : Starting task [Stage-0:DDL] in serial mode
INFO : Completed executing command(queryId=hadoop_20180729143030_89696039-274b-40e5-b93f-cd7ee1ea1bfb); Time taken: 1.025 seconds
INFO : OK
关掉正在运行的服务
[hadoop@hadoop001 bin]$ jps
11168 RunJar
3362 SecondaryNameNode
3682 NodeManager
3237 DataNode
3590 ResourceManager
3144 NameNode
11418 Jps
11292 RunJar
[hadoop@hadoop001 bin]$ kill -9 11168 11292
[hadoop@hadoop001 bin]$ jps
3362 SecondaryNameNode
3682 NodeManager
11428 Jps
3237 DataNode
3590 ResourceManager
3144 NameNode
[1]+ Killed ./beeline -u jdbc:hive2://localhost:10000 -n hadoop
修改默认端口
[hadoop@hadoop001 bin]$ hiveserver2 --hiveconf hive.server2.thrift.port=14000
which: no hbase in (/home/hadoop/app/scala-2.11.8/bin:/home/hadoop/app/sqoop-1.4.6-cdh5.7.0/bin:/usr/local/protobuf/bin:/home/hadoop/app/findbugs-1.3.9/bin:/home/hadoop/app/apache-maven-3.3.9/bin:/home/hadoop/app/hive-1.1.0-cdh5.7.0/bin:/home/hadoop/app/hadoop-2.6.0/bin:/usr/java/jdk1.8.0_45/bin:/usr/java/jdk1.7.0_80/bin:/usr/lib64/qt-3.3/bin:/usr/local/bin:/bin:/usr/bin:/usr/local/sbin:/usr/sbin:/sbin:/home/hadoop/bin)
[hadoop@hadoop001 bin]$ ./beeline -u jdbc:hive2://localhost:14000 -n hadoop
which: no hbase in (/home/hadoop/app/scala-2.11.8/bin:/home/hadoop/app/sqoop-1.4.6-cdh5.7.0/bin:/usr/local/protobuf/bin:/home/hadoop/app/findbugs-1.3.9/bin:/home/hadoop/app/apache-maven-3.3.9/bin:/home/hadoop/app/hive-1.1.0-cdh5.7.0/bin:/home/hadoop/app/hadoop-2.6.0/bin:/usr/java/jdk1.8.0_45/bin:/usr/java/jdk1.7.0_80/bin:/usr/lib64/qt-3.3/bin:/usr/local/bin:/bin:/usr/bin:/usr/local/sbin:/usr/sbin:/sbin:/home/hadoop/bin)
scan complete in 29ms
Connecting to jdbc:hive2://localhost:14000
Connected to: Apache Hive (version 1.1.0-cdh5.7.0)
Driver: Hive JDBC (version 1.1.0-cdh5.7.0)
Transaction isolation: TRANSACTION_REPEATABLE_READ
Beeline version 1.1.0-cdh5.7.0 by Apache Hive
0: jdbc:hive2://localhost:14000>
2.Java API 操作Hive
import java.sql.DriverManager
object JdbcApp {
val driverName = "org.apache.hive.jdbc.HiveDriver"
def main(args: Array[String]): Unit = {
try {
Class.forName(driverName)
} catch {
case e : ClassNotFoundException =>
e.printStackTrace()
System.exit(1)
}
val con = DriverManager.getConnection("jdbc:hive2://hadoop000:10000/default", "hadoop", "")
val stmt = con.createStatement()
val tableName = "emp"
val sql = "select * from " + tableName
println("Running: " + sql)
val res = stmt.executeQuery(sql)
while (res.next()) {
println(res.getInt(1) + "\t" + res.getString(2) + "\t" + res.getString(3) + "\t"
+ res.getInt(4) + "\t" + res.getString(5) + "\t" + res.getString(6) + "\t"
+ res.getString(7) + "\t" + res.getString(8))
}
}
}
3.WEB UI
- Hive官方的不建议使用
- HUE（Hadoop User Experience）
http://github.com/cloudera/hue
- Zeppelin
功能很强大，支持的东西很多