Reply
Explorer
Posts: 36
Registered: ‎07-15-2015

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

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

Explorer
Posts: 36
Registered: ‎07-15-2015

Re: Getting NULL values for UPPERCASE columns while reading an orc table from Hive(version 2.3.0-amz

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

Highlighted
New Contributor
Posts: 1
Registered: ‎02-23-2018

Re: Getting NULL values for UPPERCASE columns while reading an orc table from Hive(version 2.3.0-amz

Hi All

 

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

 

Thanks

Announcements