[jira] [Commented] (DRILL-6834) Introduce option to disable result set on CTAS, create view and drop table/view etc. for JDBC connection

["ASF GitHub Bot (JIRA)" <ji...@apache.org>]

    [ https://issues.apache.org/jira/browse/DRILL-6834?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16694821#comment-16694821 ] 

ASF GitHub Bot commented on DRILL-6834:
---------------------------------------

KazydubB opened a new pull request #1549: DRILL-6834: Introduce option to disable result set on CTAS, create vi…
URL: https://github.com/apache/drill/pull/1549
 
 
   …ew and drop table/view etc. for JDBC connection
   
   -Added session-scoped option `drill.exec.fetch_resultset_for_ddl` to control whether update count or result set should be returned for JDBC connection session. By default the option is set to `true` which ensures that result set is returned;
   -Updated Drill JDBC: `DrillCursor` and `DrillStatement` to achieve desired behaviour;
   -Added query-scoped option `drill.exec.query_sqlnode_kind` to determine if query is eligible to not return result set in case if `drill.exec.fetch_resultset_for_ddl` is disabled. Eligible queries are CTAS, CREATE VIEW, CREATE FUNCTION, DROP TABLE, DROP VIEW, DROP FUNCTION, USE schema, SET option, REFRESH METADATA TABLE etc.;
   -Made `FragmentOptionManager` to have `QueryOptionManger` as fallback `OptionManager` and Updated `InMemoryOptionManager`.

----------------------------------------------------------------
This is an automated message from the Apache Git Service.
To respond to the message, please log on GitHub and use the
URL above to go to the specific comment.
 
For queries about this service, please contact Infrastructure at:
users@infra.apache.org


> Introduce option to disable result set on CTAS, create view and drop table/view etc. for JDBC connection
> --------------------------------------------------------------------------------------------------------
>
>                 Key: DRILL-6834
>                 URL: https://issues.apache.org/jira/browse/DRILL-6834
>             Project: Apache Drill
>          Issue Type: Improvement
>            Reporter: Bohdan Kazydub
>            Assignee: Bohdan Kazydub
>            Priority: Major
>              Labels: doc-impacting
>             Fix For: 1.15.0
>
>
> 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 {{`drill.exec.fetch_resultset_for_ddl`}} is introduced. If the option is enabled (set to `true`) Drill's behaviour will be unchanged, i.e. all 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 etc. queries will not return result set but {{updateCount}} instead.
> The option affects JDBC connections only.



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