Mailing-List: contact dev-help@hive.apache.org; run by ezmlm
Precedence: bulk
Reply-To: dev@hive.apache.org
Date: Thu, 27 Sep 2012 06:51:08 +1100 (NCT)
From: "Hudson (JIRA)" <jira@apache.org>
To: hive-dev@hadoop.apache.org
Message-ID: <579473683.130235.1348689068133.JavaMail.jiratomcat@arcas>
In-Reply-To: <270525699.80629.1347635287593.JavaMail.jiratomcat@arcas>
Subject: [jira] [Commented] (HIVE-3465) insert into statement overwrites if
 target table is prefixed with database name
MIME-Version: 1.0
Content-Type: text/plain; charset=utf-8
Content-Transfer-Encoding: 7bit


    [ 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