[
https://issues.apache.org/jira/browse/HIVE-3676?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13491258#comment-13491258
]
Carl Steinbach commented on HIVE-3676:
--------------------------------------
Prior to HIVE-3465 the following set of statements produced the expected result:
{noformat}
CREATE DATABASE db2;
USE db2;
CREATE TABLE result(col1 STRING);
INSERT OVERWRITE TABLE result SELECT 'db2_insert1' FROM default.src LIMIT 1;
INSERT INTO TABLE result SELECT 'db2_insert2' FROM default.src LIMIT 1;
SELECT * FROM result;
> db_insert1
> db_insert2
{noformat}
While the following set of statements produced inaccurate results:
{noformat}
CREATE DATABASE db1;
CREATE TABLE db1.result(col1 STRING);
INSERT OVERWRITE TABLE db1.result SELECT 'db1_insert1' FROM src LIMIT 1;
INSERT INTO TABLE db1.result SELECT 'db1_insert2' FROM src LIMIT 1;
SELECT * FROM db1.result;
> db1_insert2
{noformat}
After HIVE-3465 the first set of statements produces inaccurate results, while
the second set of statements now behaves as expected.
> INSERT INTO regression caused by HIVE-3465
> ------------------------------------------
>
> Key: HIVE-3676
> URL: https://issues.apache.org/jira/browse/HIVE-3676
> Project: Hive
> Issue Type: Bug
> Components: Query Processor
> Reporter: Carl Steinbach
>
--
This message is automatically generated by JIRA.
If you think it was sent incorrectly, please contact your JIRA administrators
For more information on JIRA, see: http://www.atlassian.com/software/jira
