[ https://issues.apache.org/jira/browse/CARBONDATA-385?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Ashok Kumar updated CARBONDATA-385: ----------------------------------- Description: In below scenario, select query is giving error as below Error: java.lang.ClassCastException: java.lang.Integer cannot be cast to java.lang.String 1. employee table create table employee(name string, empid string, mgrid string, mobileno bigint) stored by 'carbondata' 2.load below data in employee table tom,t23717,h2399,99780207526 3. manager table create table manager(name string, empid string, mgrid string, mobileno bigint) stored by 'carbondata' 4. load below data in manager table harry,h2399,v788232,99823230205 5.Run below query select e.empid from employee e inner join manager m on e.mgrid=m.empid#select empid,mgrid from employee was: In below scenario, select query is giving error as below Error: java.lang.ClassCastException: java.lang.Integer cannot be cast to java.lang.String > Select query is giving cast exception > ------------------------------------- > > Key: CARBONDATA-385 > URL: https://issues.apache.org/jira/browse/CARBONDATA-385 > Project: CarbonData > Issue Type: Bug > Reporter: Ashok Kumar > Priority: Minor > > In below scenario, select query is giving error as below > Error: java.lang.ClassCastException: java.lang.Integer cannot be cast to > java.lang.String > 1. employee table > create table employee(name string, empid string, mgrid string, mobileno > bigint) stored by 'carbondata' > 2.load below data in employee table > tom,t23717,h2399,99780207526 > 3. manager table > create table manager(name string, empid string, mgrid string, mobileno > bigint) stored by 'carbondata' > 4. load below data in manager table > harry,h2399,v788232,99823230205 > 5.Run below query > select e.empid from employee e inner join manager m on e.mgrid=m.empid#select > empid,mgrid from employee -- This message was sent by Atlassian JIRA (v6.3.4#6332)