Support Questions
Find answers, ask questions, and share your expertise
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


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