Member since
06-15-2022
1
Post
0
Kudos Received
0
Solutions
06-15-2022
06:56 AM
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?
... View more
Labels:
- Labels:
-
Cloudera Data Platform (CDP)