Reply
Explorer
Posts: 33
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

Highlighted
Explorer
Posts: 33
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?

Announcements