[HIVE-21723] java.lang.OutOfMemoryError: GC overhead limit exceeded

• Type: Bug
• Status: Open
• Priority: Critical
• Resolution: Unresolved
• Affects Version/s: 3.1.1
• Component/s: Query Processor
• Assignee: Unassigned
• Reporter: naga prasad
• Created: 13/May/19 10:57
• Updated: 24/Mar/21 13:42

Description

while running a long query having joins and union all, throwing the below error using Apache Hive 3.1 server. 

++[ODBC Apache Hive Wire Protocol driver][Apache Hive]Error running query: java.lang.OutOfMemoryError: GC overhead limit exceeded

Query:

select * from (select * from GTABLE where GTABLE.INTEGERCOL < 3 UNION ALL select * from GTABLE2 where GTABLE2.INTEGERCOL = ?) GTABLE JOIN GTABLE2 ON (GTABLE.INTEGERCOL = GTABLE2.INTEGERCOL);

Here the table GTABLE and GTABLE2 are having 1000 records with 15 columns.

 

The same query is executing successfully with Apache Hive 2.3