Mailing-List: contact issues-help@hive.apache.org; run by ezmlm
Precedence: bulk
Reply-To: dev@hive.apache.org
Date: Thu, 19 Jan 2017 00:17:26 +0000 (UTC)
From: "Eugene Koifman (JIRA)" <jira@apache.org>
To: issues@hive.apache.org
Message-ID: <JIRA.13012102.1476383483000.46962.1484785046544@Atlassian.JIRA>
In-Reply-To: <JIRA.13012102.1476383483000@Atlassian.JIRA>
References: <JIRA.13012102.1476383483000@Atlassian.JIRA> <JIRA.13012102.1476383483634@jira-lw-us.apache.org>
Subject: [jira] [Updated] (HIVE-14949) Enforce that target:source is not 1:N
MIME-Version: 1.0
Content-Type: text/plain; charset=utf-8
Content-Transfer-Encoding: 7bit
archived-at: Thu, 19 Jan 2017 00:17:32 -0000


     [ https://issues.apache.org/jira/browse/HIVE-14949?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

Eugene Koifman updated HIVE-14949:
----------------------------------
    Description: 
If > 1 row on source side matches the same row on target side that means that  we are forced update (or delete) the same row in target more than once as part of the same SQL statement.  This should raise an error per SQL Spec
ISO/IEC 9075-2:2011(E)
Section 14.2 under "General Rules" Item 6/Subitem a/Subitem 2/Subitem B

There is no sure way to do this via static analysis of the query.

Can we add something to ROJ operator to pay attention to ROW__ID of target side row and compare it with ROW__ID of target side of previous row output?  If they are the same, that means > 1 source row matched.
Or perhaps just mark each row in the hash table that it matched.  And if it matches again, throw an error.

  was:
If > 1 row on source side matches the same row on target side that means that  we are forced update (or delete) the same row in target more than once as part of the same SQL statement.  This should raise an error per SQL Spec

There is no sure way to do this via static analysis of the query.

Can we add something to ROJ operator to pay attention to ROW__ID of target side row and compare it with ROW__ID of target side of previous row output?  If they are the same, that means > 1 source row matched.
Or perhaps just mark each row in the hash table that it matched.  And if it matches again, throw an error.


> Enforce that target:source is not 1:N
> -------------------------------------
>
>                 Key: HIVE-14949
>                 URL: https://issues.apache.org/jira/browse/HIVE-14949
>             Project: Hive
>          Issue Type: Sub-task
>          Components: Transactions
>            Reporter: Eugene Koifman
>            Assignee: Eugene Koifman
>
> If > 1 row on source side matches the same row on target side that means that  we are forced update (or delete) the same row in target more than once as part of the same SQL statement.  This should raise an error per SQL Spec
> ISO/IEC 9075-2:2011(E)
> Section 14.2 under "General Rules" Item 6/Subitem a/Subitem 2/Subitem B
> There is no sure way to do this via static analysis of the query.
> Can we add something to ROJ operator to pay attention to ROW__ID of target side row and compare it with ROW__ID of target side of previous row output?  If they are the same, that means > 1 source row matched.
> Or perhaps just mark each row in the hash table that it matched.  And if it matches again, throw an error.


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