I want to run two reducer in Sqoop? What is the query used in Sqoop to achieve this?
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,