183.Sqoop Import – Using “– –boundary-query”

  • Command to retrieve table within specified maximum and minimum boundary value of primary key.
    • sqoop import --connect jdbc:mysql://ms.itversity.com:3306/retail_db --username retail_user --password itversity --table order_items --warehouse-dir /user/training/sqoop_import/retail_db --boundary-query "SELECT 1, 172198" --delete-target-dir

Share this post