incubator-cassandra-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Santosh Shet <santosh.s...@vista-one-solutions.com>
Subject Unable to export data from Cassandra to MySql
Date Tue, 24 Sep 2013 09:09:33 GMT
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


Mime
View raw message