> using column with array<string> type bucket table is created but exception thrown when select performed
> -------------------------------------------------------------------------------------------------------
>
> Key: CARBONDATA-1033
> URL:
https://issues.apache.org/jira/browse/CARBONDATA-1033> Project: CarbonData
> Issue Type: Bug
> Components: data-query
> Affects Versions: 1.1.0
> Environment: 3 node cluster
> Reporter: Chetan Bhat
> Assignee: Kunal Kapoor
> Original Estimate: 504h
> Remaining Estimate: 504h
>
> User tries to create a bucket table with array<string>.
> Table is successful as shown below.
> 0: jdbc:hive2://172.168.100.199:23040> CREATE TABLE uniqData_t4(ID Int, date Timestamp, country String,name String, phonetype String, serialname String, salary Int,mobile array<string>)USING org.apache.spark.sql.CarbonSource OPTIONS("bucketnumber"="1", "bucketcolumns"="name","tableName"="uniqData_t4");
> +---------+--+
> | Result |
> +---------+--+
> +---------+--+
> No rows selected (0.061 seconds)
> User executes select query on bucket table with column type having array<string>.
> Actual Issue :
> When user performs select query on bucket table with column type having array<string> the UncheckedExecutionException is thrown.
> 0: jdbc:hive2://172.168.100.199:23040> select count(*) from uniqData_t4;
> Error: org.spark_project.guava.util.concurrent.UncheckedExecutionException: java.lang.Exception: Do not have default and uniqdata_t4 (state=,code=0)
> 0: jdbc:hive2://172.168.100.199:23040> select * from uniqData_t4;
> Error: org.spark_project.guava.util.concurrent.UncheckedExecutionException: java.lang.Exception: Do not have default and uniqdata_t4 (state=,code=0)
> Expected : The bucket table creation with array<string> type should not be created. If its created then the select query should return correct result set without throwing exception.
Locked
