[jira] [Updated] (HAWQ-936) Add GUC for array expansion in ORCA optimizer

["Goden Yao (JIRA)" <ji...@apache.org>]

     [ https://issues.apache.org/jira/browse/HAWQ-936?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

Goden Yao updated HAWQ-936:
---------------------------
    Fix Version/s: 2.0.1.0-incubating

> Add GUC for array expansion in ORCA optimizer
> ---------------------------------------------
>
>                 Key: HAWQ-936
>                 URL: https://issues.apache.org/jira/browse/HAWQ-936
>             Project: Apache HAWQ
>          Issue Type: New Feature
>          Components: Optimizer
>            Reporter: Haisheng Yuan
>            Assignee: Venkatesh
>             Fix For: 2.0.1.0-incubating
>
>
> Consider the query with the following pattern select * from foo where foo.a IN {1,2,3,...}. Currently, when the number of constants in the IN subquery is large, the query optimization time is unacceptable. This is stopping customers from turning Orca on by default since many of the queries are generated queries with such a pattern.
> The root cause is due to the expansion of the IN subquery into an expression in disjunctive normal form. The objective of this story is to disable this expansion when the number of constants in the IN list is large.



--
This message was sent by Atlassian JIRA
(v6.3.4#6332)