Hey Santosh, Unfortunately, Sqoop does not officially support Cassandra. I'm not sure what version/distribution of Sqoop you are using, but I would refer to their support for help in this issue.
-Abe On Mon, Sep 23, 2013 at 4:36 AM, Santosh Shet <[email protected]> wrote: > 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 > >
