Return-Path: Delivered-To: apmail-hadoop-common-dev-archive@www.apache.org Received: (qmail 88462 invoked from network); 12 Nov 2009 21:37:08 -0000 Received: from hermes.apache.org (HELO mail.apache.org) (140.211.11.3) by minotaur.apache.org with SMTP; 12 Nov 2009 21:37:08 -0000 Received: (qmail 53889 invoked by uid 500); 12 Nov 2009 21:37:07 -0000 Delivered-To: apmail-hadoop-common-dev-archive@hadoop.apache.org Received: (qmail 53803 invoked by uid 500); 12 Nov 2009 21:37:07 -0000 Mailing-List: contact common-dev-help@hadoop.apache.org; run by ezmlm Precedence: bulk List-Help: List-Unsubscribe: List-Post: List-Id: Reply-To: common-dev@hadoop.apache.org Delivered-To: mailing list common-dev@hadoop.apache.org Received: (qmail 53793 invoked by uid 99); 12 Nov 2009 21:37:07 -0000 Received: from athena.apache.org (HELO athena.apache.org) (140.211.11.136) by apache.org (qpsmtpd/0.29) with ESMTP; Thu, 12 Nov 2009 21:37:07 +0000 X-ASF-Spam-Status: No, hits=-2.6 required=5.0 tests=AWL,BAYES_00,HTML_MESSAGE X-Spam-Check-By: apache.org Received-SPF: neutral (athena.apache.org: local policy) Received: from [74.125.92.25] (HELO qw-out-2122.google.com) (74.125.92.25) by apache.org (qpsmtpd/0.29) with ESMTP; Thu, 12 Nov 2009 21:37:05 +0000 Received: by qw-out-2122.google.com with SMTP id 3so510717qwe.35 for ; Thu, 12 Nov 2009 13:36:44 -0800 (PST) MIME-Version: 1.0 Received: by 10.229.27.19 with SMTP id g19mr500571qcc.11.1258061804231; Thu, 12 Nov 2009 13:36:44 -0800 (PST) In-Reply-To: References: <26322437.post@talk.nabble.com> <192871ECBD98E849A16CD3C8DE5661940A9BE7382A@CCLMBXVS2.carnival.com> <4aa34eb70911121002t196cae6l37bd034a8a242361@mail.gmail.com> Date: Thu, 12 Nov 2009 13:36:44 -0800 Message-ID: Subject: Re: ETL using Hadoop ??? From: Jeff Hammerbacher To: common-dev@hadoop.apache.org Content-Type: multipart/alternative; boundary=00163646d444f25c710478335615 --00163646d444f25c710478335615 Content-Type: text/plain; charset=ISO-8859-1 Hey Steve, See https://issues.apache.org/jira/browse/MAPREDUCE-1168. Regards, Jeff On Thu, Nov 12, 2009 at 1:35 PM, Steve Morin wrote: > Does sqoop also allow you to export data from hadoop to a db? I > didn't see that in the documentation > > -Steve > > On Thu, Nov 12, 2009 at 1:16 PM, Jeff Hammerbacher > wrote: > > Hey Rajendra, > > > > For the "E" part of your task, you may want to check out Sqoop: > > http://www.cloudera.com/hadoop-sqoop. > > > > Regards, > > Jeff > > > > On Thu, Nov 12, 2009 at 10:02 AM, Dhruba Borthakur > wrote: > > > >> Hi Rajendra, > >> > >> We use Hive for a large data warehouse, details here: > >> http://wiki.apache.org/hadoop/Hive > >> > >> thanks, > >> dhruba > >> > >> > >> On Thu, Nov 12, 2009 at 9:55 AM, Palikala, Rajendra (CCL) < > >> RPalikala@carnival.com> wrote: > >> > >> > Hi All, > >> > > >> > I am an experienced Informatica and Java Developer. I am very new to > >> > Hadoop. I have one basic question for the group. Please advise. > >> > > >> > Can we do ETL (Example: load data from an oracle table to another > oracle > >> > table) using Hadoop? If so, how can we implement that. > >> > > >> > From my understanding, I see that Hive is for reporting purposes and > not > >> > for ETL. Let me know if this is right. > >> > > >> > Regards, > >> > Rajendra > >> > > >> > > >> > >> > >> -- > >> Connect to me at http://www.facebook.com/dhruba > >> > > > --00163646d444f25c710478335615--