[
https://issues.apache.org/jira/browse/CASSANDRA-15679?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Erick Ramirez updated CASSANDRA-15679:
--------------------------------------
Description:
h2. Background
A user was having issues loading CSV data with the {{COPY FROM}} command into a
{{map}} column with {{blob}} values.
h2. Replication steps
I can easily replicate the problem with this simple table:
{noformat}
CREATE TABLE community.blobmaptable (
id text PRIMARY KEY,
blobmapcol map<int, blob>
)
{noformat}
I have this CSV file that contains just 1 row:
{noformat}
$ cat blobmap.csv
c3,{3: 0x74776f}
{noformat}
And here's the error when I try to load it:
{noformat}
cqlsh:community> COPY blobmaptable (id, blobmapcol) FROM '~/blobmap.csv' ;
Using 1 child processes
Starting copy of community.blobmaptable with columns [id, blobmapcol].
Failed to import 1 rows: ParseError - Failed to parse {3: 0x74776f} :
unhashable type: 'bytearray', given up without retries
Failed to process 1 rows; failed rows written to
import_community_blobmaptable.err
Processed: 1 rows; Rate: 2 rows/s; Avg. rate: 3 rows/s
1 rows imported from 1 files in 0.389 seconds (0 skipped).
{noformat}
I've also logged
[PYTHON-1234|https://datastax-oss.atlassian.net/browse/PYTHON-1234] because I
wasn't sure if it was a Python driver issue. Cheers!
was:
h2. Background
A user was having issues loading CSV data with the {{COPY FROM}} command into a
{{map}} column with {{blob}} values.
h2. Replication steps
I can easily replicate the problem with this simple table:
{noformat}
CREATE TABLE community.blobmaptable (
id text PRIMARY KEY,
blobmapcol map<int, blob>
)
{noformat}
I have this CSV file that contains just 1 row:
{noformat}
$ cat blobmap.csv
c3,{3: 0x74776f}
{noformat}
And here's the error when I try to load it:
{noformat}
cqlsh:community> COPY blobmaptable (id, blobmapcol) FROM '~/blobmap.csv' ;
Using 1 child processes
Starting copy of community.blobmaptable with columns [id, blobmapcol].
Failed to import 1 rows: ParseError - Failed to parse {3: 0x74776f} :
unhashable type: 'bytearray', given up without retries
Failed to process 1 rows; failed rows written to
import_community_blobmaptable.err
Processed: 1 rows; Rate: 2 rows/s; Avg. rate: 3 rows/s
1 rows imported from 1 files in 0.389 seconds (0 skipped).
{noformat}
I've also logged
[PYTHON-1234|https://datastax-oss.atlassian.net/browse/PYTHON-1234] because I
wasn't sure if it was a Python driver issue. Cheers!
> cqlsh COPY FROM of map of blobs fails with parse error "unhashable type:
> 'bytearray'"
> -------------------------------------------------------------------------------------
>
> Key: CASSANDRA-15679
> URL: https://issues.apache.org/jira/browse/CASSANDRA-15679
> Project: Cassandra
> Issue Type: Bug
> Components: Tool/cqlsh
> Reporter: Erick Ramirez
> Priority: Normal
>
> h2. Background
> A user was having issues loading CSV data with the {{COPY FROM}} command into
> a {{map}} column with {{blob}} values.
> h2. Replication steps
> I can easily replicate the problem with this simple table:
> {noformat}
> CREATE TABLE community.blobmaptable (
> id text PRIMARY KEY,
> blobmapcol map<int, blob>
> )
> {noformat}
> I have this CSV file that contains just 1 row:
> {noformat}
> $ cat blobmap.csv
> c3,{3: 0x74776f}
> {noformat}
> And here's the error when I try to load it:
> {noformat}
> cqlsh:community> COPY blobmaptable (id, blobmapcol) FROM '~/blobmap.csv' ;
> Using 1 child processes
> Starting copy of community.blobmaptable with columns [id, blobmapcol].
> Failed to import 1 rows: ParseError - Failed to parse {3: 0x74776f} :
> unhashable type: 'bytearray', given up without retries
> Failed to process 1 rows; failed rows written to
> import_community_blobmaptable.err
> Processed: 1 rows; Rate: 2 rows/s; Avg. rate: 3 rows/s
> 1 rows imported from 1 files in 0.389 seconds (0 skipped).
> {noformat}
> I've also logged
> [PYTHON-1234|https://datastax-oss.atlassian.net/browse/PYTHON-1234] because I
> wasn't sure if it was a Python driver issue. Cheers!
--
This message was sent by Atlassian Jira
(v8.3.4#803005)
---------------------------------------------------------------------
To unsubscribe, e-mail: commits-unsubscr...@cassandra.apache.org
For additional commands, e-mail: commits-h...@cassandra.apache.org
