1.设置环境变量
#set Environment
export JAVA_HOME=/usr/java/jdk1.7.0_45
export HADOOP_INSTALL=/home/luffy/Development/hadoop-1.2.1
export HADOOP_COMMON_HOME=$HADOOP_INSTALL
export HADOOP_MAPRED_HOME=$HADOOP_INSTALL
export SQOOP_HOME=/home/luffy/Development/sqoop-1.4.4.bin__hadoop-1.0.0
export CLASSPATH=.:$JAVA_HOME/lib/dt.jar:$JAVA_HOME/lib/tools.jar:$CLASSPATH
export PATH=$JAVA_HOME/bin:$JAVA_HOME/jre/bin:$HADOOP_INSTALL/bin:$SQOOP_HOME/bin:$PATH
2.将sqljdbc4.jar拖放到”sqoop-1.4.4.bin__hadoop-1.0.0/lib/"目录下
3.启动hadoop
start-all.sh
4.执行命令
sqoop import --connect 'jdbc:sqlserver://192.168.10.164:1433;username=sa;password=12345678;database=demo'
--table=TAB_USER
--target-dir TabUser