[DRILL-7603] Allow setting default schema using REST API / Web UI

• Type: Improvement
• Status: Closed
• Priority: Minor
• Resolution: Fixed
• Affects Version/s: 1.17.0
• Fix Version/s: 1.18.0
• Component/s: Web Server
• Assignee: Paul Rogers
• Reporter: Dobes Vandermeer
• Reviewer: Arina Ielchiieva
• Created: 25/Feb/20 19:27
• Updated: 15/Apr/20 18:49
• Resolved: 15/Apr/20 18:49

Description

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

Issue Links

• is related to: DRILL-7655 Add Default Schema text box to Edit Query page in query profile
• links to: GitHub Pull Request #1996
• links to: GitHub Pull Request #2052