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.

Who agreed with this topic

Adding a column to an existed Hive external table will show NULL values

Explorer

I have several parquet files on S3, which has three fields, user, reques,  timestamp

 

Case 1:

 

Create the external table then add partitions to it, eveything is fine

 

Case 2:

 

Create the external table without the field request, then add the `request` field by running the SQL "ALTER TABLE test ADD COLUMNS (request STRING);",  and finally add partitions to it.  Under this situation, all `request` will have NULL values

 

Can some one tell me why?

Who agreed with this topic