[CARBONDATA-860] Carbon with Spark2.1, select query with filter on dictionary column & order by dictionary/measure with limit is failing

• Type: Bug
• Status: Resolved
• Priority: Minor
• Resolution: Duplicate
• Fix Version/s: 1.1.0
• Assignee: Ravindra Pesala
• Reporter: Naresh P R
• Created: 05/Apr/17 07:28
• Updated: 08/May/17 17:07
• Resolved: 08/May/17 17:07

Description

Select queries are failing in Spark 2.1 with ClassCastException for dictionary Columns (UTF8String cannot be cast to Int)

eg.,
CREATE TABLE alldatatypestablesort (empno int, empname String, designation String, doj Timestamp, workgroupcategory int, workgroupcategoryname String, deptno int, deptname String, projectcode int, projectjoindate Timestamp, projectenddate Timestamp,attendance int,utilization int,salary int) STORED BY 'org.apache.carbondata.format'

Below 3 queries are failing.,
select * from alldatatypestablesort order by empname limit 2
select * from alldatatypestablesort order by salary limit 2
select * from alldatatypestablesort where empname='arvind' order by salary limit 2