drill-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Arina Yelchiyeva <arina.yelchiy...@gmail.com>
Subject [DISCUSS] case insensitive storage plugin and workspaces names
Date Tue, 12 Jun 2018 12:01:44 GMT
Hi all,

Currently Drill we treat storage plugin names and workspaces as
case-sensitive [1].
Names for storage plugins and workspaces are defined by the user. So we
allow to create plugin -> DFS and dfs, workspace -> tmp and TMP.
I have a suggestion to move to case insensitive approach and won't allow
creating two plugins / workspaces with the same name in different case at
least for the following reasons:
1. usually rdbms schema and table names are case insensitive and many users
are used to this approach;
2. in Drill we have INFORMATION_SCHEMA schema which is in upper case, sys
in lower case.
personally I find it's extremely inconvenient.

Also we should consider making table names case insensitive for system
schemas (info, sys).

Any thoughts?

[1] https://drill.apache.org/docs/lexical-structure/

Kind regards,

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