[ https://issues.apache.org/jira/browse/HIVE-3064?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13287132#comment-13287132 ]
Mark Grover commented on HIVE-3064: ----------------------------------- Just to clarify, the name of the table used in the actual "insert into table" statement is what matters. The table may have been created using upper case or lower case letters, but if the user enters the name (or a part of the name) of the table in upper case in the "insert into table" statement, it acts like "insert overwrite table". > 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