hive-issues mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Stamatis Zampetakis (Jira)" <j...@apache.org>
Subject [jira] [Commented] (HIVE-24031) Infinite planning time on syntactically big queries
Date Wed, 12 Aug 2020 10:22:00 GMT

    [ https://issues.apache.org/jira/browse/HIVE-24031?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17176238#comment-17176238
] 

Stamatis Zampetakis commented on HIVE-24031:
--------------------------------------------

Obviously such queries should be rather rare and usually can be avoided (using temporary tables
and other tricks) but the fact that the planner is stuck  processing the query indefinitely
is a problem that should be addressed.

> Infinite planning time on syntactically big queries
> ---------------------------------------------------
>
>                 Key: HIVE-24031
>                 URL: https://issues.apache.org/jira/browse/HIVE-24031
>             Project: Hive
>          Issue Type: Bug
>          Components: Query Planning
>            Reporter: Stamatis Zampetakis
>            Assignee: Stamatis Zampetakis
>            Priority: Major
>             Fix For: 4.0.0
>
>
> Syntactically big queries (~1 million tokens), such as the query shown below, lead to
very big (seemingly infinite) planning times.
> {code:sql}
> select posexplode(array('item1', 'item2', ..., 'item1M'));
> {code}



--
This message was sent by Atlassian Jira
(v8.3.4#803005)

Mime
View raw message