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.

Compare hive metadata tables

Highlighted

Compare hive metadata tables

Super Guru

I have control table and a working table. The working table schema changes (add,remove,alter) columns need to be applied to control table. I am using orc. Any quick and easy way to do this nightly?

3 REPLIES 3
Highlighted

Re: Compare hive metadata tables

@Sunile Manjee

One way to do this is to have external tables. Then you can just drop your control table and recreate it based on your working table.

Highlighted

Re: Compare hive metadata tables

Super Guru

@Shishir Saxena The control table is a hive managed table for ORC.

Re: Compare hive metadata tables

Contributor

@smanjee

Did you get any solution for this. I need to implement exactly the same thing for my piece of work.

Regards,

Sagar

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