Mailing-List: contact dev-help@hive.apache.org; run by ezmlm
Precedence: bulk
Reply-To: dev@hive.apache.org
Date: Wed, 30 May 2012 09:44:23 +0000 (UTC)
From: "caofangkun (JIRA)" <jira@apache.org>
To: hive-dev@hadoop.apache.org
Message-ID: <2147171382.15445.1338371063300.JavaMail.jiratomcat@issues-vm>
Subject: [jira] [Created] (HIVE-3064) in "insert into tablename"
 statement,if the "tablename" contains uppercase characters this statement
 will overwrite the table
MIME-Version: 1.0
Content-Type: text/plain; charset=utf-8
Content-Transfer-Encoding: 7bit

caofangkun created HIVE-3064:
--------------------------------

             Summary: in "insert into tablename" statement,if the "tablename" contains uppercase characters this statement will overwrite the table
                 Key: HIVE-3064
                 URL: https://issues.apache.org/jira/browse/HIVE-3064
             Project: Hive
          Issue Type: Bug
          Components: Query Processor
    Affects Versions: 0.8.1, 0.8.0
         Environment: Linux zongren-VirtualBox 3.0.0-14-generic #23-Ubuntu SMP Mon Nov 21 20:34:47 UTC 2011 i686 i686 i386 GNU/Linux
java version "1.6.0_25"
hadoop-0.20.2-cdh3u0
hive-0.8.0
            Reporter: caofangkun
            Priority: Minor


in "insert into tablename" statement,
if the "tablename" contains uppercase characters this statement will overwrite the table.

For Example:
hive> desc dual;
OK
dummy   string  
Time taken: 1.856 seconds

hive> select * from dual;
OK
dummy
Time taken: 3.133 seconds


drop table if exists tmp_test_1 ;
create EXTERNAL table tmp_test_1 (dummy string) partitioned by (dt string, hr string);
insert into table tmp_test_1 partition (dt='1', hr='1')  select * from dual;
insert into table tmp_TEST_1 partition (dt='1', hr='1') select count(*) from dual;
select * from tmp_zongren_test_1;

Result :
OK
1       1       1
Time taken: 0.121 seconds

--
This message is automatically generated by JIRA.
If you think it was sent incorrectly, please contact your JIRA administrators: https://issues.apache.org/jira/secure/ContactAdministrators!default.jspa
For more information on JIRA, see: http://www.atlassian.com/software/jira