You are viewing a plain text version of this content. The canonical link for it is here.
Posted to dev@hive.apache.org by "Navis (JIRA)" <ji...@apache.org> on 2012/07/14 14:15:34 UTC
[jira] [Resolved] (HIVE-3064) in "insert into tablename"
statement,if the "tablename" contains uppercase characters this statement
will overwrite the table
[ https://issues.apache.org/jira/browse/HIVE-3064?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Navis resolved HIVE-3064.
-------------------------
Resolution: Duplicate
> 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.0, 0.8.1
> 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_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