drill-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Bohdan Kazydub (JIRA)" <j...@apache.org>
Subject [jira] [Created] (DRILL-6574) Add LIMIT(0) on top of SCAN for a prepare statement
Date Mon, 02 Jul 2018 10:52:00 GMT
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)

Mime
View raw message