what is the best way to refresh the hive table from production to test?
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.