[ https://issues.apache.org/jira/browse/HIVE-21723?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16838496#comment-16838496 ]
Zoltan Haindrich commented on HIVE-21723: ----------------------------------------- [~nkasinap] Could you please provide a full example? > 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 > Priority: Critical > > 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)