[ https://issues.apache.org/jira/browse/DRILL-6492?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Arina Ielchiieva updated DRILL-6492: ------------------------------------ Description: Storage plugin names to be case insensitive (DFS vs dfs, INFORMATION_SCHEMA vs information_schema). Workspace (schemas) names to be case insensitive (ROOT vs root, TMP vs tmp). Even if user has two directories /TMP and /tmp, he can create two workspaces but not both with tmp name. For example, tmp vs tmp_u. Table names case sensitivity are treated per plugin. For example, system plugins (information_schema, sys) table names (views, tables) should be case insensitive. Actually, currently for sys plugin table names are case insensitive, information_schema table names are case sensitive. That needs to be synchronized. For file system plugins table names must be case sensitive, since under table name we imply directory / file name and their case sensitivity depends on file system. *Documentation* https://drill.apache.org/docs/lexical-structure/ should be updated with relevant information. was: Storage plugin names to be case insensitive (DFS vs dfs, INFORMATION_SCHEMA vs information_schema). Workspace (schemas) names to be case insensitive (ROOT vs root, TMP vs tmp). Even if user has two directories /TMP and /tmp, he can create two workspaces but not both with tmp name. For example, tmp vs tmp_u. Table names case sensitivity are treated per plugin. For example, system plugins (information_schema, sys) table names (views, tables) should be case insensitive. Actually, currently for sys plugin table names are case insensitive, information_schema table names are case sensitive. That needs to be synchronized. For file system plugins table names must be case sensitive, since under table name we imply directory / file name and their case sensitivity depends on file system. > Make storage plugins names case insensitive > ------------------------------------------- > > Key: DRILL-6492 > URL: https://issues.apache.org/jira/browse/DRILL-6492 > Project: Apache Drill > Issue Type: Improvement > Affects Versions: 1.13.0 > Reporter: Arina Ielchiieva > Assignee: Arina Ielchiieva > Priority: Major > Labels: doc-impacting > Fix For: 1.14.0 > > > Storage plugin names to be case insensitive (DFS vs dfs, INFORMATION_SCHEMA > vs information_schema). > Workspace (schemas) names to be case insensitive (ROOT vs root, TMP vs tmp). > Even if user has two directories /TMP and /tmp, he can create two workspaces > but not both with tmp name. For example, tmp vs tmp_u. > Table names case sensitivity are treated per plugin. For example, system > plugins (information_schema, sys) table names (views, tables) should be case > insensitive. Actually, currently for sys plugin table names are case > insensitive, information_schema table names are case sensitive. That needs to > be synchronized. For file system plugins table names must be case sensitive, > since under table name we imply directory / file name and their case > sensitivity depends on file system. > *Documentation* > https://drill.apache.org/docs/lexical-structure/ should be updated with > relevant information. -- This message was sent by Atlassian JIRA (v7.6.3#76005)