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 >> export HDFS data from HDFS to multiple databases and mulitple tables at one time


Copy link to this message
-
export HDFS data from HDFS to multiple databases and mulitple tables at one time

I have HDFS data with such directory and want to export them to Mysql tables.

data1/
          customer1
          customer2
          ........
data2/
         customer1
         customer2
         .........

Every customer has a database, and every kinds of data has a table.
We have about ten kinds of data and 100 customers, so i need to execute 1000 sqoop cmds to do this.  
Is there some method than i can execute all the cmds only one time to complete all the tasks?

Thanks,
Lei

[EMAIL PROTECTED]

 
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