[
https://issues.apache.org/jira/browse/DRILL-7603?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17081686#comment-17081686
]
ASF GitHub Bot commented on DRILL-7603:
---------------------------------------
paul-rogers commented on issue #2052: DRILL-7603 and DRILL-7604: Add schema,
options to REST query
URL: https://github.com/apache/drill/pull/2052#issuecomment-612576587
@arina-ielchiieva, thanks much for the review. As far as I could tell, the
only UI changes in the original PR were for the default schema. It would take a
bit of effort to create a UI for a list of options. In fact, it might be better
to extend the back-end to allow the user to post a series of queries in one go,
with all but the last being trivial. This approach would be easier for humans
because there is no need to figure out how a UI maps to a command:
```
USE foo;
ALTER SESSION SET `bar` = 'mumble';
SELECT ... FROM something ...
```
For the REST API, it is probably easier to include these extras in the REST
request. A clever client can accumulate changes and include them with each
query request.
The REST API can allow additional features that the UI ignores. In the case
of options, the UI won't post any and the back-end will skip the options step.
What do you think?
Finally, thanks for pointing out DRILL-7655. How did that get filed if the
original PR never made it into master? Anyway, I agree it should be fixed and
I'll look into that for this PR.
----------------------------------------------------------------
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]
> Allow setting default schema using REST API / Web UI
> ----------------------------------------------------
>
> Key: DRILL-7603
> URL: https://issues.apache.org/jira/browse/DRILL-7603
> Project: Apache Drill
> Issue Type: Improvement
> Components: Web Server
> Affects Versions: 1.17.0
> Reporter: Dobes Vandermeer
> Assignee: Paul Rogers
> Priority: Minor
> Fix For: 1.18.0
>
>
> Currently, to set the default schema you must run the `USE <schema>` command.
> However, the Web UI and REST API do not keep a session open so the `USE`
> command does not affect the next query sent to the API.
> To support a default schema for REST API & Web UI I propose a parameter to
> the API "defaultSchema" which sets the default schema for that query.
> Example: curl -d '{"query":"SHOW
> FILES","defaultSchema":"dfs.tmp","queryType":"SQL"}' -H 'Content-Type:
> application/json' -H 'User-Name: test' localhost:8047/query.json
--
This message was sent by Atlassian Jira
(v8.3.4#803005)
