sqoop-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Santosh Shet <santus...@gmail.com>
Subject Unable to export data from Cassandra to MySql
Date Mon, 23 Sep 2013 11:36:10 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_cfin 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


   1. 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.

./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

Mime
View raw message