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