Hello, this is very good news and exciting.
And yes Jason: instead of writing e.g. select * from `dfs.myschema`.myfile.csv' I would like to write: select * from `myfile.csv'. And it makes sense because in many cases I will spend a longer period of time in one schema, doing different queries. Or I run queries and at the end use CTAS statement to create parquet files. Specifying the storage plugin and schema once and being able to reuse it would help a lot. Regards, Uwe Gesendet: Dienstag, 11. August 2015 um 21:04 Uhr Von: "Jason Altekruse (JIRA)" <[email protected]> An: [email protected] Betreff: [jira] [Commented] (DRILL-3624) Enhance Web UI to be able to select schema ("use") [ https://issues.apache.org/jira/browse/DRILL-3624?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=14682313#comment-14682313 ] Jason Altekruse commented on DRILL-3624: ---------------------------------------- He wants to avoid using fully qualified schema names everywhere. This is possible whenever you have a session, like on the command line or in a custom JDBC application. As far as I know the web UI starts up a session for each query. This feature should fit reasonably into one of our new features, Web UI security, which we are trying to get into the next release. Up until this point we have given unlimited permissions through the Web UI, and there was no tracking of which user of the Web UI submitted a particular query. This feature fits naturally into the new model we are trying to create where a particular user signs into the web interface with a view of a subset of the system they have permissions to see, their own query profiles, the workspaces that they have permissions to query. I just confirmed with [~venki387] who is working on this feature that this is improvement likely going to be included with his work. If it is not, I will pick it up after the security portion is finished to make sure that the drill session persists across different queries issued inside of a single web UI session. > Enhance Web UI to be able to select schema ("use") > -------------------------------------------------- > > Key: DRILL-3624 > URL: https://issues.apache.org/jira/browse/DRILL-3624 > Project: Apache Drill > Issue Type: Wish > Components: Client - HTTP > Affects Versions: 1.1.0 > Reporter: Uwe Geercken > Assignee: Jason Altekruse > Priority: Minor > > it would be advantageous to be able to select a schema ("use") in the web ui, > so that the information does not always have to be specified in each query. > this could be realized e.g. through a drop down where the user selects the > schema from the list of available schemas. the ui should store this > information until a different schema is selected. -- This message was sent by Atlassian JIRA (v6.3.4#6332)
