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

classic Classic list List threaded Threaded
1 message Options
Reply | Threaded
Open this post in threaded view
|

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

Akash R Nilugal (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)