You are viewing a plain text version of this content. The canonical link for it is here.
Posted to dev@hive.apache.org by "Hudson (JIRA)" <ji...@apache.org> on 2013/01/09 11:28:36 UTC
[jira] [Commented] (HIVE-3465) insert into statement overwrites if
target table is prefixed with database name
[ https://issues.apache.org/jira/browse/HIVE-3465?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13548094#comment-13548094 ]
Hudson commented on HIVE-3465:
------------------------------
Integrated in Hive-trunk-hadoop2 #54 (See [https://builds.apache.org/job/Hive-trunk-hadoop2/54/])
HIVE-3676 [jira] INSERT INTO regression caused by HIVE-3465
(Navis Ryu via Carl Steinbach)
Summary: DPAL-1931 INSERT INTO regression caused by HIVE-3465
Test Plan: EMPTY
Reviewers: JIRA, cwsteinbach
Reviewed By: cwsteinbach
Differential Revision: https://reviews.facebook.net/D6741 (Revision 1410559)
HIVE-3465. insert into statement overwrites if target table is prefixed with database name (Navis Ryu via cws) (Revision 1390343)
Result = ABORTED
cws : http://svn.apache.org/viewcvs.cgi/?root=Apache-SVN&view=rev&rev=1410559
Files :
* /hive/trunk/ql/src/java/org/apache/hadoop/hive/ql/parse/BaseSemanticAnalyzer.java
* /hive/trunk/ql/src/java/org/apache/hadoop/hive/ql/parse/SemanticAnalyzer.java
* /hive/trunk/ql/src/test/queries/clientpositive/insert1.q
* /hive/trunk/ql/src/test/results/clientpositive/insert1.q.out
cws : http://svn.apache.org/viewcvs.cgi/?root=Apache-SVN&view=rev&rev=1390343
Files :
* /hive/trunk/ql/src/java/org/apache/hadoop/hive/ql/parse/BaseSemanticAnalyzer.java
* /hive/trunk/ql/src/java/org/apache/hadoop/hive/ql/parse/QBParseInfo.java
* /hive/trunk/ql/src/java/org/apache/hadoop/hive/ql/parse/SemanticAnalyzer.java
* /hive/trunk/ql/src/test/queries/clientpositive/insert1.q
* /hive/trunk/ql/src/test/results/clientpositive/insert1.q.out
> insert into statement overwrites if target table is prefixed with database name
> -------------------------------------------------------------------------------
>
> Key: HIVE-3465
> URL: https://issues.apache.org/jira/browse/HIVE-3465
> Project: Hive
> Issue Type: Bug
> Components: Query Processor
> Affects Versions: 0.8.1
> Reporter: Kaufman Ng
> Assignee: Navis
> Fix For: 0.10.0
>
> Attachments: HIVE-3465.1.patch.txt, HIVE-3465.D5661.1.patch
>
>
> insert into statement works as expected when the target table is not prefixed with database name. It does append correctly.
> However, if I specify a database name prefixing the target table, the statement just overwrites instead of appends:
> insert into table my_database.target select * from source;
--
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