You are viewing a plain text version of this content. The canonical link for it is here.
Posted to issues@drill.apache.org by "Arina Ielchiieva (JIRA)" <ji...@apache.org> on 2018/07/02 10:59:00 UTC
[jira] [Updated] (DRILL-6574) Add option to push LIMIT(0) on top of
SCAN for a prepare statement
[ 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)