title: Unable to export data from Cassandra to MySql
body: <p>We are facing problem while exporting data from Cassandra to MySql database.
  For example,<br>
  1. I have created keyspace called <code>test_ks</code> and column family called <code>test_cf</code> in cassandra using cql.</p>
  
  <p>I have inserted some dummy data into <code>test_cf</code> and corresponding files are created in the folder <code>/var/lib/cassandra/data/test_ks/test_cf</code> as shown below.</p>
  
  <pre><code>[root@balnsand01 test_cf]# pwd
  
  /var/lib/cassandra/data/test_ks/test_cf
  
  [root@balnsand01 test_cf]# ls -lrt
  
  total 24
  
  -rw-r--r-- 1 root root 4340 Sep 19 03:39 test_ks-test_cf-hf-1-Statistics.db
  
  -rw-r--r-- 1 root root 22 Sep 19 03:39 test_ks-test_cf-hf-1-Index.db
  
  -rw-r--r-- 1 root root 16 Sep 19 03:39 test_ks-test_cf-hf-1-Filter.db
  
  -rw-r--r-- 1 root root 89 Sep 19 03:39 test_ks-test_cf-hf-1-Data.db
  
  -rw-r--r-- 1 root root 46 Sep 19 03:39 test_ks-test_cf-hf-1-CompressionInfo.db
  </code></pre>
  
  <ol>
  <li>When i am trying to export this data into MySql using below command, I see data is getting exported in non-readable format. I mean i am not able to see data which i have inserted in cassandra.</li>
  </ol>
  
  <p><code>./dse sqoop export --connect jdbc:mysql://127.0.0.1:3306/testdb --username testuser --password mysql123 --export-dir /var/lib/cassandra/data/test_ks/test_cf --table &lt;table_name&gt; --columns 'col1,col2' --input-fields-terminated-by '\t';</code></p>
  
  <p>where,
  <code>--export-dir /var/lib/cassandra/data/test_ks/test_cf</code> is the path where data files gets created.</p>
  
  <p>Could you please guide me where exactly I am doing wrong here.</p>
  
  <p>Thanks in advance,
  Santosh </p>