[jira] [Commented] (HIVE-16842) insert overwrite with select does not remove data when the select query returns empty resultset

[Abhishek Somani (JIRA)]

[ 
https://issues.apache.org/jira/browse/HIVE-16842?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16792408#comment-16792408
 ] 

Abhishek Somani commented on HIVE-16842:


[~vgarg] [~ashutoshc] are we planning to fix this?

> insert overwrite with select does not remove data when the select query 
> returns empty resultset
> ---
>
> Key: HIVE-16842
> URL: https://issues.apache.org/jira/browse/HIVE-16842
> Project: Hive
>  Issue Type: Bug
>  Components: HiveServer2
>Affects Versions: 3.0.0
>Reporter: anishek
>Priority: Major
>
> {code}create table address (city string);
> insert into address values ('b');
> create table empty_insert (city string);
> insert into empty_insert values ('a');
> insert overwrite table empty_insert select city from address where city='g';
> {code}
> empty_insert still contains 'a'; # should be nothing 



--
This message was sent by Atlassian JIRA
(v7.6.3#76005)

[jira] [Commented] (HIVE-16842) insert overwrite with select does not remove data when the select query returns empty resultset

[Vineet Garg (JIRA)]

[ 
https://issues.apache.org/jira/browse/HIVE-16842?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16424474#comment-16424474
 ] 

Vineet Garg commented on HIVE-16842:


Removing fix version to defer this to next release.

> insert overwrite with select does not remove data when the select query 
> returns empty resultset
> ---
>
> Key: HIVE-16842
> URL: https://issues.apache.org/jira/browse/HIVE-16842
> Project: Hive
>  Issue Type: Bug
>  Components: HiveServer2
>Affects Versions: 3.0.0
>Reporter: anishek
>Priority: Major
>
> {code}create table address (city string);
> insert into address values ('b');
> create table empty_insert (city string);
> insert into empty_insert values ('a');
> insert overwrite table empty_insert select city from address where city='g';
> {code}
> empty_insert still contains 'a'; # should be nothing 



--
This message was sent by Atlassian JIRA
(v7.6.3#76005)

[jira] [Commented] (HIVE-16842) insert overwrite with select does not remove data when the select query returns empty resultset

[anishek (JIRA)]

[ 
https://issues.apache.org/jira/browse/HIVE-16842?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16042289#comment-16042289
 ] 

anishek commented on HIVE-16842:


cc [~sershe] 

> insert overwrite with select does not remove data when the select query 
> returns empty resultset
> ---
>
> Key: HIVE-16842
> URL: https://issues.apache.org/jira/browse/HIVE-16842
> Project: Hive
>  Issue Type: Bug
>  Components: HiveServer2
>Affects Versions: 3.0.0
>Reporter: anishek
> Fix For: 3.0.0
>
>
> {code}create table address (city string);
> insert into address values ('b');
> create table empty_insert (city string);
> insert into empty_insert values ('a');
> insert overwrite table empty_insert select city from address where city='g';
> {code}
> empty_insert still contains 'a'; # should be nothing 



--
This message was sent by Atlassian JIRA
(v6.3.15#6346)

[jira] [Commented] (HIVE-16842) insert overwrite with select does not remove data when the select query returns empty resultset

[anishek (JIRA)]

[ 
https://issues.apache.org/jira/browse/HIVE-16842?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16040571#comment-16040571
 ] 

anishek commented on HIVE-16842:


none of these configurations should matter but listing the changes i did from 
default just in case i am mistaken.
{code}

hive.async.log.enabled
false


hive.execution.mode
container


hive.tez.exec.inplace.progress
true


hive.server2.in.place.progress
true


hive.server2.logging.operation.log.location
/tmp/hive/operationslog


hive.exec.local.scratchdir
/tmp/hive/scratch


hive.downloaded.resources.dir
/tmp/hive/resources


hive.server2.enable.doAs
false


hive.execution.engine
tez


javax.jdo.option.ConnectionDriverName
org.apache.derby.jdbc.ClientDriver


javax.jdo.option.ConnectionURL
jdbc:derby://localhost:1527/APP;create=true;databaseName=APP



datanucleus.mapping.Schema
APP


  hive.metastore.transactional.event.listeners
  org.apache.hive.hcatalog.listener.DbNotificationListener


  hive.metastore.dml.events
  true


  hive.metastore.event.db.listener.timetolive
  86400s


  hive.repl.rootdir
  /tmp/dump


  hive.repl.replica.functions.root.dir
  /user/hive/repl/functions/


  hive.repl.cm.enabled
  true


  hive.repl.cmrootdir
  /user/hive/cmroot/


  hive.repl.cm.retain
  2h


{code}

> insert overwrite with select does not remove data when the select query 
> returns empty resultset
> ---
>
> Key: HIVE-16842
> URL: https://issues.apache.org/jira/browse/HIVE-16842
> Project: Hive
>  Issue Type: Bug
>  Components: HiveServer2
>Affects Versions: 3.0.0
>Reporter: anishek
> Fix For: 3.0.0
>
>
> {code}create table address (city string);
> insert into address values ('b');
> create table empty_insert (city string);
> insert into empty_insert values ('a');
> insert overwrite table empty_insert select city from address where city='g';
> {code}
> empty_insert still contains 'a'; # should be nothing 



--
This message was sent by Atlassian JIRA
(v6.3.15#6346)