Details
-
Bug
-
Status: Resolved
-
Minor
-
Resolution: Duplicate
-
0.8.0, 0.8.1
-
None
-
None
-
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
Description
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
Attachments
Issue Links
- duplicates
-
HIVE-3062 Insert into table overwrites existing table if table name contains uppercase character
- Closed