You are viewing a plain text version of this content. The canonical link for it is here.
Posted to issues@hive.apache.org by "Matt McCline (JIRA)" <ji...@apache.org> on 2017/09/17 02:38:01 UTC
[jira] [Comment Edited] (HIVE-17013) Delete request with a subquery
based on select over a view
[ https://issues.apache.org/jira/browse/HIVE-17013?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16169164#comment-16169164 ]
Matt McCline edited comment on HIVE-17013 at 9/17/17 2:37 AM:
--------------------------------------------------------------
I looked at the code. I'm not familiar with this area of the code.
[~ashutoshc] [~jcamachorodriguez] [~vgarg] can you review ASAP. Thanks.
was (Author: mmccline):
I looked at the code. I'm not familiar with this area of the code. Either someone else should review it or I can do it as long as some else looks at it later...
+1 provisional
> Delete request with a subquery based on select over a view
> ----------------------------------------------------------
>
> Key: HIVE-17013
> URL: https://issues.apache.org/jira/browse/HIVE-17013
> Project: Hive
> Issue Type: Bug
> Components: Transactions
> Reporter: Frédéric ESCANDELL
> Assignee: Eugene Koifman
> Priority: Blocker
> Attachments: acid_view_bug.q, HIVE-17013.01.patch, HIVE-17013.01.patch
>
>
> Hi,
> I based my DDL on this exemple https://fr.hortonworks.com/tutorial/using-hive-acid-transactions-to-insert-update-and-delete-data/.
> In a delete request, the use of a view in a subquery throw an exception :
> FAILED: IllegalStateException Expected 'insert into table default.mydim select ROW__ID from default.mydim sort by ROW__ID' to be in sub-query or set operation.
> {code}
> {code:sql}
> drop table if exists mydim;
> create table mydim (key int, name string, zip string, is_current boolean)
> clustered by(key) into 3 buckets
> stored as orc tblproperties ('transactional'='true');
> insert into mydim values
> (1, 'bob', '95136', true),
> (2, 'joe', '70068', true),
> (3, 'steve', '22150', true);
> drop table if exists updates_staging_table;
> create table updates_staging_table (key int, newzip string);
> insert into updates_staging_table values (1, 87102), (3, 45220);
> drop view if exists updates_staging_view;
> create view updates_staging_view (key, newzip) as select key, newzip from updates_staging_table;
> delete from mydim
> where mydim.key in (select key from updates_staging_view);
> FAILED: IllegalStateException Expected 'insert into table default.mydim select ROW__ID from default.mydim sort by ROW__ID' to be in sub-query or set operation.
> {code}
--
This message was sent by Atlassian JIRA
(v6.4.14#64029)