Sqoop, mail # user - export HDFS data from HDFS to multiple databases and mulitple tables at one time - 2014-04-18, 10:41
 Search Hadoop and all its subprojects:

Switch to Threaded View
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