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 1D7F9200D0A for ; Wed, 20 Sep 2017 02:35:04 +0200 (CEST) Received: by cust-asf.ponee.io (Postfix) id 1BB6D1609E0; Wed, 20 Sep 2017 00:35:04 +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 62B5D1609E2 for ; Wed, 20 Sep 2017 02:35:03 +0200 (CEST) Received: (qmail 686 invoked by uid 500); 20 Sep 2017 00:35:02 -0000 Mailing-List: contact dev-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 dev@hive.apache.org Received: (qmail 572 invoked by uid 99); 20 Sep 2017 00:35:02 -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; Wed, 20 Sep 2017 00:35:02 +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 C91FC18B122 for ; Wed, 20 Sep 2017 00:35:01 +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-us.apache.org ([10.40.0.8]) by localhost (spamd3-us-west.apache.org [10.40.0.10]) (amavisd-new, port 10024) with ESMTP id RsMIZ5T2OQ5L for ; Wed, 20 Sep 2017 00:35:01 +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 DCA9B610E2 for ; Wed, 20 Sep 2017 00:35:00 +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 68E57E0635 for ; Wed, 20 Sep 2017 00:35:00 +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 298DB24504 for ; Wed, 20 Sep 2017 00:35:00 +0000 (UTC) Date: Wed, 20 Sep 2017 00:35:00 +0000 (UTC) From: "Prasanth Jayachandran (JIRA)" To: dev@hive.apache.org Message-ID: In-Reply-To: References: Subject: [jira] [Created] (HIVE-17562) ACID 1.0 + ETL strategy should treat empty compacted files as uncovered deltas MIME-Version: 1.0 Content-Type: text/plain; charset=utf-8 Content-Transfer-Encoding: 7bit X-JIRA-FingerPrint: 30527f35849b9dde25b450d4833f0394 archived-at: Wed, 20 Sep 2017 00:35:04 -0000 Prasanth Jayachandran created HIVE-17562: -------------------------------------------- Summary: ACID 1.0 + ETL strategy should treat empty compacted files as uncovered deltas Key: HIVE-17562 URL: https://issues.apache.org/jira/browse/HIVE-17562 Project: Hive Issue Type: Bug Affects Versions: 2.4.0 Reporter: Prasanth Jayachandran Assignee: Prasanth Jayachandran In branch-2, with ACID 1.0, following sequence will result in incorrect results 1) Set split strategy to ETL 2) Insert some rows 3) Delete all rows 4) Alter table compact MAJOR 5) Insert some rows 6) Select * query will not return any rows that is written at last (step 5) The reason for that, compaction essentially voids the first insert in step 2. Now when ETL split strategy is chosen, there will not be any stripes in the base files. So no split gets generated and any subsequent deltas gets ignored. -- This message was sent by Atlassian JIRA (v6.4.14#64029)