Unable to export data from Cassandra to MySql

[Santosh Shet <sa...@vista-one-solutions.com>]

Hi,
We are facing problem while exporting data from Cassandra to MySql database. For example,

1. I have created keyspace called test_ks and column family called test_cf in cassandra using cql.
I have inserted some dummy data into test_cf and corresponding files are created in the folder /var/lib/cassandra/data/test_ks/test_cf as shown below.
[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
2.When i am trying to export this data into MySql using below command, I see data is getting exported in non-readable format which is not correct. Below is the command I am using to export
./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 <table_name> --columns 'col1,col2' --input-fields-terminated-by '\t';
where, --export-dir /var/lib/cassandra/data/test_ks/test_cf is the path where data files gets created.
Could you please guide me where exactly I am doing wrong here.
Thanks in advance,
Santosh


Santosh Shet
Software Engineer | VistaOne Solutions
Direct India : +91 80 30273829 | Mobile India : +91 8105720582
Skype : santushet