naga prasad created HIVE-21723: ---------------------------------- Summary: java.lang.OutOfMemoryError: GC overhead limit exceeded Key: HIVE-21723 URL: https://issues.apache.org/jira/browse/HIVE-21723 Project: Hive Issue Type: Bug Components: Query Processor Affects Versions: 3.1.1 Reporter: naga prasad
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 -- This message was sent by Atlassian JIRA (v7.6.3#76005)