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

Case-sensitivity for column names when reading from ORC

    XMLWordPrintableJSON

    Details

    • Type: Bug
    • Status: Resolved
    • Priority: Major
    • Resolution: Fixed
    • Affects Version/s: 2.3.2
    • Fix Version/s: None
    • Component/s: Hive, ORC
    • Labels:
      None

      Description

      Hello everyone,

      I observed a different behavior between version 1.2.1 and 2.3.2 (that's the only two versions I've been able to test).

      When creating an external table pointing to ORC files and having upper cased column names in the ORC files metadata I'm able to read the data on 1.2.1 but not on 2.3.2.

      I tested with both upper cased and lower cased column names in my CREATE TABLE statement and it does not work in both cases. Looks like normal since column names are normalized to lower case in Hive.

      So, I would like to know if this is a feature or a bug in Hive 2.3.2 ?

      In fact, if this is a feature it would be impossible to have upper case column names in ORC files with Hive 2.3.2.

      Please, let me know if you need more informations.

      Kind regards,

      Alexandre

        Attachments

          Activity

            People

            • Assignee:
              Unassigned
              Reporter:
              alexandreyc Alexandre Crayssac
            • Votes:
              0 Vote for this issue
              Watchers:
              2 Start watching this issue

              Dates

              • Created:
                Updated:
                Resolved: