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?