RE: Importing into a hive database with minimal unavailability or renaming a database

2015-12-18 Thread Mich Talebzadeh
Ltd, its subsidiaries nor their employees accept any responsibility. From: Marcin Tustin [mailto:mtus...@handybook.com] Sent: 18 December 2015 14:15 To: user@hive.apache.org Subject: Importing into a hive database with minimal unavailability or renaming a database Hi All, We import ou

Importing into a hive database with minimal unavailability or renaming a database

2015-12-18 Thread Marcin Tustin
Hi All, We import our production database into hive on a schedule using sqoop. Unfortunately, sqoop won't update the table schema in hive when the table schema has changed in the source database. Accordingly, to get updates to the table schema we drop the hive table first. Unfortunately, this ca