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 066D4200C01 for ; Thu, 19 Jan 2017 07:57:35 +0100 (CET) Received: by cust-asf.ponee.io (Postfix) id 048A0160B54; Thu, 19 Jan 2017 06:57:35 +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 503CA160B42 for ; Thu, 19 Jan 2017 07:57:34 +0100 (CET) Received: (qmail 74465 invoked by uid 500); 19 Jan 2017 06:57:33 -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 74456 invoked by uid 99); 19 Jan 2017 06:57:33 -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; Thu, 19 Jan 2017 06:57:33 +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 3088CC211B for ; Thu, 19 Jan 2017 06:57:33 +0000 (UTC) X-Virus-Scanned: Debian amavisd-new at spamd1-us-west.apache.org X-Spam-Flag: NO X-Spam-Score: -1.999 X-Spam-Level: X-Spam-Status: No, score=-1.999 tagged_above=-999 required=6.31 tests=[KAM_LAZY_DOMAIN_SECURITY=1, 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 ljOvSUNZ0Uxa for ; Thu, 19 Jan 2017 06:57:32 +0000 (UTC) Received: from mailrelay1-us-west.apache.org (mailrelay1-us-west.apache.org [209.188.14.139]) by mx1-lw-us.apache.org (ASF Mail Server at mx1-lw-us.apache.org) with ESMTP id 56E8F5F4EE for ; Thu, 19 Jan 2017 06:57:32 +0000 (UTC) Received: from jira-lw-us.apache.org (unknown [207.244.88.139]) by mailrelay1-us-west.apache.org (ASF Mail Server at mailrelay1-us-west.apache.org) with ESMTP id A8EE6E0256 for ; Thu, 19 Jan 2017 06:57:26 +0000 (UTC) Received: from jira-lw-us.apache.org (localhost [127.0.0.1]) by jira-lw-us.apache.org (ASF Mail Server at jira-lw-us.apache.org) with ESMTP id 66E2C2527F for ; Thu, 19 Jan 2017 06:57:26 +0000 (UTC) Date: Thu, 19 Jan 2017 06:57:26 +0000 (UTC) From: "Geetika Gupta (JIRA)" To: issues@carbondata.incubator.apache.org Message-ID: In-Reply-To: References: Subject: [jira] [Closed] (CARBONDATA-625) Abnormal behaviour of Int datatype MIME-Version: 1.0 Content-Type: text/plain; charset=utf-8 Content-Transfer-Encoding: 7bit X-JIRA-FingerPrint: 30527f35849b9dde25b450d4833f0394 archived-at: Thu, 19 Jan 2017 06:57:35 -0000 [ https://issues.apache.org/jira/browse/CARBONDATA-625?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Geetika Gupta closed CARBONDATA-625. ------------------------------------ Resolution: Fixed > Abnormal behaviour of Int datatype > ---------------------------------- > > Key: CARBONDATA-625 > URL: https://issues.apache.org/jira/browse/CARBONDATA-625 > Project: CarbonData > Issue Type: Bug > Components: data-load > Affects Versions: 1.0.0-incubating > Environment: Spark: 1.6 and hadoop: 2.6.5 > Reporter: Geetika Gupta > Assignee: Manish Gupta > Priority: Minor > Attachments: Screenshot from 2017-01-11 18-36-24.png, testMaxValueForBigInt.csv > > > I was trying to create a table having int as a column and loaded data into the table. Data loading was performed successfully but when I viewed the data of the table, there was some wrong data present in the table. I was trying to load BigInt data to an int column. All the data in int column is loaded with the first value of the csv. Below are the details for the queries: > create table xyz(a int, b string)stored by 'carbondata'; > Data load query: > LOAD DATA INPATH 'hdfs://localhost:54311/testFiles/testMaxValueForBigInt.csv' into table xyz OPTIONS('DELIMITER'=',' , 'QUOTECHAR'='"','FILEHEADER'='a,b'); > select query: > select * from xyz; > PFA the screenshot of the output and the csv file. -- This message was sent by Atlassian JIRA (v6.3.4#6332)