Support Questions
Find answers, ask questions, and share your expertise

beeline query runs but no mapper reducer messages

Explorer

I am trying to run tpch

https://github.com/hortonworks/hive-testbench.git 

 

From the hive cli, I can run the workload query and I see the logs in console. It takes long to complete the query.

 

 

hive> source tpch_query4.sql;;source tpch_query5.sql;;source tpch_query6.sql;
Query ID = root_20220311074748_352585da-e509-4340-bbe6-5ec3cc938b2b
Total jobs = 1
Launching Job 1 out of 1
Tez session was closed. Reopening...
Session re-established.
Status: Running (Executing on YARN cluster with App id application_1646844788938_0698)

Map 1: 0/50	Map 4: 0/44	Reducer 2: 0/2	Reducer 3: 0/1	Reducer 5: 0/4	
Map 1: 0/50	Map 4: 0/44	Reducer 2: 0/2	Reducer 3: 0/1	Reducer 5: 0/4	
Map 1: 0/50	Map 4: 0(+5)/44	Reducer 2: 0/2	Reducer 3: 0/1	Reducer 5: 0/4	
Map 1: 0/50	Map 4: 0(+17)/44	Reducer 2: 0/2	Reducer 3: 0/1	Reducer 5: 0/

 

 

 

 

From the beeline, when I run the same the query immediately completes and there are no mapper/reducer messages. Is this expected?

 

 

[hadoop@test_machine ~]$ sudo -u hdfs beeline --verbose=true
Default hs2 connection config file not found
Beeline version 2.3.7-amzn-4 by Apache Hive
beeline> !connect jdbc:hive2://localhost:10000 -i testbench.settings
Connecting to jdbc:hive2://localhost:10000
Connected to: Apache Hive (version 2.3.7-amzn-4)
Driver: Hive JDBC (version 2.3.7-amzn-4)
Transaction isolation: TRANSACTION_REPEATABLE_READ
0: jdbc:hive2://localhost:10000> use tpch_flat_orc_120;
going to print operations logs
printed operations logs
Getting log thread is interrupted, since query is done!
INFO  : Compiling command(queryId=hive_20220311175652_1004bc23-6392-437e-80dc-39036a071712): use tpch_flat_orc_120
INFO  : Semantic Analysis Completed
INFO  : Returning Hive schema: Schema(fieldSchemas:null, properties:null)
INFO  : Completed compiling command(queryId=hive_20220311175652_1004bc23-6392-437e-80dc-39036a071712); Time taken: 0.014 seconds
INFO  : Concurrency mode is disabled, not creating a lock manager
INFO  : Executing command(queryId=hive_20220311175652_1004bc23-6392-437e-80dc-39036a071712): use tpch_flat_orc_120
INFO  : Starting task [Stage-0:DDL] in serial mode
INFO  : Completed executing command(queryId=hive_20220311175652_1004bc23-6392-437e-80dc-39036a071712); Time taken: 0.005 seconds
INFO  : OK
No rows affected (0.093 seconds)
0: jdbc:hive2://localhost:10000> 
0: jdbc:hive2://localhost:10000> 
0: jdbc:hive2://localhost:10000> source tpch_query2.sql;
0: jdbc:hive2://localhost:10000> 

 

 

  

0 REPLIES 0
; ;