Getting NULL values for UPPERCASE columns while reading an orc table from Hive(version 2.3.0-amzn-0)

[#1]

Hi,

We are storing some column names in UPPER CASE while generating an ORC file. When we read the ORC file from hive 2.3.0 in EMR, we are getting NULL values for all UPPER-CASE columns. It is working fine in hive2.1.0 and other versions.

Below is the metadata of orc file

Type: struct<GRADE:double,LOSAL:double,HISAL:double,purge_seq_id:double,purge_date:timestamp,aj_retention_applied:string,aj_pk_column:double>

It is a known issue in Hive 0.13 and got fixed in later versions.

Please help me out.....

Thanks in advance

[#2]

Need to work on hive2.3.0 version. So, Is there any workaround for hive2.3.0?

[#3]

Hi All

I am facing the same Issue , The columns which have Uppercase are populating as null , I need some help

Thanks