You are viewing a plain text version of this content. The canonical link for it is here.
Posted to dev@hive.apache.org by "Kaufman Ng (JIRA)" <ji...@apache.org> on 2012/09/14 17:08:07 UTC
[jira] [Created] (HIVE-3465) insert into statement overwrites if
target table is prefixed with database name
Kaufman Ng created HIVE-3465:
--------------------------------
Summary: 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
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
[jira] [Commented] (HIVE-3465) insert into statement overwrites if
target table is prefixed with database name
Posted by "Hudson (JIRA)" <ji...@apache.org>.
[ https://issues.apache.org/jira/browse/HIVE-3465?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13464106#comment-13464106 ]
Hudson commented on HIVE-3465:
------------------------------
Integrated in Hive-trunk-h0.21 #1699 (See [https://builds.apache.org/job/Hive-trunk-h0.21/1699/])
HIVE-3465. insert into statement overwrites if target table is prefixed with database name (Navis Ryu via cws) (Revision 1390343)
Result = FAILURE
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
[jira] [Updated] (HIVE-3465) insert into statement overwrites if
target table is prefixed with database name
Posted by "Phabricator (JIRA)" <ji...@apache.org>.
[ https://issues.apache.org/jira/browse/HIVE-3465?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Phabricator updated HIVE-3465:
------------------------------
Attachment: HIVE-3465.D5661.1.patch
navis requested code review of "HIVE-3465 [jira] insert into statement overwrites if target table is prefixed with database name".
Reviewers: JIRA
DPAL-1903 insert into statement overwrites if target table is prefixed with database name
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;
TEST PLAN
EMPTY
REVISION DETAIL
https://reviews.facebook.net/D5661
AFFECTED FILES
ql/src/java/org/apache/hadoop/hive/ql/parse/BaseSemanticAnalyzer.java
ql/src/java/org/apache/hadoop/hive/ql/parse/QBParseInfo.java
ql/src/java/org/apache/hadoop/hive/ql/parse/SemanticAnalyzer.java
ql/src/test/queries/clientpositive/insert1.q
ql/src/test/results/clientpositive/insert1.q.out
MANAGE HERALD DIFFERENTIAL RULES
https://reviews.facebook.net/herald/view/differential/
WHY DID I GET THIS EMAIL?
https://reviews.facebook.net/herald/transcript/13293/
To: JIRA, navis
> 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
> 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
[jira] [Updated] (HIVE-3465) insert into statement overwrites if
target table is prefixed with database name
Posted by "Carl Steinbach (JIRA)" <ji...@apache.org>.
[ https://issues.apache.org/jira/browse/HIVE-3465?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Carl Steinbach updated HIVE-3465:
---------------------------------
Resolution: Fixed
Fix Version/s: 0.10.0
Hadoop Flags: Reviewed
Status: Resolved (was: Patch Available)
Committed to trunk. Thanks Navis!
> 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
[jira] [Assigned] (HIVE-3465) insert into statement overwrites if
target table is prefixed with database name
Posted by "Navis (JIRA)" <ji...@apache.org>.
[ https://issues.apache.org/jira/browse/HIVE-3465?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Navis reassigned HIVE-3465:
---------------------------
Assignee: Navis
> 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
>
> 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
[jira] [Commented] (HIVE-3465) insert into statement overwrites if
target table is prefixed with database name
Posted by "Phabricator (JIRA)" <ji...@apache.org>.
[ https://issues.apache.org/jira/browse/HIVE-3465?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13463216#comment-13463216 ]
Phabricator commented on HIVE-3465:
-----------------------------------
cwsteinbach has accepted the revision "HIVE-3465 [jira] insert into statement overwrites if target table is prefixed with database name".
REVISION DETAIL
https://reviews.facebook.net/D5661
BRANCH
DPAL-1903
To: JIRA, cwsteinbach, navis
> 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
> 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
[jira] [Updated] (HIVE-3465) insert into statement overwrites if
target table is prefixed with database name
Posted by "Navis (JIRA)" <ji...@apache.org>.
[ https://issues.apache.org/jira/browse/HIVE-3465?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Navis updated HIVE-3465:
------------------------
Status: Patch Available (was: Open)
https://reviews.facebook.net/D5661
> 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
> Attachments: HIVE-3465.1.patch.txt
>
>
> 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
[jira] [Commented] (HIVE-3465) insert into statement overwrites if
target table is prefixed with database name
Posted by "Carl Steinbach (JIRA)" <ji...@apache.org>.
[ https://issues.apache.org/jira/browse/HIVE-3465?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13463214#comment-13463214 ]
Carl Steinbach commented on HIVE-3465:
--------------------------------------
+1. Will commit if tests pass.
> 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
> 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
[jira] [Updated] (HIVE-3465) insert into statement overwrites if
target table is prefixed with database name
Posted by "Navis (JIRA)" <ji...@apache.org>.
[ https://issues.apache.org/jira/browse/HIVE-3465?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Navis updated HIVE-3465:
------------------------
Attachment: HIVE-3465.1.patch.txt
> 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
> Attachments: HIVE-3465.1.patch.txt
>
>
> 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