You are viewing a plain text version of this content. The canonical link for it is here.
Posted to dev@hive.apache.org by "Frédéric ESCANDELL (JIRA)" <ji...@apache.org> on 2017/07/03 07:42:00 UTC
[jira] [Created] (HIVE-17013) Delete request with a subquery based
on select over a view
Frédéric ESCANDELL created HIVE-17013:
-----------------------------------------
Summary: 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
Reporter: Frédéric ESCANDELL
Priority: Blocker
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)