Uploaded image for project: 'Apache Drill'
  1. Apache Drill
  2. DRILL-6834

Introduce option to disable result set for DDL queries for JDBC connection

    Details

    • Type: Improvement
    • Status: Closed
    • Priority: Major
    • Resolution: Fixed
    • Affects Version/s: None
    • Fix Version/s: 1.15.0
    • Component/s: None

      Description

      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.return_result_set_for_ddl` is introduced. If the option is enabled (set to `true`) Drill's behaviour will be unchanged, i.e. a result set will be returned for all queries. If the option is disabled (set to `false`), CTAS, CREATE VIEW, CREATE FUNCTION, DROP TABLE, DROP VIEW, DROP FUNCTION, USE schema, SET option, REFRESH METADATA TABLE queries will not return result set but updateCount instead.

      The option affects JDBC connections only.

        Attachments

          Issue Links

            Activity

              People

              • Assignee:
                KazydubB Bohdan Kazydub
                Reporter:
                KazydubB Bohdan Kazydub
              • Votes:
                0 Vote for this issue
                Watchers:
                6 Start watching this issue

                Dates

                • Created:
                  Updated:
                  Resolved: