Home | About | Sematext search-lucene.com search-hadoop.com
NEW: Monitor These Apps!
elasticsearch, apache solr, apache hbase, hadoop, redis, casssandra, amazon cloudwatch, mysql, memcached, apache kafka, apache zookeeper, apache storm, ubuntu, centOS, red hat, debian, puppet labs, java, senseiDB
 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
>
>
NEW: Monitor These Apps!
elasticsearch, apache solr, apache hbase, hadoop, redis, casssandra, amazon cloudwatch, mysql, memcached, apache kafka, apache zookeeper, apache storm, ubuntu, centOS, red hat, debian, puppet labs, java, senseiDB