[
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)
