Chandeep, My target tables are existing DB2 tables and we have to move data from Hive staging tables to target DB2 tables using informatica BDE. Means, we are looking for one to one mapping between hive and DB2 metadata. As DB2 tables are existing we are looking for a reverse re engineering to have the hive DDL created using existing DB2 DDL to avoid lots of manual work.
Abhi On Fri, Feb 19, 2016 at 9:59 AM, Chandeep Singh <c...@chandeep.com> wrote: > Tables can be imported directly into Hive using Sqoop with the following > flag --hive-import. > > Once you have the tables in Hive you can get their create DDL scripts > using SHOW CREATE TABLE <table name>; > > On Feb 19, 2016, at 5:31 PM, Mohit Durgapal <durgapalmo...@gmail.com> > wrote: > > If he can import the scripts in db2 rdbms then it can create equivalent > hive ddl script using sqoop. > > On Friday 19 February 2016, Dmitry Tolpeko <dmtolp...@gmail.com> wrote: > >> Abhi needs to convert SQL scripts so I am afraid Sqoop will not help. >> >> Abhi, do you need to get equivalent Hive scripts or creating tables in >> Hive will be enough (without having scripts)? The new HPL/SQL tool is >> designed to execute existing DDL (created for any database), convert on the >> fly and create tables in Hive. >> >> Will it be a good solution for you? I tested HPL/SQL using Oracle, SQL >> Server and some DB2 DDL. If there are issues I can extend the tool, contact >> me. >> >> Dmitry >> >> >> On Fri, Feb 19, 2016 at 11: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 >>>> >>> >>> >> >
