# 查看命令幫助
[hadoop@hadoop ~]$ sqoop help
20/06/06 18:07:14 INFO sqoop.Sqoop: Running Sqoop version: 1.4.6-cdh5.16.2
usage: sqoop COMMAND [ARGS]
Available commands:
? codegen? ? ? ? ? ? Generate code to interact with database records
? create-hive-table? Import a table definition into Hive
? eval? ? ? ? ? ? ? Evaluate a SQL statement and display the results
? export? ? ? ? ? ? Export an HDFS directory to a database table
? help? ? ? ? ? ? ? List available commands
? import? ? ? ? ? ? Import a table from a database to HDFS
? import-all-tables? Import tables from a database to HDFS
? import-mainframe? Import datasets from a mainframe server to HDFS
? job? ? ? ? ? ? ? ? Work with saved jobs
? list-databases? ? List available databases on a server
? list-tables? ? ? ? List available tables in a database
? merge? ? ? ? ? ? ? Merge results of incremental imports
? metastore? ? ? ? ? Run a standalone Sqoop metastore
? version? ? ? ? ? ? Display version information
See 'sqoop help COMMAND' for information on a specific command.
# 查看命令的參數(shù)
[hadoop@hadoop ~]$ sqoop help list-databases
#使用sqoop獲取數(shù)據(jù)庫的列表
[hadoop@hadoop ~]$ sqoop list-databases \
> --connect jdbc:mysql://192.168.228.128:3306 \
> --username root \
> --password root
20/06/06 18:51:16 INFO sqoop.Sqoop: Running Sqoop version: 1.4.6-cdh5.16.2
20/06/06 18:51:16 WARN tool.BaseSqoopTool: Setting your password on the command-line is insecure. Consider using -P instead.
20/06/06 18:51:16 INFO manager.MySQLManager: Preparing to use a MySQL streaming resultset.
Sat Jun 06 18:51:17 CST 2020 WARN: Establishing SSL connection without server's identity verification is not recommended. According to MySQL 5.5.45+, 5.6.26+ and 5.7.6+ requirements SSL connection must be established by default if explicit option isn't set. For compliance with existing applications not using SSL the verifyServerCertificate property is set to 'false'. You need either to explicitly disable SSL by setting useSSL=false, or set useSSL=true and provide truststore for server certificate verification.
information_schema
mysql
performance_schema
sys
# 使用sqoop導(dǎo)數(shù)據(jù)到hadoop
[hadoop@hadoop ~]$ sqoop import \
> --connect jdbc:mysql://192.168.228.128:3306/ruozedata \
> --username root \
> --password root \
> --table sqoop_test
出現(xiàn)如下錯(cuò)誤，很明顯，就是缺少jar包，參考https://community.cloudera.com/t5/Support-Questions/Sqoop-import-exception-java-lang-NoClassDefFoundError-org/td-p/50758，下載到對(duì)應(yīng)的jar包放入$SQOOP_HOME/lib下即可
