Summary: Hive unable to query carbondata when column names is in small letters (was: Hive unable to query carbondata when column names is in capital letters)
> Hive unable to query carbondata when column names is in small letters
> ---------------------------------------------------------------------
>
> Key: CARBONDATA-1465
> URL:
https://issues.apache.org/jira/browse/CARBONDATA-1465> Project: CarbonData
> Issue Type: Bug
> Components: hive-integration
> Affects Versions: 1.2.0
> Environment: hive 1.2 ,spark 2.1
> Reporter: anubhav tarar
> Assignee: anubhav tarar
> Priority: Trivial
> Fix For: 1.2.0
>
>
> 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)
Locked
