Delete doesn't work on HDP 2.6

[#1]

Hi,

This very simple Hive request doesn't work properly on HDP 2.6 but it works on HDP 2.4:

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.

This exception has been added to correct this bug HIVE-15970 .

Did you have an idea ?

[#2]

Hi,

It seems to come from the use of a view in the subquery in a delete request.

Do you know why it doesn't work ?

[#3]

Frédéric,

Can you create a new Apache JIRA ticket with your DDL and view definition? HIVE-15970 looks unrelated given it applies to multi-insert which is only used for MERGE.

[#4]

Hello,

I created this ticket to explain this issue :

https://issues.apache.org/jira/browse/HIVE-17013