[
https://issues.apache.org/jira/browse/DRILL-7603?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17046343#comment-17046343
]
ASF GitHub Bot commented on DRILL-7603:
---------------------------------------
arina-ielchiieva commented on pull request #1996: DRILL-7603: Allow default
schema to be set for HTTP queries
URL: https://github.com/apache/drill/pull/1996#discussion_r384981753
##########
File path: exec/java-exec/src/main/resources/rest/query/query.ftl
##########
@@ -83,6 +83,8 @@
Submit
</button>
<input type="checkbox" name="forceLimit" value="limit" <#if
model.isAutoLimitEnabled()>checked</#if>> Limit results to <input type="text"
id="autoLimit" name="autoLimit" min="0"
value="${model.getDefaultRowsAutoLimited()?c}" size="6" pattern="[0-9]*"> rows
<span class="glyphicon glyphicon-info-sign" title="Limits the number of records
retrieved in the query. Ignored if query has a limit already"
style="cursor:pointer"></span>
+ <label> Default Schema <input type="text" size="10" name="defaultSchema"
id="defaultSchema"> </label>
+ <span class="glyphicon glyphicon-info-sign" title="Set the default schema
used to find table names, and for SHOW FILES and SHOW TABLES"
style="cursor:pointer"></span>
Review comment:
Not particularly for that, schema can be set to avoid indicating it in
queries.
Plus I am still waiting for screenshots to see how changes will look on Web
UI.
----------------------------------------------------------------
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]
> 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)
