Support Questions

Find answers, ask questions, and share your expertise

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
Master 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