- Subscribe to RSS Feed
- Mark Question as New
- Mark Question as Read
- Float this Question for Current User
- Bookmark
- Subscribe
- Mute
- Printer Friendly Page
Hive insert hangs
- Labels:
-
Cloudera Data Platform (CDP)
Created 06-15-2022 06:56 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
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?
Created 06-23-2022 08:56 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Hi,
We need to check the HS2 logs and application logs if it is throwing any errors/exceptions for this query.
Regards,
Chethan YM
