You are viewing a plain text version of this content. The canonical link for it is here.
Posted to issues@drill.apache.org by "Paul Rogers (Jira)" <ji...@apache.org> on 2020/02/25 20:00:15 UTC
[jira] [Commented] (DRILL-7603) Cannot set default schema using
REST API / Web UI
[ https://issues.apache.org/jira/browse/DRILL-7603?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17044788#comment-17044788 ]
Paul Rogers commented on DRILL-7603:
------------------------------------
Another approach, used by Hive and Impala, is to maintain session state in the client. Each query sends the default schema and session options along with the query. The result is that the back-end is completely stateless, allowing the stateless REST API (and other stateless clients) to work even with the stateful SQL model.
The one caveat is fetching data. The REST API ships all results in a single response. This does not scale for large requests.
> Cannot set 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
> Reporter: Dobes Vandermeer
> Assignee: Dobes Vandermeer
> Priority: Minor
>
> 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.
--
This message was sent by Atlassian Jira
(v8.3.4#803005)