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.abhis...@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 >
