Hive
  1. Hive
  2. HIVE-912

table name in CTAS should be case-insensitive

    Details

    • Type: Bug Bug
    • Status: Closed
    • Priority: Major Major
    • Resolution: Fixed
    • Affects Version/s: None
    • Fix Version/s: 0.5.0
    • Component/s: None
    • Labels:
      None
    • Hadoop Flags:
      Reviewed

      Description

      Table created in CTAS should be case sensitive. Currently the moveTask at the end of CTAS doesn't convert table name to lower case. This makes subsequent accessing to the table impossible since they are looking for lower case table names.

      1. Hive-912_3.patch
        15 kB
        Ning Zhang
      2. Hive-912_2.patch
        15 kB
        Ning Zhang
      3. Hive-912.patch
        14 kB
        Ning Zhang

        Activity

        Ning Zhang created issue -
        Ning Zhang made changes -
        Field Original Value New Value
        Attachment Hive-912.patch [ 12424026 ]
        Ning Zhang made changes -
        Summary table name in CTAS should be case-insensitive table name in DDL should be case-insensitive
        Description Found the issue is not only limited to CTAS, it is true for all create-table statement. Modify the title and will upload a new patch.
        Ning Zhang made changes -
        Attachment Hive-912_2.patch [ 12424144 ]
        Ning Zhang made changes -
        Description Found the issue is not only limited to CTAS, it is true for all create-table statement. Modify the title and will upload a new patch. Table created in CTAS should be case sensitive. Currently the moveTask at the end of CTAS doesn't convert table name to lower case. This makes subsequent accessing to the table impossible since they are looking for lower case table names.
        Summary table name in DDL should be case-insensitive table name in CTAS should be case-insensitive
        Ning Zhang made changes -
        Attachment Hive-912_3.patch [ 12424564 ]
        Namit Jain made changes -
        Status Open [ 1 ] Resolved [ 5 ]
        Hadoop Flags [Reviewed]
        Fix Version/s 0.5.0 [ 12314156 ]
        Resolution Fixed [ 1 ]
        Carl Steinbach made changes -
        Status Resolved [ 5 ] Closed [ 6 ]

          People

          • Assignee:
            Ning Zhang
            Reporter:
            Ning Zhang
          • Votes:
            0 Vote for this issue
            Watchers:
            0 Start watching this issue

            Dates

            • Created:
              Updated:
              Resolved:

              Development