04-25-2019 10:58 PM - edited 04-25-2019 10:59 PM
As per sqoop user guide, it imports data in parallel form. You can specify the number of mappers by --num-mappers or -m, by the default value of this arg is four. So in your case, you can use it like
sqoop import --connect <<>> --username <<>> --password <<>> --query 'Select * from orders WHERE $CONDITIONS' --num-mappers 2 --target-dir 'marwaadihu_orders/'
Do not forget to mark the answer as correct if it is the one which you want..!
Thanks & Regards,