Beeline/JDBC
与Hive完全相同，只是连接端口或者zookeeper节点不同。
区别
| 不同点 | Apache Hive | HivePlus | 其他说明 |
|---|---|---|---|
| 端口 | 10000 | 9842 | |
| zooKeeperNamespace | hiveserver2 | hiveserver2-hiveplus | |
| Metastore | 9083 | 9841 |
使用方式
- 方式1： 直接连接HivePlus服务节点和端口。
beeline -u jdbc:hive2://datanode01:9842 -n hive
- 方式2： 负载方式，通过Zookeeper连接。
beeline -u "jdbc:hive2://datanode01:2181/;serviceDiscoveryMode=zooKeeper;zooKeeperNamespace=hiveserver2-hiveplus" -n hive
连接成功后，执行sql：
0: jdbc:hive2://datanode01:9842> select distinct id from t1;
INFO : Compiling command(queryId=hive_20260427031325_31b975a9-e61d-4f48-abef-160fe45f3f24): select distinct id from t1
INFO : Semantic Analysis Completed (retrial = false)
INFO : Returning Hive schema: Schema(fieldSchemas:[FieldSchema(name:id, type:int, comment:null)], properties:null)
INFO : Completed compiling command(queryId=hive_20260427031325_31b975a9-e61d-4f48-abef-160fe45f3f24); Time taken: 1.725 seconds
INFO : Executing command(queryId=hive_20260427031325_31b975a9-e61d-4f48-abef-160fe45f3f24): select distinct id from t1
INFO : Query ID = hive_20260427031325_31b975a9-e61d-4f48-abef-160fe45f3f24
INFO : Total jobs = 1
INFO : Launching Job 1 out of 1
INFO : Starting task [Stage-1:MAPRED] in serial mode
INFO : MR3Task.execute(): hive_20260427031325_31b975a9-e61d-4f48-abef-160fe45f3f24:1
INFO : Starting MR3 Session...
INFO : Finished building DAG, now submitting: hive_20260427031325_31b975a9-e61d-4f48-abef-160fe45f3f24:1
INFO : Status: Running (Executing on MR3 DAGAppMaster): hive_20260427031325_31b975a9-e61d-4f48-abef-160fe45f3f24:1
INFO : Status: Running
INFO : Map 1: -/- Reducer 2: 0/18
----------------------------------------------------------------------------------------------
VERTICES MODE STATUS TOTAL COMPLETED RUNNING PENDING FAILED KILLED
----------------------------------------------------------------------------------------------
Map 1 .......... llap Succeeded 1 1 0 0 0 0
Reducer 2 ...... llap Succeeded 18 18 0 0 0 0
----------------------------------------------------------------------------------------------
VERTICES: 02/02 [==========================>>] 100% ELAPSED TIME: 5.79 s
----------------------------------------------------------------------------------------------
INFO : Map 1: 0(+1)/1 Reducer 2: 0/18
INFO : Map 1: 0(+1)/1 Reducer 2: 0/18
INFO : Map 1: 1/1 Reducer 2: 2(+18)/18
INFO : Map 1: 1/1 Reducer 2: 18/18
INFO : Status: Succeeded
INFO : Map 1 1 task 4654 milliseconds
INFO : Reducer 2 18 tasks 756 milliseconds
INFO : Status: DAG finished successfully in 5.73 seconds
INFO :
INFO : Query Execution Summary
INFO : ----------------------------------------------------------------------------------------------
INFO : OPERATION DURATION
INFO : ----------------------------------------------------------------------------------------------
INFO : Compile Query 1.73s
INFO : Prepare Plan 0.25s
INFO : Submit Plan 0.38s
INFO : Start DAG 0.06s
INFO : Run DAG 5.73s
INFO : ----------------------------------------------------------------------------------------------
INFO :
INFO : Task Execution Summary
INFO : --------------------------------------------------------------------------------------------------------------------------------
INFO : VERTICES TOTAL_TASKS FAILED_ATTEMPTS KILLED_TASKS INPUT_RECORDS OUTPUT_RECORDS
INFO : --------------------------------------------------------------------------------------------------------------------------------
INFO : Map 1 1 0 0 1 1
INFO : Reducer 2 18 0 0 1 0
INFO : --------------------------------------------------------------------------------------------------------------------------------
INFO :
INFO : Completed executing command(queryId=hive_20260427031325_31b975a9-e61d-4f48-abef-160fe45f3f24); Time taken: 6.425 seconds
INFO : HivePlus 2.5 licensed to Public
+-----+
| id |
+-----+
| 1 |
+-----+
1 row selected (8.342 seconds)