Drill is dependent on the underlying file system's case sensitivity. On HDFS one can create 'hadoop fs -mkdir /tmp/TPCH' and /tmp/tpch which are separate directories. These could be set as workspace in Drill's storage plugin configuration and we would want the ability to query both. If we change the current behavior, we would want some way, either using back-quotes ` or other way to support that.
RDBMSs seem to have vendor-specific behavior... In MySQL [1] the database name and schema name are case-sensitive on Linux and case-insensitive on Windows. Whereas in Postgres it converts the database name and schema name to lower-case by default but one can put double-quotes to make it case-sensitive [2]. [1] https://dev.mysql.com/doc/refman/8.0/en/identifier-case-sensitivity.html [2] http://www.postgresqlforbeginners.com/2010/11/gotcha-case-sensitivity.html On Tue, Jun 12, 2018 at 5:01 AM, Arina Yelchiyeva < arina.yelchiy...@gmail.com> wrote: > 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, > Arina >
