[
https://issues.apache.org/jira/browse/DRILL-6974?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16823116#comment-16823116
]
ASF GitHub Bot commented on DRILL-6974:
---------------------------------------
dgrinchenko commented on pull request #1763: DRILL-6974: Add possibility to
view option value via SET command
URL: https://github.com/apache/drill/pull/1763
JIRA: [DRILL-6974](https://issues.apache.org/jira/browse/DRILL-6974)
- ALTER ... RESET ... and ALTER ... SET ... sub-parsers separated to 2
different SqlCall classes with same parent SqlSetOption
- parserImpls modified to handle new syntax of ALTER... SET...
expresion:
a) ALTER ... SET option.name - option.value - setting option value
b) ALTER ... SET option.name - display option value
- Handler for SqlSetOption separated to SetOptionHandler and
ResetOptionhandler for better representation of handled statements
- Base abstract class AbstractSqlSetHandler created to not repeat
shared implementation of same functions
- SetOptionHandler covered with unit tests for each statement
form.
----------------------------------------------------------------
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.
For queries about this service, please contact Infrastructure at:
[email protected]
> SET option command
> ------------------
>
> Key: DRILL-6974
> URL: https://issues.apache.org/jira/browse/DRILL-6974
> Project: Apache Drill
> Issue Type: Improvement
> Components: SQL Parser
> Affects Versions: 1.15.0
> Reporter: benj
> Assignee: Dmytriy Grinchenko
> Priority: Major
> Labels: doc-impacting
> Fix For: 1.17.0
>
>
> It's currently possible to define options with the SQL command SET
> {code:java}
> ALTER SESSION SET `drill.exec.hashagg.fallback.enabled` = true;
> {code}
> But it's not possible to simply visualize the current value of one option
> with SHOW, we have to query like
> {code:java}
> SELECT * FROM sys.options WHERE `name` =
> 'drill.exec.hashagg.fallback.enabled';
> {code}
> Why not allow a simple
> {code:java}
> SET `drill.exec.hashagg.fallback.enabled`;
> {code}
--
This message was sent by Atlassian JIRA
(v7.6.3#76005)
