[HIVE-10150] delete from acidTbl where a in(select a from nonAcidOrcTbl) fails

• Type: Bug
• Status: Closed
• Priority: Major
• Resolution: Fixed
• Affects Version/s: 1.1.0
• Fix Version/s: 1.2.0
• Component/s: Query Planning, Transactions
• Assignee: Eugene Koifman
• Reporter: Eugene Koifman
• Created: 30/Mar/15 22:56
• Updated: 01/Oct/19 22:07
• Resolved: 01/Apr/15 19:54

Description

this query raises an error
"10297,FAILED: SemanticException [Error 10297]: Attempt to do update or delete on table nonAcidOrcTbl that does not use an AcidOutputFormat or is not bucketed"

even though nonAcidOrcTbl is only being read, not written.

select b from " + Table.ACIDTBL + " where a in (select b from " + Table.NONACIDORCTBL + ")
runs fine.

There doesn't seem to be any logical reason why we should rise the error here.

Same for 'update' statement.

Issue Links

• is related to: HIVE-10151 insert into A select from B is broken when both A and B are Acid tables and bucketed the same way