Uploaded image for project: 'Hive'
  1. Hive
  2. HIVE-3064

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

    XMLWordPrintableJSON

Details

    • Bug
    • Status: Resolved
    • Minor
    • Resolution: Duplicate
    • 0.8.0, 0.8.1
    • None
    • Query Processor
    • 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

          Activity

            People

              Unassigned Unassigned
              caofangkun caofangkun
              Votes:
              0 Vote for this issue
              Watchers:
              2 Start watching this issue

              Dates

                Created:
                Updated:
                Resolved: