sqoop基本使用

#sqoop
解压软件
$ sudo tar -zxvf sqoop-1.4.6.bin__hadoop-0.23.tar.gz -C /usr/local/
$ pwd
/usr/local/sqoop-1.4.6.bin__hadoop-0.23
$ cd conf/
$ sudo cp sqoop-env-template.sh sqoop-env.sh
$ sudo vi sqoop-env.sh
export HADOOP_COMMON_HOME=/usr/local/hadoop-2.7.4/
export HADOOP_MAPRED_HOME=/usr/local/hadoop-2.7.4/
#sqoop 导入Oracle数据库到HDFS中
$ sqoop import --connect jdbc:oracle:thin:@192.168.240.137:1521:orcl --username scott --password tiger --table emp --columns 'empno,ename,job,sal,deptno' -m 1 --target-dir '/sqoop/emp'
#sqoop 导入Oracle到hive中
$ sqoop import --hive-import --connect jdbc:oracle:thin:@192.168.240.137:1521:orcl --username scott --password tiger --table emp -m 1 --columns 'empno,ename,job,sal,deptno' 
#导入Oracle，并指明表名
$ sqoop import --hive-import --connect jdbc:oracle:thin:@192.168.240.137:1521:orcl --username scott --password tiger --table emp -m 1 --columns 'empno,ename,job,sal,deptno' --hive-table emp1
#导入Oracle，指定whare条件
$ sqoop import --hive-import --connect jdbc:oracle:thin:@192.168.240.137:1521:orcl --username scott --password tiger --table emp  -m 1 --columns 'empno,ename,job,sal,deptno' --hive-table emp2 where 'deptno=10'
#导入Oracle，使用select
$ sqoop import --hive-import --connect jdbc:oracle:thin:@192.168.240.137:1521:orcl --username scott --password tiger -m 1 --query 'select * from emp where sal < 1000 and $CONDITIONS' --target-dir '/sqoop/emp3' --hive-table emp3

$ sqoop import --hive-import --connect jdbc:oracle:thin:@192.168.240.137:1521:orcl --username scott --password tiger -m 1 --table myemp --export-dir '/sqoop/emp3'