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 Plain View
Sqoop >> mail # user >> SQOOP 2 : query hadoop nodes before export


+
Κωνσταντίνος Αρετάκης 2013-06-29, 18:26
Copy link to this message
-
Re: SQOOP 2 : query hadoop nodes before export
Hi sir,
I'm afraid that Sqoop 2 currently do not offer any filtering abilities during export. You can however use hive/pig/impala/mapreduce to filter the entries that you need to export prior running Sqoop 2 export.

Jarcec

On Sat, Jun 29, 2013 at 09:26:32PM +0300, Κωνσταντίνος Αρετάκης wrote:
> Hi all,
>
> I have some data in hadoop nodes and I want to export them to a relational
> database.
> However I don't want all of them.
> So does sqoop2 supports to execute sql queries at hadoop nodes before
> exporting the data to the relational database?
>
> Thanks
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