Support Questions

Find answers, ask questions, and share your expertise
Announcements
Celebrating as our community reaches 100,000 members! Thank you!

Hive insert hangs

avatar
New Contributor

Hi,
I'm using CDP 7.6.1

there is simple test, i've created a table: create test (i int);
and trying to insert one row : insert into test values (100);

 

INFO  : Compiling command(queryId=hive_20220615093104_3c30b21e-a063-46af-8adf-940cd69f4093): insert into test values (100)
INFO  : Semantic Analysis Completed (retrial = false)
INFO  : Created Hive schema: Schema(fieldSchemas:[FieldSchema(name:col1, type:int, comment:null)], properties:null)
INFO  : Completed compiling command(queryId=hive_20220615093104_3c30b21e-a063-46af-8adf-940cd69f4093); Time taken: 2.399 seconds
INFO  : Executing command(queryId=hive_20220615093104_3c30b21e-a063-46af-8adf-940cd69f4093): insert into test values (100)
INFO  : Query ID = hive_20220615093104_3c30b21e-a063-46af-8adf-940cd69f4093
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_20220615093104_3c30b21e-a063-46af-8adf-940cd69f4093
INFO  : Session is already open
INFO  : Dag name: insert into test values (100) (Stage-1)
INFO  : Status: Running (Executing on YARN cluster with App id application_1655299581639_0001)

--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
      VERTICES      MODE        STATUS  TOTAL  COMPLETED  RUNNING  PENDING FAILED KILLED
----------------------------------------------------------------------------------------
Map 1          container      INITED      1          0        0        1       0       0
Reducer 2      container      INITED      1          0        0        1       0       0
----------------------------------------------------------------------------------------
VERTICES: 00/02  [>>--------------------------] 0%    ELAPSED TIME: 1227.54 s
----------------------------------------------------------------------------------------

 

and it may lasts way longer like never end...
there is nothing interesting in hadoop-cmf-hive_on_tez-HIVESERVER2.log.out file 😞
just:
Worker thread finished one loop.

Worker thread finished one loop.
[HiveServer2-Background-Pool: Thread-168]: Map 1: 0/1 Reducer 2: 0/1
[HiveServer2-Background-Pool: Thread-169]: Map 1: 0/1 Reducer 2: 0/1

what may I tune to make it complete? what may be the reason?

1 REPLY 1

avatar
Super Collaborator

Hi,

 

We need to check the HS2 logs and application logs if it is throwing any errors/exceptions for this query.

 

Regards,

Chethan YM