sqoop 1.4.7 导入hive

sqoop import --driver com.microsoft.sqlserver.jdbc.SQLServerDriver --connect "jdbc:sqlserver://192.168.10.128:1433;database=kylin" \
             --username user01 --password #### --table=sqoop_test \
             --hive-import --target-dir temp -m 1 --hive-overwrite --hive-database db1

sqoop2暂时不支持导入到hive

sqoop1.4.7导入

 

ll /opt
/opt/hadoop-2.7.3/sbin/start-all.sh
#sqoop2要求
/opt/hadoop-2.7.3/sbin/mr-jobhistory-daemon.sh start historyserver
#注意在mdw dw1 dw2上运行zkServer.sh start
/opt/zookeeper-3.4.13/bin/zkServer.sh start
/opt/hbase-1.4.6/bin/start-hbase.sh
/opt/apache-hive-2.3.3/bin/hiveserver2 &
/opt/spark-2.3.1-bin-hadoop2.7/sbin/start-all.sh
#/opt/sqoop-1.99.7/bin/sqoop2-server start

export CASSANDRA_HOME=/home/cassandra/apache-cassandra-3.11.3
export JAVA_HOME=/usr/lib/jvm/jdk1.8.0_171
export MAVEN_HOME=/root/software/apache-maven-3.5.4
export GP_HOME=/opt/greenplum/greenplum-db
export CLASSPATH=.:$JAVA_HOME/jre/lib/rt.jar:$JAVA_HOME/lib/dt.jar:$JAVA_HOME/lib/tools.jar
export SCALA_HOME=/usr/share/scala
export SCALA_HOME=/usr/share/scala
export PATH=$SCALA_HOME/bin:$PATH
export HADOOP_HOME=/opt/hadoop-2.7.3
export PATH=$PATH:$HADOOP_HOME/bin
export PATH=$PATH:$HADOOP_HOME/sbin
export HADOOP_MAPRED_HOME=$HADOOP_HOME
export HADOOP_COMMON_HOME=$HADOOP_HOME
export HADOOP_HDFS_HOME=$HADOOP_HOME
export YARN_HOME=$HADOOP_HOME
export HADOOP_ROOT_LOGGER=INFO,console
export HADOOP_COMMON_LIB_NATIVE_DIR=$HADOOP_HOME/lib/native
export HADOOP_OPTS="-Djava.library.path=$HADOOP_HOME/lib"
export SPARK_HOME=/opt/spark-2.3.1-bin-hadoop2.7
export PATH=$PATH:$SPARK_HOME/bin
export HIVE_HOME=/opt/apache-hive-2.3.3
export HIVE_CONF_DIR=$HIVE_HOME/conf
export CLASSPATH=.:${HADOOP_HOME}/lib/native
export ZOOKEEPER_HOME=/opt/zookeeper-3.4.13
# export SQOOP_HOME=/opt/sqoop-1.99.7
export SQOOP_HOME=/opt/sqoop-1.4.7.bin__hadoop-2.6.0
# export SQOOP_SERVER_EXTRA_LIB=/opt/sqoop-1.99.7/extra
export PATH=${HIVE_HOME}/bin:${MAVEN_HOME}/bin:$SQOOP_HOME/bin:$ZOOKEEPER_HOME/bin:$PATH:$SCALA_HOME/bin:$JAVA_HOME/bin:$GP_HOME/bin:${CASSANDRA_HOME}/bin