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

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

    XMLWordPrintableJSON

Details

    • Improvement
    • Status: Closed
    • Major
    • Resolution: Fixed
    • None
    • 1.15.0
    • 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

              bohdan Bohdan Kazydub
              bohdan Bohdan Kazydub
              Votes:
              0 Vote for this issue
              Watchers:
              6 Start watching this issue

              Dates

                Created:
                Updated:
                Resolved: