[jira] [Updated] (CASSANDRA-16823) Unable to successfully export and Import data in cassandra

["Brandon Williams (Jira)" <ji...@apache.org>]

     [ https://issues.apache.org/jira/browse/CASSANDRA-16823?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

Brandon Williams updated CASSANDRA-16823:
-----------------------------------------
    Resolution: Invalid
        Status: Resolved  (was: Triage Needed)

This jira is for development of Cassandra, for assistance, contacting the community via slack or the ML will suit you better: https://cassandra.apache.org/_/community.html

> Unable to successfully export and Import data in cassandra 
> -----------------------------------------------------------
>
>                 Key: CASSANDRA-16823
>                 URL: https://issues.apache.org/jira/browse/CASSANDRA-16823
>             Project: Cassandra
>          Issue Type: Bug
>            Reporter: Ramakrishna
>            Priority: Normal
>
> I have a table in a cassandra server, and that is hosted somewhere. I exported the data from that cassandra instance into a CSV file, using following commands 
>  
> cqlsh> capture '~/state_bkp.csv' Now capturing query output to u'/home/ramu /state_bkp.csv'. cqlsh> SELECT * FROM "<<keyspace>>"."<<table>>" WHERE ("systemId" = '2MT931A92K'); cqlsh> capture off
>  
> The select query has one VARCHAR column and 4 BLOB columns.
>  
> This creates a massive file of 22.4 MB.  
>  
> Now I am importing this file into cassandra of my localhost.
>  
> COPY <<keyspace>>.<<table>> FROM '/home/ramu/state_bkp.csv' WITH DELIMITER='|' AND HEADER=TRUE;
>  
>  
> This however fails to insert data into the destination table. It fails with an error.
>  
>  
> `non-hexadecimal number found in fromhex() arg at position 0, given up without retries
> Failed to process 5 rows; failed rows written to` import_<<keyspace>>.<<table>>.err
>  
> This happens to every query that I want to export on this table.
>  
>  
>  
>  



--
This message was sent by Atlassian Jira
(v8.3.4#803005)

---------------------------------------------------------------------
To unsubscribe, e-mail: commits-unsubscribe@cassandra.apache.org
For additional commands, e-mail: commits-help@cassandra.apache.org