[jira] [Commented] (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:comment-tabpanel&focusedCommentId=15644428#comment-15644428 ]

ASF GitHub Bot commented on CARBONDATA-385:
-------------------------------------------

Github user asfgit closed the pull request at:

    https://github.com/apache/incubator-carbondata/pull/301

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