[jira] [Commented] (HIVE-15970) Fix merge to work in presence of AST rewrites

["Frédéric ESCANDELL (JIRA)" <ji...@apache.org>]

    [ 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 commented on HIVE-15970:
-------------------------------------------

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)