Abhi, The approach is quite simple and straightforward:
1) HPL/SQL is available since Hive 2.0 released a few days ago, so if you are using a previous Hive version (or Impala, Spark SQL, Presto etc) you can take the tool at http://hplsql.org/download 2) Follow http://hplsql.org/start to set it up 3) Execute in a similar way as you execute Hive CLI but use hplsql: hplsql -f db2_ddl_script.sql It will parse your DDL and execute statements one by one. Of course I do not expect it will seamlessly run from the first shot, may be I need to extend the parser to deal with DB2 issues, so please contact me directly at dmtolp...@gmail.com about issues. I will try to help. Thanks, Dmitry On Fri, Feb 19, 2016 at 8:35 PM, abhishek <ec.abhis...@gmail.com> wrote: > 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. > > Abhi > > Sent from my iPhone > > On Feb 19, 2016, at 12:55 AM, Mohit Durgapal <durgapalmo...@gmail.com> > wrote: > > 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 >> > >
