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

Reply via email to