sqoop 操作

 

Oracle抽取到hdfs

 

sqoop import --connect jdbc:oracle:thin:@192.168.3.1:1521:test --username test --P --table TEST.TEST --columns ID,NAME --fields-terminated-by '#' --target-dir /test/test.txt -m 1