title: Export HDFS file with custom delimiter into Mysql via Sqoop
body: <ul>
  <li><p>I have file like this:</p>
  
  <pre><code>1^%~binod^*~1^%~ritesh^*~1^%~shisir^*~1^%~budhdha^*~1^%~romika^*~1^%~rubeena^*~
  </code></pre></li>
  <li><p>Where --input-fields-terminated-by '^%~' --input-lines-terminated-by '^*~'.</p></li>
  <li><p>I tried to export via command:</p>
  
  <pre><code>sqoop export --connect jdbc:mysql://localhost/sqoop --username root -P --table makalu --export-dir sqoop/makalu --input-fields-terminated-by '^%~' --input-lines-terminated-by '^*~'
  </code></pre></li>
  <li><p>But it writes a single line of:</p></li>
  </ul>
  
  <pre>
  id|name
  1|%~binod
  </pre>
  
  <p>in MySQL.</p>
  
  <ul>
  <li>Now my question is what would be the command to solve this scenario.</li>
  </ul>