[
https://issues.apache.org/jira/browse/HIVE-20693?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17495567#comment-17495567
]
Abinash Sharma commented on HIVE-20693:
---------------------------------------
It is the result of a feature in Hive 2.3.2. What is going on is that in Hive
1.2, the reader would match the file's schema using position rather than the
column's name. In Hive 2.3, we've moved to name equivalence, which is better,
but is a change in behavior.You can get the old behavior, if you configure
orc.force.positional.evolution to true. In ORC 1.5, which is included by Hive
3.1, you can also use orc.schema.evolution.case.sensitive to still use name
matching, but ignore case. As always in ORC, you can either change the property
globally in your configuration or set the table property for a more localized
change. [1]
[1]https://www.mail-archive.com/[email protected]/msg00229.html
> Case-sensitivity for column names when reading from ORC
> -------------------------------------------------------
>
> Key: HIVE-20693
> URL: https://issues.apache.org/jira/browse/HIVE-20693
> Project: Hive
> Issue Type: Bug
> Components: Hive, ORC
> Affects Versions: 2.3.2
> Reporter: Alexandre Crayssac
> Priority: Major
>
> 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
--
This message was sent by Atlassian Jira
(v8.20.1#820001)
