hawq-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Haisheng Yuan (JIRA)" <j...@apache.org>
Subject [jira] [Created] (HAWQ-936) Add GUC for array expansion in ORCA optimizer
Date Mon, 18 Jul 2016 23:36:20 GMT
Haisheng Yuan created HAWQ-936:
----------------------------------

             Summary: 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


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)

Mime
View raw message