Support Questions
Find answers, ask questions, and share your expertise
Announcements
Check out our newest addition to the community, the Cloudera Innovation Accelerator group hub.

Delete doesn't work on HDP 2.6

Explorer

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 ?

3 REPLIES 3

Explorer

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 ?

Explorer

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.

Explorer

Hello,

I created this ticket to explain this issue :

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