hive-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From alo alt <wget.n...@googlemail.com>
Subject Re: Loading data into hive tables
Date Fri, 09 Dec 2011 08:47:12 GMT
u welcome :)

On Fri, Dec 9, 2011 at 9:44 AM, Aditya Singh30
<Aditya_Singh30@infosys.com>wrote:

> Thanks a lot. It is the very thing I was looking for.. J****
>
> ** **
>
> *From:* alo alt [mailto:wget.null@googlemail.com]
> *Sent:* Friday, December 09, 2011 1:27 PM
> *To:* user@hive.apache.org; bejoy_ks@yahoo.com
> *Subject:* Re: Loading data into hive tables****
>
> ** **
>
> Adithya,****
>
> ** **
>
> Here small articles about:****
>
> MS SQL => Sqoop****
>
> http://mapredit.blogspot.com/2011/10/sqoop-and-microsoft-sql-server.html**
> **
>
> ** **
>
> And to use the self-generated classes:****
>
> http://mapredit.blogspot.com/2011/10/speedup-sqoop.html****
>
> ** **
>
> - Alex****
>
> ** **
>
> On Fri, Dec 9, 2011 at 5:51 AM, <bejoy_ks@yahoo.com> wrote:****
>
> Adithya
> The answer is yes. SQOOP is the tool you are looking for. It has an import
> option to load data from from any jdbc compliant database into hive. It
> even creates the hive table for you by refering to the source db table.
>
> Hope It helps!..****
>
> Regards
> Bejoy K S****
> ------------------------------
>
> *From: *Aditya Singh30 <Aditya_Singh30@infosys.com> ****
>
> *Date: *Fri, 9 Dec 2011 09:57:26 +0530****
>
> *To: *user@hive.apache.org<user@hive.apache.org>****
>
> *ReplyTo: *user@hive.apache.org ****
>
> *Subject: *Loading data into hive tables****
>
> ** **
>
> Hi,****
>
>                 I want to know if there is any way to load data directly
> from some other DB, say Oracle/MySQL etc., into hive tables, without
> getting the data from DB into a text/rcfile/sequence file in a specific
> format and then loading the data from that file into hive table. ****
>
>  ****
>
> Regards,****
>
> Aditya****
>
> **************** CAUTION - Disclaimer *********************
>
> This e-mail contains PRIVILEGED AND CONFIDENTIAL INFORMATION intended solely****
>
> for the use of the addressee(s). If you are not the intended recipient, please****
>
> notify the sender by e-mail and delete the original message. Further, you are not****
>
> to copy, disclose, or distribute this e-mail or its contents to any other person and****
>
> any such actions are unlawful. This e-mail may contain viruses. Infosys has taken****
>
> every reasonable precaution to minimize this risk, but is not liable for any damage****
>
> you may sustain as a result of any virus in this e-mail. You should carry out your****
>
> own virus checks before opening the e-mail or attachment. Infosys reserves the****
>
> right to monitor and review the content of all messages sent to or from this e-mail****
>
> address. Messages sent to or from this e-mail address may be stored on the****
>
> Infosys e-mail system.****
>
> ***INFOSYS******** End of Disclaimer ********INFOSYS*******
>
>
>
> ****
>
> ** **
>
> -- ****
>
> Alexander Lorenz****
>
> http://mapredit.blogspot.com****
>
> ** **
>
> *P **Think of the environment: please don't print this email unless you
> really need to.*****
>
> ** **
>
> ** **
>



-- 
Alexander Lorenz
http://mapredit.blogspot.com

*P **Think of the environment: please don't print this email unless you
really need to.*

Mime
View raw message