We 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 Basak
Tata Consultancy Services
Mailto: debarshi.ba...@tcs.com
Website: http://www.tcs.com
____________________________________________
Experience certainty. IT Services
Business Solutions
Outsourcing
____________________________________________
-----Nitin Pawar
To: user@hive.apache.org
From: Nitin Pawar <nitinpawar...@gmail.com>
Date: 07/27/2012 12:09AM
Subject: Re: Creating Hive table by pulling data from mainFramestry 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
<siddharth.tiw...@live.com> wrote:
> Hey Team,
>
> We have huge tables in Mainframe DB2. Can some one tell if its possible to
> pull data from DB2 in Mainframe to hive and then use MapReduce to sort the
> data in hive and push it back to Mainframe table.
> Please help
>
>
> *------------------------*
> Cheers !!!
> Siddharth Tiwari
> Have a refreshing day !!!
> "Every duty is holy, and devotion to duty is the highest form of worship of
> God.”
> "Maybe other people will try to limit me but I don't limit myself"
--
Nitin Pawar
=====-----=====-----=====
Notice: The information contained in this e-mail
message and/or attachments to it may contain
confidential or privileged information. If you are
not the intended recipient, any dissemination, use,
review, distribution, printing or copying of the
information contained in this e-mail message
and/or attachments to it are strictly prohibited. If
you have received this communication in error,
please notify us by reply e-mail or telephone and
immediately and permanently delete the message
and any attachments. Thank you
