You are viewing a plain text version of this content. The canonical link for it is here.
Posted to issues@hive.apache.org by "Stamatis Zampetakis (Jira)" <ji...@apache.org> on 2020/09/14 14:48:00 UTC
[jira] [Resolved] (HIVE-24031) Infinite planning time on
syntactically big queries
[ https://issues.apache.org/jira/browse/HIVE-24031?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Stamatis Zampetakis resolved HIVE-24031.
----------------------------------------
Resolution: Fixed
Fixed in [587b402aa6f5357cf6bd16893606b48b3406e9e5|https://github.com/apache/hive/commit/587b402aa6f5357cf6bd16893606b48b3406e9e5].
> 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
> Labels: pull-request-available
> Fix For: 4.0.0
>
> Attachments: ASTNode_getChildren_cost.png, query_big_array_constructor.nps
>
> Time Spent: 50m
> Remaining Estimate: 0h
>
> 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)