[
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}
<property>
<name>hive.async.log.enabled</name>
<value>false</value>
</property>
<property>
<name>hive.execution.mode</name>
<value>container</value>
</property>
<property>
<name>hive.tez.exec.inplace.progress</name>
<value>true</value>
</property>
<property>
<name>hive.server2.in.place.progress</name>
<value>true</value>
</property>
<property>
<name>hive.server2.logging.operation.log.location</name>
<value>/tmp/hive/operationslog</value>
</property>
<property>
<name>hive.exec.local.scratchdir</name>
<value>/tmp/hive/scratch</value>
</property>
<property>
<name>hive.downloaded.resources.dir</name>
<value>/tmp/hive/resources</value>
</property>
<property>
<name>hive.server2.enable.doAs</name>
<value>false</value>
</property>
<property>
<name>hive.execution.engine</name>
<value>tez</value>
</property>
<property>
<name>javax.jdo.option.ConnectionDriverName</name>
<value>org.apache.derby.jdbc.ClientDriver</value>
</property>
<property>
<name>javax.jdo.option.ConnectionURL</name>
<value>jdbc:derby://localhost:1527/APP;create=true;databaseName=APP
</value>
</property>
<property>
<name>datanucleus.mapping.Schema</name>
<value>APP</value>
</property>
<property>
<name>hive.metastore.transactional.event.listeners</name>
<value>org.apache.hive.hcatalog.listener.DbNotificationListener</value>
</property>
<property>
<name>hive.metastore.dml.events</name>
<value>true</value>
</property>
<property>
<name>hive.metastore.event.db.listener.timetolive</name>
<value>86400s</value>
</property>
<property>
<name>hive.repl.rootdir</name>
<value>/tmp/dump</value>
</property>
<property>
<name>hive.repl.replica.functions.root.dir</name>
<value>/user/hive/repl/functions/</value>
</property>
<property>
<name>hive.repl.cm.enabled</name>
<value>true</value>
</property>
<property>
<name>hive.repl.cmrootdir</name>
<value>/user/hive/cmroot/</value>
</property>
<property>
<name>hive.repl.cm.retain</name>
<value>2h</value>
</property>
{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)
