Sqoop Doubt

[#1]

I want to run two reducer in Sqoop? What is the query used in Sqoop to achieve this?

[#2]

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,