Szymon Miezal created CASSANDRA-19118:
-----------------------------------------

             Summary: 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


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

Reply via email to