title: How to use sqoop to export the default hive delimited output?
body: <p>I have a hive query:</p>
  
  <pre><code>insert override directory /x
  select ...
  </code></pre>
  
  <p>Then I'm try to export the data with sqoop </p>
  
  <pre><code>sqoop export --connect jdbc:mysql://mysqlm/site --username site --password site --table x_data --export-dir /x  --input-fields-terminated-by 0x01 --lines-terminated-by '\n'
  </code></pre>
  
  <p>But this seems to fail to parse the fields according to delimiter
  What am I missing?
  I think the <strong>--input-fields-terminated-by 0x01</strong> part doesn't work as expected?</p>
  
  <p>I do not want to create additional tables in hive that contains the query results.</p>
  
  <p>stack trace:</p>
  
  <pre><code> 2013-09-24 05:39:21,705 ERROR org.apache.sqoop.mapreduce.TextExportMapper: Exception: 
   java.lang.NumberFormatException: For input string: "9-2"
      at java.lang.NumberFormatException.forInputString(NumberFormatException.java:48)
      at java.lang.Integer.parseInt(Integer.java:458)
   ...
  </code></pre>
  
  <p>The vi view of output </p>
  
  <pre><code>16-09-2013 23^A1182^A-1^APub_X^A21782^AIT^A1^A0^A0^A0^A0^A0.0^A0.0^A0.0
  16-09-2013 23^A1182^A6975^ASoMo Audience  Corp^A2336143^AUS^A1^A1^A0^A0^A0^A0.2^A0.0^A0.0
  16-09-2013 23^A1183^A-1^APub_UK, Inc.^A1564001^AGB^A1^A0^A0^A0^A0^A0.0^A0.0^A0.0
  17-09-2013 00^A1120^A-1^APub_US^A911^A--^A181^A0^A0^A0^A0^A0.0^A0.0^A0.0
  </code></pre>