Hi,
Sounds like you are asking to have the default schema be an attribute of the
user. Each time I log in, I get the "customer" schema, while each time you log
in, you get the "sales" schema. Correct?
At present, Drill has no concept of a user as an entity. Drill can perform user
authentication using an external system. But, unlike, say, Oracle or MySql,
Drill maintains no per-user properties.
Could such a feature be added? Certainly. Perhaps the data could be stored as a
LDAP attribute. Perhaps Drill could keep this information in ZooKeeper. Or,
once Drill has a metastore, user attributes could be stored there as well.
Or, are you asking that a particular schema be the default for everyone in all
sessions? That is, when either you or I log in, we are both presented with the
"customer" schema as the default. Again, this is not possible today, but a
global setting fits within Drill's existing code: just enhance the session
initiation code to consult a new System option for the global default schema.
I would recommend filing a JIRA enhancement to track this use case, whichever
is the one you want. And, if you need this feature, please consider
implementing it and offering it as a pull request.
Note that a related request would be session attributes related to tables (or
files or schemas). For example, the "all text mode" for JSON is a session
attribute. If I have file a.json that needs this mode, but file b.json that
does not, I have to remember to turn "all text mode" on and off as I switch
between files. Would be very helpful if the "all text mode" setting was an
attribute of the file, and if Drill would then enable/disable it automatically
when I query that file.
Again, today there is no good place to store that information (other than in
the script running queries or in the user's head.) Again, once Drill has a
metastore of some kind, session options could become a property of a
table/file/schema.
Thanks,
- Paul
On Saturday, August 11, 2018, 12:31:11 AM PDT, dsaivarunvishal reddy
<[email protected]> wrote:
USE schema; would change the default schema for the current session, it
would be useful if we can have ability to change the default schema to look
into through out all sessions.
