@Vedant Jain sqoop uses 4 mappers by default. Try running with option -m 1 or any other number to see if it makes the difference. Copying following line from this as it does make sense. Using the "top x" or "limit x" clauses do not make much sense with Sqoop as it can return different values on each query execution (there is no "order by"). Also in addition the clause will very likely confuse split generation, ending with not that easily deterministic outputs. Having said that I would recommend you to use only 1 mapper (-m 1 or --num-mappers 1) in case that you need to import predefined number of rows ... View more