
資料表不大就20多兆,任務一直卡住不動,在Hadoop的8088頁面,任務也是卡住不執行
這個是源代碼:
private static int importDataFromMysql() throws Exception {
String[] args = new String[] {
"--connect","jdbc:mysql://10.0.37.43:3306/rocket",
"--driver","com.mysql.jdbc.Driver",
"-username","root",
"-password","root",
"--table","properties1",
"-m","1",
"--target-dir","/sqoop/properties3"};
String[] expandArguments = OptionsFileUtil.expandArguments(args);
SqoopTool tool = SqoopTool.getTool("import");
Configuration conf = new Configuration();
conf.set("fs.default.name", "hdfs://192.168.88.129:9000");//設定HDFS服務地址
conf.set("hadoop.job.user", "root");
conf.set("mapreduce.framework.name", "yarn");
conf.set("yarn.resourcemanager.hostname", "192.168.88.129");
conf.set("yarn.resourcemanager.address", "192.168.88.129:8032");
conf.set("yarn.resourcemanager.resource-tracker.address",
"192.168.88.129:8031");
conf.set("yarn.resourcemanager.scheduler.address", "192.168.88.129:8030");
conf.set("mapreduce.app-submission.cross-platform", "true");
Configuration loadPlugins = SqoopTool.loadPlugins(conf);
Sqoop sqoop = new Sqoop((com.cloudera.sqoop.tool.SqoopTool) tool, loadPlugins);
return Sqoop.runSqoop(sqoop, expandArguments);
}
轉載請註明出處,本文鏈接:https://www.uj5u.com/qita/58031.html
標籤:Spark
下一篇:【詳細】Python基礎(一)
