[CARBONDATA-1465] Hive unable to query carbondata when column names is in small letters

• Type: Bug
• Status: Resolved
• Priority: Trivial
• Resolution: Fixed
• Affects Version/s: 1.2.0
• Fix Version/s: 1.2.0
• Component/s: hive-integration
• Environment: hive 1.2 ,spark 2.1
• Assignee: anubhav tarar
• Reporter: anubhav tarar
• Created: 11/Sep/17 10:22
• Updated: 13/Sep/17 14:46
• Resolved: 13/Sep/17 14:46

Description

inside hive example i tried this
hiveEmbeddedServer2 = new HiveEmbeddedServer2
hiveEmbeddedServer2.start()
hiveEmbeddedServer2
.execute(s"CREATE TABLE IF NOT EXISTS TESTTABLE(ID INT,JOINNINGDATE date,COUNTRY string,NAME STRING," +
s" PHONETYPE STRING, SERIALNAME STRING, SALARY DOUBLE,BONUS DECIMAL(10,4)) ROW FORMAT " +
s"SERDE 'org.apache.carbondata.hive.CarbonHiveSerDe' STORED AS INPUTFORMAT 'org" +
s".apache.carbondata.hive.MapredCarbonInputFormat' OUTPUTFORMAT 'org.apache" +
s".carbondata.hive.MapredCarbonOutputFormat' TBLPROPERTIES ('spark.sql.sources" +
s".provider'='org.apache.spark.sql.CarbonSource')")

hiveEmbeddedServer2
.execute(s"ALTER TABLE TESTTABLE SET LOCATION " +
s"'file:///$rootPath/integration/hive/target/store/testdb/testtable' ")

hiveEmbeddedServer2.execute("SELECT name FROM TESTTABLE")

Caused by: java.lang.StringIndexOutOfBoundsException: String index out of range: -1
at java.lang.AbstractStringBuilder.substring(AbstractStringBuilder.java:935)

Issue Links

• links to: GitHub Pull Request #1347