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

Highlighted

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
Highlighted

Re: Delete doesn't work on HDP 2.6

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 ?

Highlighted

Re: Delete doesn't work on HDP 2.6

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.

Highlighted

Re: Delete doesn't work on HDP 2.6

Explorer

Hello,

I created this ticket to explain this issue :

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

Don't have an account?
Coming from Hortonworks? Activate your account here