You are viewing a plain text version of this content. The canonical link for it is here.
Posted to issues@hive.apache.org by "Tomas Hudik (Jira)" <ji...@apache.org> on 2021/03/24 13:43:00 UTC
[jira] [Commented] (HIVE-21723) java.lang.OutOfMemoryError: GC
overhead limit exceeded
[ https://issues.apache.org/jira/browse/HIVE-21723?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17307837#comment-17307837 ]
Tomas Hudik commented on HIVE-21723:
------------------------------------
[~nkasinap] - same query on the same data? I'm having similar issue on hdp-3.1.4.0-315 (Apache Hive 3.1.0)
> 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
(v8.3.4#803005)