[ https://issues.apache.org/jira/browse/HIVE-10150?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=14391150#comment-14391150 ]
Alan Gates commented on HIVE-10150: ----------------------------------- +1 > delete from acidTbl where a in(select a from nonAcidOrcTbl) fails > ----------------------------------------------------------------- > > Key: HIVE-10150 > URL: https://issues.apache.org/jira/browse/HIVE-10150 > Project: Hive > Issue Type: Bug > Components: Query Planning, Transactions > Affects Versions: 1.1.0 > Reporter: Eugene Koifman > Assignee: Eugene Koifman > Attachments: HIVE-10050.patch > > > 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. -- This message was sent by Atlassian JIRA (v6.3.4#6332)