Effective Sqoop: Best Practices, Pitfalls and Lessons2. Ten Best Practices 1. It pays to use formatting arguments. 2. With the power of parallelism comes great responsibility! 3. Use direct connectors for fast prototyping and performance. 4. Use a boundary query for better performance. 5. Do not use the same table for import and export. 6. Use an options file for reusability. 7. Use the proper file format for your needs. 8. Prefer batch mode when ex
