java sqoop_如何在Java程序中使用Sqoop？

有一个技巧，我很容易解决。通过ssh你可以直接执行Sqoop命令。只要你必须使用的是一个SSH Java库

你必须按照这一步。

下载sshxcute Java库：https://code.google.com/p/sshxcute/ 并将其添加到其中包含下面的Java代码Java项目的构建路径

import net.neoremind.sshxcute.core.SSHExec;

import net.neoremind.sshxcute.core.ConnBean;

import net.neoremind.sshxcute.task.CustomTask;

import net.neoremind.sshxcute.task.impl.ExecCommand;

public class TestSSH {

public static void main(String args[]) throws Exception{

// Initialize a ConnBean object, parameter list is ip, username, password

ConnBean cb = new ConnBean("192.168.56.102", "root","hadoop");

// Put the ConnBean instance as parameter for SSHExec static method getInstance(ConnBean) to retrieve a singleton SSHExec instance

SSHExec ssh = SSHExec.getInstance(cb);

// Connect to server

ssh.connect();

CustomTask sampleTask1 = new ExecCommand("echo $SSH_CLIENT"); // Print Your Client IP By which you connected to ssh server on Horton Sandbox

System.out.println(ssh.exec(sampleTask1));

CustomTask sampleTask2 = new ExecCommand("sqoop import --connect jdbc:mysql://192.168.56.101:3316/mysql_db_name --username=mysql_user --password=mysql_pwd --table mysql_table_name --hive-import -m 1 -- --schema default");

ssh.exec(sampleTask2);

ssh.disconnect();

}

}