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.

Hive Alter Add column

Hive Alter Add column

New Contributor

I was trying out hive alter by adding new columns to existing table. 

 

I have set up a hive external table on top of HDFS ( CSV serde).. and later added a column .    when run a query , im getting nulls on a new column.. this is as expected.  however, i have ingested data(includes newly added column) now into HDFS  and when i run query again.. im still getting nulls on new column.  

 

can you pls help me why this is occurring ? do i need to run any commands ( analyze stats etc to get a values for newly added column)?

 

Also, when i drop and recreate external table ..its working as expected .    

 

appreciate your help.

 

 

1 REPLY 1
Highlighted

Re: Hive Alter Add column

Rising Star

Hi,

 

If there is any changes in the Hive metadata. Please try to run msck repair table <tablename> to get it in sync

 

Reference Link: https://www.cloudera.com/documentation/enterprise/5-13-x/topics/cdh_ig_hive_troubleshooting.html

 

Thanks

Jerry

Don't have an account?
Coming from Hortonworks? Activate your account here