[jira] [Created] (DRILL-6834) New option to disable result set on CTAS, create view and drop table/view

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

Bohdan Kazydub created DRILL-6834:
-------------------------------------

             Summary: New option to disable result set on CTAS, create view and drop table/view
                 Key: DRILL-6834
                 URL: https://issues.apache.org/jira/browse/DRILL-6834
             Project: Apache Drill
          Issue Type: Improvement
            Reporter: Bohdan Kazydub
            Assignee: Bohdan Kazydub


There are some tools (Unica, dBeaver, TalenD) that do not expect to obtain result set on CTAS query. As a result the query gets canceled. Hive, on the other hand, does not return result set for the query and these tools work well.

To improve Drill's integration with such tools a session option `exec.fetch_resultset` will be introduced. If the option is enabled (set to `true`) Drill's behaviour will be unchanged. If the option is disabled (set to `false`), CTAS, create view and drop table/view queries will not return result set but show messages instead.



--
This message was sent by Atlassian JIRA
(v7.6.3#76005)