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