hive-issues mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Frédéric ESCANDELL (JIRA) <>
Subject [jira] [Commented] (HIVE-15970) Fix merge to work in presence of AST rewrites
Date Wed, 28 Jun 2017 10:04:00 GMT


Frédéric ESCANDELL commented on HIVE-15970:


When I exécute the following Hive request, i have an issue  : 

    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:
>             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

This message was sent by Atlassian JIRA

View raw message