title: sqoop with sql server retrieving more records
body: <p>Q: I want to import 5000 rows from <strong>SQL server using SQOOP</strong> but its giving me 20000 rows. I am using below query.</p>
  
  <pre><code>sudo -E -u hdfs sqoop import --connect "jdbc:sqlserver://hostname;username=*****;password=*****;database=*****" --driver com.microsoft.sqlserver.jdbc.SQLServerDriver --query "select top 5000 * from Tb_Emp  where \$CONDITIONS" --split-by EmpID -m 4 --target-dir /home/sqoop_SQLServeroutput
  </code></pre>
  
  <p>retrieved 20000 records </p>
  
  <p>every mapper is getting 5000 records. but if i do this on <strong>mysql</strong> then it gives 5000 records as expected.</p>
  
  <pre><code>sudo -E -u hdfs sqoop import --connect jdbc:mysql://hostname/&lt;database_name&gt; --username **** --password **** --query 'select * from Tb_Emp where $CONDITIONS limit 5000' --split-by EmpID -m 4 --target-dir /home/sqoop_MySqloutput
  </code></pre>
  
  <p>retrieved 5000 records.</p>
  
  <p>don't why its happening. </p>