[jira] [Created] (DRILL-1974) Have an option to provide a custom query plan for a particular SQL query

["Victoria Markman (JIRA)" <ji...@apache.org>]

Victoria Markman created DRILL-1974:
---------------------------------------

             Summary: Have an option to provide a custom query plan for a particular SQL query
                 Key: DRILL-1974
                 URL: https://issues.apache.org/jira/browse/DRILL-1974
             Project: Apache Drill
          Issue Type: Wish
          Components: Query Planning & Optimization
            Reporter: Victoria Markman
            Assignee: Jinfeng Ni


Very often 90% of the queries run just fine, but some of the queries might require special treatment due to suboptimal plan.
In these cases, we can customize the plan and run it through submit_plan. Which is great already.

However, it would be very nice to have a mechanism on the server side to associate a SQL query with that plan.
So every time we run the query - this custom plan is picked up (as opposed to plan generated by the planner)

Filing this enhancement request on behalf of Jacques.



--
This message was sent by Atlassian JIRA
(v6.3.4#6332)