Home | About | Sematext search-lucene.com search-hadoop.com
 Search Hadoop and all its subprojects:

Switch to Threaded View
Sqoop >> mail # user >> Unable to export data from Cassandra to MySql


Copy link to this message
-
Re: Unable to export data from Cassandra to MySql
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
>
>