Spark Databox

sqoop eval --connect "jdbc:mysql://nn01.itversity.com:3306/retail_export" --username retail_dba --password itversity --query "select o.order_status,o.order_date from retail_db.orders o"

sqoop import --connect "jdbc:mysql://nn01.itversity.com:3306/retail_db" --username retail_dba --password itversity --table orders --target-dir '/user/sparkdatabox/sqoop';

sqoop import \

--connect jdbc:mysql://nn01.itversity.com:3306/retail_db \

--username retail_dba \

--password itversity \

--table orders \

--hive-import \

--hive-database sparkdatabox