[
https://issues.apache.org/jira/browse/DRILL-6574?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Arina Ielchiieva updated DRILL-6574:
------------------------------------
Summary: Add option to push LIMIT(0) on top of SCAN for a prepare statement
(was: Add LIMIT(0) on top of SCAN for a prepare statement)
> Add option to push LIMIT(0) on top of SCAN for a prepare statement
> ------------------------------------------------------------------
>
> Key: DRILL-6574
> URL: https://issues.apache.org/jira/browse/DRILL-6574
> Project: Apache Drill
> Issue Type: Improvement
> Affects Versions: 1.13.0
> Reporter: Bohdan Kazydub
> Assignee: Bohdan Kazydub
> Priority: Major
> Labels: doc-impacting
>
> Currently prepare statements use LIMIT 0 to get the result schema. Adding
> LIMIT(0) on top of SCAN causes an early termination of the query.
> Create an option "planner.enable_limit0_on_scan", enabled by default. Change
> "planner.enable_limit0_optimization" option to be enabled by default.
> LIMIT(0) on SCAN for UNION and complex functions are disabled i.e. UNION and
> complex functions need data to produce result schema.
> If function is unsupported, the plan won't be affected.
--
This message was sent by Atlassian JIRA
(v7.6.3#76005)
