Support Questions
Find answers, ask questions, and share your expertise
Announcements
Alert: Welcome to the Unified Cloudera Community. Former HCC members be sure to read and learn how to activate your account here.

Hive queries stuck after upgrading to HDP-3.1.0

Highlighted

Hive queries stuck after upgrading to HDP-3.1.0

Contributor

Hi Team,


We have upgrade HDP-2.6.5 to HDP-3.1.0. Upgrade was successful.

But after upgrade, Hive query got stuck for long time and never proceed, whenever we try to run insert , select count(*) command on any Hive table:

Beeline version 3.1.0.3.1.0.0-78 by Apache Hive
0: jdbc:hive2://node1.carpenter.com:2181,node> CREATE TABLE tm (a int, b int) TBLPROPERTIES
. . . . . . . . . . . . . . . . . . . . . . .> ('transactional'='true',
. . . . . . . . . . . . . . . . . . . . . . .> 'transactional_properties'='insert_only');
INFO  : Compiling command(queryId=hive_20190222095913_ac751fe4-ceda-4fbc-9623-49404106ad91): CREATE TABLE tm (a int, b int) TBLPROPERTIES
('transactional'='true',
'transactional_properties'='insert_only')
INFO  : Semantic Analysis Completed (retrial = false)
INFO  : Returning Hive schema: Schema(fieldSchemas:null, properties:null)
INFO  : Completed compiling command(queryId=hive_20190222095913_ac751fe4-ceda-4fbc-9623-49404106ad91); Time taken: 0.044 seconds
INFO  : Executing command(queryId=hive_20190222095913_ac751fe4-ceda-4fbc-9623-49404106ad91): CREATE TABLE tm (a int, b int) TBLPROPERTIES
('transactional'='true',
'transactional_properties'='insert_only')
INFO  : Starting task [Stage-0:DDL] in serial mode
INFO  : Completed executing command(queryId=hive_20190222095913_ac751fe4-ceda-4fbc-9623-49404106ad91); Time taken: 0.164 seconds
INFO  : OK
No rows affected (0.47 seconds)
0: jdbc:hive2://node1.carpenter.com:2181,node> INSERT INTO tm VALUES(1,1);
INFO  : Compiling command(queryId=hive_20190222095925_56b8233d-f6a4-412c-b87f-92121da8af3a): INSERT INTO tm VALUES(1,1)
INFO  : Semantic Analysis Completed (retrial = false)
INFO  : Returning Hive schema: Schema(fieldSchemas:[FieldSchema(name:col1, type:int, comment:null), FieldSchema(name:col2, type:int, comment:null)], properties:null)
INFO  : Completed compiling command(queryId=hive_20190222095925_56b8233d-f6a4-412c-b87f-92121da8af3a); Time taken: 0.718 seconds
INFO  : Executing command(queryId=hive_20190222095925_56b8233d-f6a4-412c-b87f-92121da8af3a): INSERT INTO tm VALUES(1,1)
INFO  : Query ID = hive_20190222095925_56b8233d-f6a4-412c-b87f-92121da8af3a
INFO  : Total jobs = 1
INFO  : Launching Job 1 out of 1
INFO  : Starting task [Stage-1:MAPRED] in serial mode
INFO  : Subscribed to counters: [] for queryId: hive_20190222095925_56b8233d-f6a4-412c-b87f-92121da8af3a
INFO  : Tez session hasn't been created yet. Opening session


Query got hung. How to solve it? Please suggest.


Thanks,

Bhushan