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/04/11 01:14:00 UTC

[jira] [Reopened] (DRILL-7603) Allow setting default schema using REST API / Web UI

     [ https://issues.apache.org/jira/browse/DRILL-7603?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

Paul Rogers reopened DRILL-7603:
--------------------------------

> 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
>              Labels: ready-to-commit
>             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)