[ 
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)

Reply via email to