[jira] [Created] (DRILL-6574) Add LIMIT(0) on top of SCAN for a prepare statement

["Bohdan Kazydub (JIRA)" <ji...@apache.org>]

Bohdan Kazydub created DRILL-6574:
-------------------------------------

             Summary: Add 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: Task
            Reporter: Bohdan Kazydub
            Assignee: Bohdan Kazydub


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)