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 ?