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

["Ravindra Pesala (JIRA)" <ji...@apache.org>]

     [ https://issues.apache.org/jira/browse/CARBONDATA-860?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

Ravindra Pesala resolved CARBONDATA-860.
----------------------------------------
       Resolution: Duplicate
    Fix Version/s: 1.1.0

duplicated to
https://issues.apache.org/jira/browse/CARBONDATA-874

> 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
>             Fix For: 1.1.0
>
>
> 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)