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
Thank you Santosh!
On Tue, Sep 24, 2013 at 3:18 AM, Santosh Shet <[EMAIL PROTECTED]> wrote:

> Hello Abraham,
>
> Thank you very much for the response. I am using sqoop and hadoop which
> are available along with datastax enterprise framework.
> sqoop version :1.4.2.1.
> Hadoop version :Hadoop 1.0.4.2
> I have already sent mail to cassandra team asking for the help.
>
> Thanks and regards,
>
> Santosh
>
>
> On Mon, Sep 23, 2013 at 11:14 PM, Abraham Elmahrek <[EMAIL PROTECTED]>wrote:
>
>> 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_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
>>>
>>>
>>>    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