drill-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Geercken, Uwe" <Uwe.Geerc...@swissport.com>
Subject Apache Drill: How does the plug-in know that an aggregate function is applied
Date Tue, 11 Aug 2015 22:14:28 GMT
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)" <jira@apache.org>
An: uwe.geercken@web.de
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)


Mime
  • Unnamed multipart/alternative (inline, None, 0 bytes)
View raw message