Return-Path: X-Original-To: apmail-hive-user-archive@www.apache.org Delivered-To: apmail-hive-user-archive@www.apache.org Received: from mail.apache.org (hermes.apache.org [140.211.11.3]) by minotaur.apache.org (Postfix) with SMTP id 248644DAC for ; Tue, 31 May 2011 15:02:44 +0000 (UTC) Received: (qmail 72417 invoked by uid 500); 31 May 2011 15:02:42 -0000 Delivered-To: apmail-hive-user-archive@hive.apache.org Received: (qmail 72383 invoked by uid 500); 31 May 2011 15:02:42 -0000 Mailing-List: contact user-help@hive.apache.org; run by ezmlm Precedence: bulk List-Help: List-Unsubscribe: List-Post: List-Id: Reply-To: user@hive.apache.org Delivered-To: mailing list user@hive.apache.org Received: (qmail 72374 invoked by uid 99); 31 May 2011 15:02:42 -0000 Received: from athena.apache.org (HELO athena.apache.org) (140.211.11.136) by apache.org (qpsmtpd/0.29) with ESMTP; Tue, 31 May 2011 15:02:42 +0000 X-ASF-Spam-Status: No, hits=1.5 required=5.0 tests=FREEMAIL_FROM,HTML_MESSAGE,RCVD_IN_DNSWL_LOW,RFC_ABUSE_POST,SPF_PASS,T_TO_NO_BRKTS_FREEMAIL X-Spam-Check-By: apache.org Received-SPF: pass (athena.apache.org: domain of edlinuxguru@gmail.com designates 209.85.210.176 as permitted sender) Received: from [209.85.210.176] (HELO mail-iy0-f176.google.com) (209.85.210.176) by apache.org (qpsmtpd/0.29) with ESMTP; Tue, 31 May 2011 15:02:36 +0000 Received: by iym1 with SMTP id 1so6103022iym.35 for ; Tue, 31 May 2011 08:02:15 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=gamma; h=domainkey-signature:mime-version:in-reply-to:references:date :message-id:subject:from:to:content-type; bh=yg1N+6s9bvLbSjpal0xPe44lsTqWo9/pr9r8BnUi3JI=; b=USzetC4j8246pcMKpbvJFI0C4ibOsSzpTo6McMy+EEJ6aG+f2lA1eKUP5XTSMYPIli IgLBRDNfBwFENzUE+nEI5sLvUFathCS02/yY06EsfrBolTS0Uce+6Tu5MHyVoIvoNJiy +sgNX+UwIy0s3k+kQDTCsyUPf27OnWg4JTRXI= DomainKey-Signature: a=rsa-sha1; c=nofws; d=gmail.com; s=gamma; h=mime-version:in-reply-to:references:date:message-id:subject:from:to :content-type; b=TKQtdaDVi8Ysu0mwaWl9q4AyKsAzXz80EaF7fWXX2izBHzA5vdmcb3T5lwdTpR4D6O M5PGV7jv1FMbmh8cUhZfDauw6xDcbwyHDaKhRWIT9R7HttARKK3uno9wQgk6/gjKsXmn XjSoUa/gzCr03NRAYcv5kzIPXovXZypwiau6Y= MIME-Version: 1.0 Received: by 10.42.157.138 with SMTP id d10mr6883424icx.490.1306854135620; Tue, 31 May 2011 08:02:15 -0700 (PDT) Received: by 10.42.19.3 with HTTP; Tue, 31 May 2011 08:02:15 -0700 (PDT) In-Reply-To: <6AB151AD074C18409E0CA3CD8D4312302C1B2C2461@EXVMBX017-12.exch017.msoutlookonline.net> References: <6AB151AD074C18409E0CA3CD8D4312302C1B2C2461@EXVMBX017-12.exch017.msoutlookonline.net> Date: Tue, 31 May 2011 11:02:15 -0400 Message-ID: Subject: Re: RDBS and Hive From: Edward Capriolo To: user@hive.apache.org Content-Type: multipart/alternative; boundary=90e6ba6134fa86e4a804a493b0bc --90e6ba6134fa86e4a804a493b0bc Content-Type: text/plain; charset=windows-1252 Content-Transfer-Encoding: quoted-printable There is a ticket open for a JDBC storage handler. I envision this as a sqoop on demand. Edward On Tue, May 31, 2011 at 8:31 AM, Guy Doulberg wro= te: > Hey friends, > > > > I have been using Hive to explore my HDFS for a while now. > > > > In my organization we have some applicative information in SqlServer that > occasionally I need to join with data I have in the HDFS. > > > > When I need to do such a join, I import the data from the SqlServer using > sqoop. > > > > I wanted to know, if there is a way in which hive will import the data on > demand, according to the query, for example, if I am selecting from a tab= le > that hive recognizes as a SqlServer table, it will import that table > or(update if already exists) from sqlserver, and later will run the selec= t=85 > > > > > > Thanks, > > Guy Doulberg > > > --90e6ba6134fa86e4a804a493b0bc Content-Type: text/html; charset=windows-1252 Content-Transfer-Encoding: quoted-printable There is a ticket open for a JDBC storage handler. I envision this as a sqo= op on demand.

Edward

On Tue, May 3= 1, 2011 at 8:31 AM, Guy Doulberg <Guy.Doulberg@conduit.com> wrote:

Hey friends,

=A0

I have been using Hive to explore my HDFS for a whi= le now.

=A0

In my organizatio= n we have some applicative information in SqlServer that occasionally I nee= d to join with data I have in the HDFS.

=A0

When I need to do= such a join, I import the data from the SqlServer using sqoop.

=A0

I wanted to know,= if there is a way in which hive will import the data on demand, according = to the query, for example, if I am selecting from a table that hive recogni= zes as a SqlServer table, it will import that table or(update if already ex= ists) from sqlserver, and later will run the select=85

=A0

=A0

Thanks,

Guy Doulberg

=A0


--90e6ba6134fa86e4a804a493b0bc--