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

["Szymon Miezal (Jira)" <ji...@apache.org>]

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

Szymon Miezal updated CASSANDRA-19118:
--------------------------------------
    Change Category: Operability
         Complexity: Normal
             Status: Open  (was: Triage Needed)

> Add support of vector type to COPY command
> ------------------------------------------
>
>                 Key: CASSANDRA-19118
>                 URL: https://issues.apache.org/jira/browse/CASSANDRA-19118
>             Project: Cassandra
>          Issue Type: Improvement
>          Components: CQL/Interpreter
>            Reporter: Szymon Miezal
>            Assignee: Szymon Miezal
>            Priority: Normal
>
> 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-unsubscribe@cassandra.apache.org
For additional commands, e-mail: commits-help@cassandra.apache.org