@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 <[email protected]>
To: [email protected]
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 <[email protected]> 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