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