Mailing-List: contact issues-help@hive.apache.org; run by ezmlm
Precedence: bulk
Reply-To: dev@hive.apache.org
Date: Wed, 28 Sep 2016 03:47:22 +0000 (UTC)
From: =?utf-8?Q?Sergio_Pe=C3=B1a_=28JIRA=29?= <jira@apache.org>
To: issues@hive.apache.org
Message-ID: <JIRA.12996689.1470936512000.682378.1475034442184@Atlassian.JIRA>
In-Reply-To: <JIRA.12996689.1470936512000@Atlassian.JIRA>
References: <JIRA.12996689.1470936512000@Atlassian.JIRA> <JIRA.12996689.1470936512792@arcas>
Subject: [jira] [Updated] (HIVE-14519) Multi insert query bug
MIME-Version: 1.0
Content-Type: text/plain; charset=utf-8
Content-Transfer-Encoding: quoted-printable
archived-at: Wed, 28 Sep 2016 03:47:23 -0000


     [ https://issues.apache.org/jira/browse/HIVE-14519?page=3Dcom.atlassia=
n.jira.plugin.system.issuetabpanels:all-tabpanel ]

Sergio Pe=C3=B1a updated HIVE-14519:
-------------------------------
    Target Version/s: 2.1.1

> Multi insert query bug
> ----------------------
>
>                 Key: HIVE-14519
>                 URL: https://issues.apache.org/jira/browse/HIVE-14519
>             Project: Hive
>          Issue Type: Bug
>          Components: Logical Optimizer
>            Reporter: Yongzhi Chen
>            Assignee: Yongzhi Chen
>             Fix For: 2.2.0
>
>         Attachments: HIVE-14519.1.patch
>
>
> When running multi-insert queries, when one of the query is not returning=
 results, the other query is not returning the right result.
> For example:
> After following query, there is no value in /tmp/emp/dir3/000000_0
> {noformat}
> From (select * from src) a
> insert overwrite directory '/tmp/emp/dir1/'
> select key, value
> insert overwrite directory '/tmp/emp/dir2/'
> select 'header'
> where 1=3D2
> insert overwrite directory '/tmp/emp/dir3/'
> select key, value=20
> where key =3D 100;
> {noformat}
> where clause in the second insert should not affect the third insert.=20


--
This message was sent by Atlassian JIRA
(v6.3.4#6332)