https://community.cloudera.com/t5/Support-Questions/Sqoop-in-HDP-3-0-to-pull-data-from-MySQL-Workbench/m-p/278756#M208215 <P>You need to install sqoop in your cluster. So the import sqoop provides the tool to import data from you DB to HDFS. Please make sure you have the MySQL JDBC driver setup in the cluster so it can be used with sqoop.</P><P>&nbsp;</P><LI-CODE lang="markup">sqoop import \ --connect jdbc:mysql://mysql.database_name/schema_database \ --username sqoopuser \ --password sqooppwd \ --table cities </LI-CODE><P>&nbsp;</P><P>&nbsp;</P><P>&nbsp;</P><LI-CODE lang="markup">sqoop import \ --connect jdbc:mysql://mysql_localhost/schema_database \ --username sqoopuser \ --password-file /home/sqoop/sqoop.password \ --table cities \ --as-avrodatafile \ --target-dir /etl/input/cities-avro </LI-CODE><P>&nbsp;</P><P>&nbsp;</P> Thu, 03 Oct 2019 12:43:24 GMT kwabstian53 2019-10-03T12:43:24Z