[CARBONDATA-1973] User Should not Be able to give the duplicate column name in partition even if its case sensitive

• Type: Bug
• Status: Resolved
• Priority: Trivial
• Resolution: Fixed
• Affects Version/s: 1.3.0
• Fix Version/s: 1.3.0
• Component/s: spark-integration
• Environment: spark-2.1
• Assignee: anubhav tarar
• Reporter: anubhav tarar
• Created: 03/Jan/18 07:17
• Updated: 16/Jan/18 15:22
• Resolved: 16/Jan/18 15:22

Description

1.carbon.sql("CREATE TABLE uniqdata_char2(name char,id int) partitioned by (NAME char)stored by 'carbondata' ")
name [uniqdata_char2]
18/01/03 12:44:44 WARN HiveExternalCatalog: Couldn't find corresponding Hive SerDe for data source provider org.apache.spark.sql.CarbonSource. Persisting data source table `default`.`uniqdata_char2` into Hive metastore in Spark SQL specific format, which is NOT compatible with Hive.
18/01/03 12:44:44 AUDIT CarbonCreateTableCommand: [anubhav-Vostro-3559][anubhav][Thread-1]Table created with Database name [default] and Table name [uniqdata_char2]
res30: org.apache.spark.sql.DataFrame = []

as we can see table get created successfully

2.try same thing on hive

carbon.sql("CREATE TABLE uniqdata_char2_hive(name char,id int) partitioned by (NAME char) ")
it gives exception

org.apache.spark.sql.AnalysisException: Found duplicate column(s) in table definition of `uniqdata_char2_hive`: name;
at org.apache.spark.sql.execution.datasources.AnalyzeCreateTable.org$apache$spark$sql$execution$datasources$AnalyzeCreateTable$$failAnalysis(rules.scala:198)

behaviour of carbondata should be similiar to hive

Issue Links

• links to: GitHub Pull Request #1777