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.

what is the best way to refresh the hive table from production to test?

Highlighted

what is the best way to refresh the hive table from production to test?

Explorer

what is the best way to refresh the hive table from production to test?

1 REPLY 1

Re: what is the best way to refresh the hive table from production to test?

Contributor

I assume both production and test are Hadoop, and that it is a large table.

 

1. If the table content needs refreshing but the definition is the same - use distcp to copy the table files from production to test and simply replace the files in test. 

 

2. If the table definitions changed, copy the files using distcp to test as above. Then drop the old table and create new table with new definitions and new files as the location.

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