Return-Path: X-Original-To: archive-asf-public-internal@cust-asf2.ponee.io Delivered-To: archive-asf-public-internal@cust-asf2.ponee.io Received: from cust-asf.ponee.io (cust-asf.ponee.io [163.172.22.183]) by cust-asf2.ponee.io (Postfix) with ESMTP id 8CC57200BB9 for ; Mon, 7 Nov 2016 08:01:23 +0100 (CET) Received: by cust-asf.ponee.io (Postfix) id 8B3FB160AF9; Mon, 7 Nov 2016 07:01:23 +0000 (UTC) Delivered-To: archive-asf-public@cust-asf.ponee.io Received: from mail.apache.org (hermes.apache.org [140.211.11.3]) by cust-asf.ponee.io (Postfix) with SMTP id D1C53160AEB for ; Mon, 7 Nov 2016 08:01:22 +0100 (CET) Received: (qmail 97660 invoked by uid 500); 7 Nov 2016 07:01:22 -0000 Mailing-List: contact issues-help@carbondata.incubator.apache.org; run by ezmlm Precedence: bulk List-Help: List-Unsubscribe: List-Post: List-Id: Reply-To: dev@carbondata.incubator.apache.org Delivered-To: mailing list issues@carbondata.incubator.apache.org Received: (qmail 97651 invoked by uid 99); 7 Nov 2016 07:01:21 -0000 Received: from pnap-us-west-generic-nat.apache.org (HELO spamd1-us-west.apache.org) (209.188.14.142) by apache.org (qpsmtpd/0.29) with ESMTP; Mon, 07 Nov 2016 07:01:21 +0000 Received: from localhost (localhost [127.0.0.1]) by spamd1-us-west.apache.org (ASF Mail Server at spamd1-us-west.apache.org) with ESMTP id 4C304C0FFE for ; Mon, 7 Nov 2016 07:01:21 +0000 (UTC) X-Virus-Scanned: Debian amavisd-new at spamd1-us-west.apache.org X-Spam-Flag: NO X-Spam-Score: -7.019 X-Spam-Level: X-Spam-Status: No, score=-7.019 tagged_above=-999 required=6.31 tests=[KAM_LAZY_DOMAIN_SECURITY=1, RCVD_IN_DNSWL_HI=-5, RCVD_IN_MSPIKE_H3=-0.01, RCVD_IN_MSPIKE_WL=-0.01, RP_MATCHES_RCVD=-2.999] autolearn=disabled Received: from mx1-lw-us.apache.org ([10.40.0.8]) by localhost (spamd1-us-west.apache.org [10.40.0.7]) (amavisd-new, port 10024) with ESMTP id PZSIUNYLDOQu for ; Mon, 7 Nov 2016 07:01:20 +0000 (UTC) Received: from mail.apache.org (hermes.apache.org [140.211.11.3]) by mx1-lw-us.apache.org (ASF Mail Server at mx1-lw-us.apache.org) with SMTP id 6988D5FC86 for ; Mon, 7 Nov 2016 07:01:20 +0000 (UTC) Received: (qmail 95373 invoked by uid 99); 7 Nov 2016 07:01:06 -0000 Received: from arcas.apache.org (HELO arcas) (140.211.11.28) by apache.org (qpsmtpd/0.29) with ESMTP; Mon, 07 Nov 2016 07:01:06 +0000 Received: from arcas.apache.org (localhost [127.0.0.1]) by arcas (Postfix) with ESMTP id BE4252C0032 for ; Mon, 7 Nov 2016 07:01:05 +0000 (UTC) Date: Mon, 7 Nov 2016 07:01:05 +0000 (UTC) From: "Ashok Kumar (JIRA)" To: issues@carbondata.incubator.apache.org Message-ID: In-Reply-To: References: Subject: [jira] [Updated] (CARBONDATA-385) Select query is giving cast exception MIME-Version: 1.0 Content-Type: text/plain; charset=utf-8 Content-Transfer-Encoding: 7bit X-JIRA-FingerPrint: 30527f35849b9dde25b450d4833f0394 archived-at: Mon, 07 Nov 2016 07:01:23 -0000 [ 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)