You are viewing a plain text version of this content. The canonical link for it is here.
Posted to issues@hive.apache.org by "Frédéric ESCANDELL (JIRA)" <ji...@apache.org> on 2017/06/28 10:04:00 UTC
[jira] [Comment Edited] (HIVE-15970) Fix merge to work in presence
of AST rewrites
[ https://issues.apache.org/jira/browse/HIVE-15970?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16066262#comment-16066262 ]
Frédéric ESCANDELL edited comment on HIVE-15970 at 6/28/17 10:03 AM:
---------------------------------------------------------------------
Hi,
When I execute the following Hive request, i have an issue :
DELETE
FROM braff.controle
WHERE id_prestation IN (
SELECT distinct id_prestation
FROM bbrut.controle_vue
WHERE yearbrut='0000');
FAILED: IllegalStateException Expected 'insert into table braff.controle select ROW__ID from braff.controle sort by ROW__ID' to be in sub-query or set operation.
I don't understand this exception which has been added to correct this ticket ?
was (Author: fescandell):
Hi,
When I exécute the following Hive request, i have an issue :
DELETE
FROM braff.controle
WHERE id_prestation IN (
SELECT distinct id_prestation
FROM bbrut.controle_vue
WHERE yearbrut='0000');
FAILED: IllegalStateException Expected 'insert into table braff.controle select ROW__ID from braff.controle sort by ROW__ID' to be in sub-query or set operation.
I don't understand this exception which has been added to correct this ticket ?
> Fix merge to work in presence of AST rewrites
> ---------------------------------------------
>
> Key: HIVE-15970
> URL: https://issues.apache.org/jira/browse/HIVE-15970
> Project: Hive
> Issue Type: Sub-task
> Components: Transactions
> Affects Versions: 2.2.0
> Reporter: Eugene Koifman
> Assignee: Eugene Koifman
> Priority: Critical
> Fix For: 2.2.0
>
> Attachments: HIVE-15970.01.patch, HIVE-15970.02.patch
>
>
> The issue is that Context.getDestNamePrefix() caches ASTNode objects to figure out if a given insert branch of multi-insert is insert, update or delete but objects change when the tree is modified. For example, row-filtering/column-masking does this, but also other optimizations/features.
--
This message was sent by Atlassian JIRA
(v6.4.14#64029)