Support Questions
Find answers, ask questions, and share your expertise
Announcements
Alert: Welcome to the Unified Cloudera Community. Former HCC members be sure to read and learn how to activate your account here.

Delete doesn't work on HDP 2.6

Delete doesn't work on HDP 2.6

New Contributor

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

Re: Delete doesn't work on HDP 2.6

New Contributor

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 ?

Highlighted

Re: Delete doesn't work on HDP 2.6

New Contributor

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.

Re: Delete doesn't work on HDP 2.6

New Contributor

Hello,

I created this ticket to explain this issue :

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