[jira] [Commented] (CASSANDRA-19118) Add support of vector type to COPY command

[Jira]

    [ 
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: commits-unsubscr...@cassandra.apache.org
For additional commands, e-mail: commits-h...@cassandra.apache.org