LieBrother

在MySQL中创建表CREATE TABLE `tree1` ( `id` int(11) NOT NULL AUTO_INCREMENT, `treeNumber` varchar(100) NOT NULL, `productinformationId` int(11) NOT NULL, PRIMARY KEY (`id`)) DEFAULT CHARSET=utf8;执行命

将数据库phx中的tree表的数据导入到Hive中命令：sqoop import --connect jdbc:mysql://node1:3306/phx \--username root \--table tree \--hive-import \--hive-overwrite \--create-hive-table \--hive-table tree1 \--target-dir /sq

从MySQL数据库phx中读取tree表到HDFS执行命令：sqoop import --connect jdbc:mysql://node1:3306/phx \--username root --table tree --m 1命令行输出：Warning: /csh/link/sqoop/../hcatalog does not exist! HCatalog jobs will fail.P

下载sqoop-1.4.6 安装包配置sqoop-env.sh#Set path to where bin/hadoop is available 配置Hadoopexport HADOOP_COMMON_HOME=/csh/link/hadoop#Set path to where hadoop-*-core.jar is availableexport HADOOP_MAPRED_HOME