[jira] [Updated] (CARBONDATA-385) Select query is giving cast exception

[Akash R Nilugal (Jira)]

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