Sqoop is a nice tool to get dAta to/from DB2 to hive and then you can run hive
queries on top of it.
Lot of people are using this for traditional DBs and hadoop connectivity.
Sent from my iPhone
On Jul 26, 2012, at 11:32 AM, Siddharth Tiwari
wrote:
> Hey Team,
>
> We have huge tables in Mai
Can you export from DB2 to a plain text tab-separated file? You can certainly
import that to Hive.
Chuck Connell
Nuance R&D Data Team
Burlington, MA
From: Siddharth Tiwari [mailto:siddharth.tiw...@live.com]
Sent: Thursday, July 26, 2012 2:33 PM
To: hive user list
Subject: Creating Hive table by
YesWe have implemented a solution where we pulled data from DB2 using sqoop. There is certain problem we faced while doing this exercise which we overcame. I think the solution was a specific DB2 jdbc jar and creating a connection pool or something i can't recollect.Debarshi BasakTata Consultancy
try looking out at sqoop .. meant to transfer data from rdbms systems to hive
not sure it works with DB2 or not
On Fri, Jul 27, 2012 at 12:02 AM, Siddharth Tiwari
wrote:
> Hey Team,
>
> We have huge tables in Mainframe DB2. Can some one tell if its possible to
> pull data from DB2 in Mainframe t
