- Command to import query results
sqoop import --connect jdbc:mysql://ms.itversity.com:3306/retail_db --username retail_user --password itversity --query "SELECT order_date, count(1) order_count FROM orders WHERE \$CONDITIONS GROUP BY order_date" --target-dir /user/training/sqoop_import/retail_db/order_count_by_date --sptit-by order—date --delete-target-dir
Durga Gadiraju
186.Sqoop Import – Importing Query Results
- March 16, 2023
- , 9:39 am
- , Uncategorized