title: Unable to import data from MySql using Sqoop with different delimiter
body: <p>As a beginner in Hadoop field, i was trying my hands on Sqoop tool (<strong>Version</strong> : Sqoop 1.4.6-cdh5.8.0).</p>
  
  <p>Though i referred to various sites and forums but i could not get workable solution where in i could import data using any other delimiter other than <code>,</code>.</p>
  
  <p><strong>PFB the code that i have used</strong> :</p>
  
  <p>--- Connecting to MySql, creating table and records with <code>,</code> in string.</p>
  
  <pre><code>mysql&gt; create database GRHadoop;
  Query OK, 1 row affected (0.00 sec)
  
  mysql&gt; use GRHadoop;
  Database changed
  mysql&gt; Create table sitecustomer(Customerid int(10), Customername varchar(100),Productid int(4),Salary int(20));
  Query OK, 0 rows affected (0.22 sec)
  
  mysql&gt; Insert into sitecustomer values(1,'Sohail',100,50000),(2,'Reshma',200,80000),(3,'Tom',200,60000);
  Query OK, 3 rows affected (0.06 sec)
  Records: 3  Duplicates: 0  Warnings: 0
  
  mysql&gt; Insert into sitecustomer values(4,'Su,kama',300,50000),(5,'Ram,bha',100,80000),(6,'Suz',200,60000);
  Query OK, 3 rows affected (0.03 sec)
  Records: 3  Duplicates: 0  Warnings: 0
  </code></pre>
  
  <p><strong>Sqoop Command :</strong> </p>
  
  <pre><code>sqoop import \
  --connect jdbc:mysql://127.0.0.1:3306/GRHadoop \
  --username root \
  --password cloudera \
  --table sitecustomer \
  --input-fields-terminated-by '|' \
  --lines-terminated-by "\n" \
  --target-dir /user/cloudera/GR/Sqoop/sitecustomer_data \
  --m 1;
  </code></pre>
  
  <p><strong>Expected Output :</strong> </p>
  
  <pre><code>1|Sohail|100|50000
  
  2|Reshma|200|80000
  
  3|Tom|200|60000
  
  4|Su,kama|300|50000
  
  5|Ram,bha|100|80000
  
  6|Suz|200|60000
  </code></pre>
  
  <p><strong>Actual output :</strong> </p>
  
  <pre><code>1,Sohail,100,50000
  
  2,Reshma,200,80000
  
  3,Tom,200,60000
  
  4,Su,kama,300,50000
  
  5,Ram,bha,100,80000
  
  6,Suz,200,60000
  </code></pre>
  
  <p>Please guide where i am getting it wrong.</p>