carbondata-issues mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Ashok Kumar (JIRA)" <j...@apache.org>
Subject [jira] [Updated] (CARBONDATA-385) Select query is giving cast exception
Date Mon, 07 Nov 2016 07:01:05 GMT

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

Mime
View raw message