[
https://issues.apache.org/jira/browse/CASSANDRA-19118?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17808805#comment-17808805
]
Andres de la Peña commented on CASSANDRA-19118:
-----------------------------------------------
Here we go:
||PR||CI||
|[5.0
|https://github.com/apache/cassandra/pull/2957]|[j11|https://app.circleci.com/pipelines/github/adelapena/cassandra/3396/workflows/e4ad19c1-bb39-4d9b-b953-f2faa6727549]
[j17|https://app.circleci.com/pipelines/github/adelapena/cassandra/3396/workflows/fb84db84-5497-4a6c-bfd1-4e1969e4a77c]|
|[trunk|https://github.com/apache/cassandra/pull/3056]|[j11|https://app.circleci.com/pipelines/github/adelapena/cassandra/3397/workflows/1eecda78-4da8-4804-ada8-283521ef9866]
[j17|https://app.circleci.com/pipelines/github/adelapena/cassandra/3397/workflows/2d0b5c05-f9fe-422b-8927-0edfb94b9703]|
> Add support of vector type to COPY command
> ------------------------------------------
>
> Key: CASSANDRA-19118
> URL: https://issues.apache.org/jira/browse/CASSANDRA-19118
> Project: Cassandra
> Issue Type: Bug
> Components: Tool/cqlsh
> Reporter: Szymon Miezal
> Assignee: Szymon Miezal
> Priority: Normal
> Fix For: 5.0-rc, 5.x
>
> Time Spent: 9h 50m
> Remaining Estimate: 0h
>
> Currently it's not possible to import rows with vector literals via {{COPY}}
> command.
> STR:
> * Create a table
> {code:sql}
> CREATE TABLE testcopyfrom (id text PRIMARY KEY, embedding_vector
> VECTOR<FLOAT, 6>
> {code}
> * Prepare csv file with sample data, for instance:
> {code:sql}
> 1,"[0.1, 0.2, 0.3, 0.4, 0.5, 0.6]"
> 2,"[-0.1, -0.2, -0.3, -0.4, -0.5, -0.6]" {code}
> * in cqlsh run
> {code:sql}
> COPY ks.testcopyfrom FROM data.csv
> {code}
> It will result in getting:
> {code:sql}
> TypeError: Received an argument of invalid type for column
> "embedding_vector". Expected: <class 'cassandra.cqltypes.VectorType(6)'>,
> Got: <class 'str'>; (required argument is not a float){code}
--
This message was sent by Atlassian Jira
(v8.20.10#820010)
---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]
