Home | About | Sematext search-lucene.com search-hadoop.com
NEW: Monitor These Apps!
elasticsearch, apache solr, apache hbase, hadoop, redis, casssandra, amazon cloudwatch, mysql, memcached, apache kafka, apache zookeeper, apache storm, ubuntu, centOS, red hat, debian, puppet labs, java, senseiDB
 Search Hadoop and all its subprojects:

Switch to Threaded View
Sqoop >> mail # user >> Load from Hive table to HDFS using sqoop


Copy link to this message
-
Re: Load from Hive table to HDFS using sqoop
Hi Prabhu, you may find the Sqoop wiki page
https://cwiki.apache.org/confluence/display/SQOOP/Home helpful.

Regards, Kathleen

On Wed, Jul 11, 2012 at 9:07 PM, prabhu k <[EMAIL PROTECTED]> wrote:
> Hi Kathleen,
>
> Thanks for providing the link,  can you  please share more links for sqoop.
>
> as Am learning stage, I have to learn more on sqoop.
>
>  I am waiting for your response.
>
> Regards,
> Prabhu.
>
>
> On Thu, Jul 12, 2012 at 12:39 AM, Kathleen Ting <[EMAIL PROTECTED]> wrote:
>>
>> Hi Prabhu,
>>
>> To add on to what Bejoy mentioned, while Sqoop is generally used to
>> transfer data between a JDBC compliant RDBMS and Hadoop, it is not
>> restricted to it - an example is Sqoop's connector to Couchbase.
>>
>> Furthermore in Sqoop 2, connectors will no longer be restricted to the
>> JDBC model, but can rather define their own vocabulary, e.g. Couchbase
>> no longer needs to specify a table name, only to overload it as a
>> backfill or dump operation:
>> https://blogs.apache.org/sqoop/entry/apache_sqoop_highlights_of_sqoop
>>
>> Regards, Kathleen
>>
>> On Wed, Jul 11, 2012 at 10:56 AM, prabhu k <[EMAIL PROTECTED]> wrote:
>> > Thanks for the response, I will go through the guide and come back to
>> > you..
>> >
>> > On Wed, Jul 11, 2012 at 2:26 PM, Bejoy KS <[EMAIL PROTECTED]> wrote:ha
>> >
>> >> Hi Prabhu
>> >>
>> >> Sqoop is used to transfer data between Jdbc compliant RDBMS and hadoop.
>> >>
>> >> For hive the underlying storage is mostly hdfs, so the question for
>> >> data
>> >> transfer between hdfs and hive seems irrelevant
>> >>
>> >> You can use SQOOP import to transfer data from rdbms to hadoop. Specify
>> >> the connection parameters and other required arguments. Please refer
>> >> Sqoop
>> >> User guide for details on sqoop import.
>> >> Regards
>> >> Bejoy KS
>> >>
>> >> Sent from handheld, please excuse typos.
>> >> ________________________________
>> >> From: prabhu k <[EMAIL PROTECTED]>
>> >> Date: Wed, 11 Jul 2012 14:09:49 +0530
>> >> To: <[EMAIL PROTECTED]>
>> >> ReplyTo: [EMAIL PROTECTED]
>> >> Subject: Load from Hive table to HDFS using sqoop
>> >>
>> >> Hi Users list,
>> >>
>> >> Please help me on the below .
>> >>
>> >> 1. how to load from Hive table to HDFS using sqoop
>> >>
>> >> 2. How to load from mysql database to HDFS using sqoop
>> >>
>> >> 3. How to load from HDFS to Hive table using sqoop.
>> >>
>> >> Thanks,
>> >> Prabhu.
>> >
>> >
>
>
NEW: Monitor These Apps!
elasticsearch, apache solr, apache hbase, hadoop, redis, casssandra, amazon cloudwatch, mysql, memcached, apache kafka, apache zookeeper, apache storm, ubuntu, centOS, red hat, debian, puppet labs, java, senseiDB