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

[Naresh P R (JIRA)]

Naresh P R created CARBONDATA-860:
-------------------------------------

             Summary: Carbon with Spark2.1, select query with filter on 
dictionary column & order by dictionary/measure with limit is failing
                 Key: CARBONDATA-860
                 URL: https://issues.apache.org/jira/browse/CARBONDATA-860
             Project: CarbonData
          Issue Type: Bug
            Reporter: Naresh P R
            Assignee: Ravindra Pesala
            Priority: Minor


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



--
This message was sent by Atlassian JIRA
(v6.3.15#6346)