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 871C3200B8F for ; Fri, 30 Sep 2016 21:00:23 +0200 (CEST) Received: by cust-asf.ponee.io (Postfix) id 85AF0160AE7; Fri, 30 Sep 2016 19:00: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 F184E160AB4 for ; Fri, 30 Sep 2016 21:00:22 +0200 (CEST) Received: (qmail 60375 invoked by uid 500); 30 Sep 2016 19:00:22 -0000 Mailing-List: contact issues-help@hive.apache.org; run by ezmlm Precedence: bulk List-Help: List-Unsubscribe: List-Post: List-Id: Reply-To: dev@hive.apache.org Delivered-To: mailing list issues@hive.apache.org Received: (qmail 60353 invoked by uid 99); 30 Sep 2016 19:00:22 -0000 Received: from arcas.apache.org (HELO arcas) (140.211.11.28) by apache.org (qpsmtpd/0.29) with ESMTP; Fri, 30 Sep 2016 19:00:22 +0000 Received: from arcas.apache.org (localhost [127.0.0.1]) by arcas (Postfix) with ESMTP id D62092C0032 for ; Fri, 30 Sep 2016 19:00:21 +0000 (UTC) Date: Fri, 30 Sep 2016 19:00:21 +0000 (UTC) From: "Matt McCline (JIRA)" To: issues@hive.apache.org Message-ID: In-Reply-To: References: Subject: [jira] [Commented] (HIVE-13098) Add a strict check for when the decimal gets converted to null due to insufficient width MIME-Version: 1.0 Content-Type: text/plain; charset=utf-8 Content-Transfer-Encoding: 7bit X-JIRA-FingerPrint: 30527f35849b9dde25b450d4833f0394 archived-at: Fri, 30 Sep 2016 19:00:23 -0000 [ https://issues.apache.org/jira/browse/HIVE-13098?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=15536749#comment-15536749 ] Matt McCline commented on HIVE-13098: ------------------------------------- There are other industry solutions. E.g. Greenplum added an ERROR TABLE feature a long time ago for saving rejected rows so they could be cleaned and add later. Also, see Teradata. > Add a strict check for when the decimal gets converted to null due to insufficient width > ---------------------------------------------------------------------------------------- > > Key: HIVE-13098 > URL: https://issues.apache.org/jira/browse/HIVE-13098 > Project: Hive > Issue Type: Bug > Reporter: Sergey Shelukhin > Assignee: Sergey Shelukhin > Attachments: HIVE-13098.WIP.patch, HIVE-13098.WIP2.patch > > > When e.g. 999999 is selected as decimal(5,0), the result is null. This can be problematic, esp. if the data is written to a table and lost without the user realizing it. There should be an option to error out in such cases instead; it should probably be on by default and the error message should instruct the user on how to disable it. -- This message was sent by Atlassian JIRA (v6.3.4#6332)