GitHub user manishgupta88 opened a pull request:
https://github.com/apache/incubator-carbondata/pull/526
[CARBONDATA-629] Issue with database name case sensitivity
**Analysis:** When database name is provided in any DDL/DML command, the
database name is interpreted and used in the same case as provided by the user.
This leads to different behavior in windows and unix systems as windows is case
sensitive and linux systems are case insensitive.
Consider a case for create database. Lets say database name is "Carbon".
While executing database name is provided as Carbon but while deleting or using
or creating table the case is changed to "CARbOn". In these cases system will
not behave correctly and if HDFS UI is checked the database Carbon will still
exist even after dropping database as the case for database name was different
in the 2 commands execution.
**Fix:** Always convert the database name to lower case for any DDL/DML
operation while parsing so that the behavior remains consistent.
You can merge this pull request into a Git repository by running:
$ git pull https://github.com/manishgupta88/incubator-carbondata
database_name_case_fix
Alternatively you can review and apply these changes as the patch at:
https://github.com/apache/incubator-carbondata/pull/526.patch
To close this pull request, make a commit to your master/trunk branch
with (at least) the following in the commit message:
This closes #526
----
commit 8d77f3c046c5fadb4ad659c5ae9f69d3ca08f1ed
Author: manishgupta88 <tomanishgupt...@gmail.com>
Date: 2017-01-11T16:25:36Z
Problem: Issue with database name case sensitivity
Analysis: When database name is provided in any DDL/DML command, the
database name is interpreted and used in the same case as provided by the user.
This leads to different behavior in windows and unix systems as windows is case
sensitive and linux systems are case insensitive.
Consider a case for create database. Lets say database name is "Carbon".
While executing database name is provided as Carbon but while deleting or using
or creating table the case is changed to "CARbOn". In these cases system will
not behave correctly and if HDFS UI is checked the database Carbon will still
exist even after dropping database as the case for database name was different
in the 2 commands execution.
Fix: Always convert the database name to lower case for any DDL/DML
operation while parsing so that the behavior remains consistent.
----
---
If your project is set up for it, you can reply to this email and have your
reply appear on GitHub as well. If your project does not have this feature
enabled and wishes so, or if the feature is enabled but not working, please
contact infrastructure at infrastruct...@apache.org or file a JIRA ticket
with INFRA.
---
