[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=15643406#comment-15643406 ]

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

GitHub user ashokblend opened a pull request:

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

    [WIP][CARBONDATA-385]During join operation, same column is available in two table. User do…

    Be sure to do all of the following to help us incorporate your contribution
    quickly and easily:
   
     - [ ] Make sure the PR title is formatted like:
       `[CARBONDATA-<Jira issue #>] Description of pull request`
     - [ ] Make sure tests pass via `mvn clean verify`. (Even better, enable
           Travis-CI on your fork and ensure the whole test matrix passes).
     - [ ] Replace `<Jira issue #>` in the title with the actual Jira issue
           number, if there is one.
     - [ ] If this contribution is large, please file an Apache
           [Individual Contributor License Agreement](https://www.apache.org/licenses/icla.txt).
     - [ ] Testing done
     
            Please provide details on
            - Whether new unit test cases have been added or why no new tests are required?
            - What manual testing you have done?
            - Any additional information to help reviewers in testing this change.
             
     - [ ] For large changes, please consider breaking it into sub-tasks under an umbrella JIRA.
                     
    ---
   
    … select on first table column and add filter on other table column.
   
    Because of this, top level decoder finds that column is already decoded in bottom layer(because its comparing by name) and hence its not decoding.

You can merge this pull request into a Git repository by running:

    $ git pull https://github.com/ashokblend/incubator-carbondata carbondata-385

Alternatively you can review and apply these changes as the patch at:

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

To close this pull request, make a commit to your master/trunk branch
with (at least) the following in the commit message:

    This closes #301
   
----
commit 730a2cccd2ea88260030c2efe8cdb7bc060c20e8
Author: ashok.blend <[hidden email]>
Date:   2016-11-07T08:07:28Z

    During join operation, same column is available in two table. User do select on first table column and add filter on other table column.
    Because of this, top level decoder finds that column is already decoded in bottom layer(because its comparing by name) and hence its not decoding.

----

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