hive-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Mohit Durgapal <durgapalmo...@gmail.com>
Subject Re: DB2 DDL to Hive DDL conversion **Need Help**
Date Fri, 19 Feb 2016 08:55:38 GMT
Have you considered using Sqoop? If not, then please have a look at the
following links:

https://sqoop.apache.org/docs/1.4.3/SqoopUserGuide.html#_importing_data_into_hive
http://stackoverflow.com/questions/17064144/how-do-i-use-sqoop-for-importing-data-from-a-relational-db-to-sandbox-hive

On Fri, Feb 19, 2016 at 1:04 PM, Abhishek Singh <ec.abhishek@gmail.com>
wrote:

> Hi,
>
> We have almost 1000 DB2 RDBMS tables and for those we have the DDLs
> (script) available.
> We are looking for a way to convert all these DB2 DDLs into Hive DDL
> without writing Hive DDL statements for each and every table. Means, is
> there an
> automated tool available to do this?  If not, then can someone please
> guide me if we have to write code then what exactly needs to be done step
> by step. or any simple way to avoid lots of manual work.
>
> Thanks
>
> Abhi
>

Mime
View raw message