hive-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From abhishek <>
Subject Re: DB2 DDL to Hive DDL conversion **Need Help**
Date Fri, 19 Feb 2016 17:35:24 GMT
Hi Dmitry, 

You understood my requirements. Our requirement is to create tables in hive using DB2 DDL
script. Means converting DB2 DDL into hive DDL. 
I think HPL/SQL tool will work. Can you please share the details and user guide of the tool.


Sent from my iPhone

> On Feb 19, 2016, at 12:55 AM, Mohit Durgapal <> wrote:
> Have you considered using Sqoop? If not, then please have a look at the following links:
>> On Fri, Feb 19, 2016 at 1:04 PM, Abhishek Singh <> 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

View raw message