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 3F61D200C5C for ; Thu, 20 Apr 2017 21:01:54 +0200 (CEST) Received: by cust-asf.ponee.io (Postfix) id 3E0A0160BB0; Thu, 20 Apr 2017 19:01:54 +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 86108160B90 for ; Thu, 20 Apr 2017 21:01:53 +0200 (CEST) Received: (qmail 25045 invoked by uid 500); 20 Apr 2017 19:01:52 -0000 Mailing-List: contact issues-help@carbondata.apache.org; run by ezmlm Precedence: bulk List-Help: List-Unsubscribe: List-Post: List-Id: Reply-To: dev@carbondata.apache.org Delivered-To: mailing list issues@carbondata.apache.org Received: (qmail 25036 invoked by uid 99); 20 Apr 2017 19:01:52 -0000 Received: from pnap-us-west-generic-nat.apache.org (HELO spamd3-us-west.apache.org) (209.188.14.142) by apache.org (qpsmtpd/0.29) with ESMTP; Thu, 20 Apr 2017 19:01:52 +0000 Received: from localhost (localhost [127.0.0.1]) by spamd3-us-west.apache.org (ASF Mail Server at spamd3-us-west.apache.org) with ESMTP id 649C6181059 for ; Thu, 20 Apr 2017 19:01:52 +0000 (UTC) X-Virus-Scanned: Debian amavisd-new at spamd3-us-west.apache.org X-Spam-Flag: NO X-Spam-Score: -100.002 X-Spam-Level: X-Spam-Status: No, score=-100.002 tagged_above=-999 required=6.31 tests=[RP_MATCHES_RCVD=-0.001, SPF_PASS=-0.001, USER_IN_WHITELIST=-100] autolearn=disabled Received: from mx1-lw-eu.apache.org ([10.40.0.8]) by localhost (spamd3-us-west.apache.org [10.40.0.10]) (amavisd-new, port 10024) with ESMTP id N-5FTAYHx8M5 for ; Thu, 20 Apr 2017 19:01:51 +0000 (UTC) Received: from mailrelay1-us-west.apache.org (mailrelay1-us-west.apache.org [209.188.14.139]) by mx1-lw-eu.apache.org (ASF Mail Server at mx1-lw-eu.apache.org) with ESMTP id 9136D626E9 for ; Thu, 20 Apr 2017 18:59:05 +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 BDC94E00A6 for ; Thu, 20 Apr 2017 18:59:04 +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 09C6C21B52 for ; Thu, 20 Apr 2017 18:59:04 +0000 (UTC) Date: Thu, 20 Apr 2017 18:59:04 +0000 (UTC) From: "Manish Gupta (JIRA)" To: issues@carbondata.incubator.apache.org Message-ID: In-Reply-To: References: Subject: [jira] [Created] (CARBONDATA-968) Alter temp store location and decimal data type incorrect result display correction MIME-Version: 1.0 Content-Type: text/plain; charset=utf-8 Content-Transfer-Encoding: 7bit X-JIRA-FingerPrint: 30527f35849b9dde25b450d4833f0394 archived-at: Thu, 20 Apr 2017 19:01:54 -0000 Manish Gupta created CARBONDATA-968: --------------------------------------- Summary: Alter temp store location and decimal data type incorrect result display correction Key: CARBONDATA-968 URL: https://issues.apache.org/jira/browse/CARBONDATA-968 Project: CarbonData Issue Type: Bug Reporter: Manish Gupta Assignee: Manish Gupta Priority: Minor Fix For: 1.1.0-incubating Below problems need to be addressed through this jira. 1. Temp store location path formation for compaction through sort step is incorrect. Temp store location key being formed is not proper. 2. Data type change validations: a. New precision should always be greater than existing precision b. New scale value can be same as old scale value. 3. Filter query bug on datatype changed for a decimal column. Steps to reproduce: create table alter_decimal_filter (n1 string, n2 int, n3 decimal(3,2)) stored by 'carbondata'; insert into alter_decimal_filter select 'xx',1,1.22; insert into alter_decimal_filter select 'xx',1,1.23; alter table alter_decimal_filter change n3 n3 decimal(8,4); insert into alter_decimal_filter select 'dd',2,111.111; select * from alter_decimal_filter where n3 = 1.22; -- This message was sent by Atlassian JIRA (v6.3.15#6346)