@Krishare u looking for an automated tool that takes RDBMS DDL as input and outputs Hive DDL ?I exported the DDLS of all tables with col sequence numbersI wrote code that converted all DB2 tables we have to Hive. Not sure if there is a standard tool. regards sanjay From: Lefty Leverenz <leftylever...@gmail.com> To: user@hive.apache.org Sent: Thursday, January 8, 2015 1:34 PM Subject: Re: How to convert RDBMS DDL to Hive DDL ? Have you looked at the documentation? If not, start here: - Creating, Showing, Altering, and Dropping Tables
- Create Table -- Lefty On Thu, Jan 8, 2015 at 12:28 PM, Krish Donald <gotomyp...@gmail.com> wrote: Hi, I am new to hive and I have imported data into HDFS using DB2.Now I want to create hive table.I am not sure How to convert RDBMS DDL to Hive DDL ?Can somebody please guide ? ThanksKrish