Support Questions
Find answers, ask questions, and share your expertise
Announcements
Alert: Welcome to the Unified Cloudera Community. Former HCC members be sure to read and learn how to activate your account here.

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

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

Contributor

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 REPLIES 2

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

Contributor

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

Highlighted

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

New Contributor

Hi All

 

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

 

Thanks