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 causes the data to be unavailable in hive for a certain period of time. Accordingly, I'd like to know how people on this list have tackled the issue. Is there a way to get sqoop to update the table schema in hive, or can we import into a staging hive database and rename it? Thanks, Marcin -- Want to work at Handy? Check out our culture deck and open roles <http://www.handy.com/careers> Latest news <http://www.handy.com/press> at Handy Handy just raised $50m <http://venturebeat.com/2015/11/02/on-demand-home-service-handy-raises-50m-in-round-led-by-fidelity/> led by Fidelity