[jira] [Commented] (HIVE-24031) Infinite planning time on syntactically big queries

["Stamatis Zampetakis (Jira)" <ji...@apache.org>]

    [ 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)