Ramakrishna created CASSANDRA-16823:
---------------------------------------
Summary: 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
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: [email protected]
For additional commands, e-mail: [email protected]
