New Contributor
Posts: 4
Registered: ‎04-23-2019

Sqoop Doubt

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

New Contributor
Posts: 2
Registered: ‎02-18-2019

Re: Sqoop Doubt

[ Edited ]

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,