[jira] [Commented] (CASSANDRA-19118) Add support of vector type to COPY command
[
https://issues.apache.org/jira/browse/CASSANDRA-19118?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17809480#comment-17809480
]
Andres de la Peña commented on CASSANDRA-19118:
---
Committed to {{cassandra-5.0}} as
[c76b32492f08c4af56846518488ae0b191e077e8|https://github.com/apache/cassandra/commit/c76b32492f08c4af56846518488ae0b191e077e8]
and merged to
[{{trunk}}|https://github.com/apache/cassandra/commit/1e44a0850b8589e5dce3d9750f2c11add713d3f8].
Thanks for the patch and reviews.
> 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
> {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: ,
> Got: ; (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
[jira] [Commented] (CASSANDRA-19118) Add support of vector type to COPY command
[
https://issues.apache.org/jira/browse/CASSANDRA-19118?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17809397#comment-17809397
]
Andres de la Peña commented on CASSANDRA-19118:
---
CI results look good to me:
* {{AlterTest.testAlterStatementWithAdd}} has been recently hit by
CASSANDRA-19245
* {{AlterTest.testDropListAndAddListWithSameName}} is CASSANDRA-18360
* {{coordinatorIsBehindTest}} is a timeout
* {{testOptionalMtlsModeDoNotAllowNonSSLConnections}} is a timeout
* {{test_move_single_node_localhost}} is on Butler
* {{HarrySimulatorTest}} is on Butler
[~smiklosovic] [~maxwellguo] if you don't have anything else to add I'll commit
the changes.
> 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
> {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: ,
> Got: ; (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
[jira] [Commented] (CASSANDRA-19118) Add support of vector type to COPY command
[
https://issues.apache.org/jira/browse/CASSANDRA-19118?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=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
> {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: ,
> Got: ; (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
[jira] [Commented] (CASSANDRA-19118) Add support of vector type to COPY command
[
https://issues.apache.org/jira/browse/CASSANDRA-19118?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17808755#comment-17808755
]
Andres de la Peña commented on CASSANDRA-19118:
---
[~szymon.miezal] I have just committed CASSANDRA-19245.
I'll run CI once the 5.0/trunk patches are rebased.
> 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 40m
> 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
> {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: ,
> Got: ; (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
[jira] [Commented] (CASSANDRA-19118) Add support of vector type to COPY command
[
https://issues.apache.org/jira/browse/CASSANDRA-19118?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17801780#comment-17801780
]
Andres de la Peña commented on CASSANDRA-19118:
---
I can't figure out what the purpose of that test branch is. In the meantime,
Python driver 3.29.0 has been released. I have opened CASSANDRA-19245 to use
that driver version, and I'm also updating pylib requirements in that ticket to
use the same driver version.
> 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 40m
> 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
> {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: ,
> Got: ; (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
[jira] [Commented] (CASSANDRA-19118) Add support of vector type to COPY command
[
https://issues.apache.org/jira/browse/CASSANDRA-19118?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17799798#comment-17799798
]
Szymon Miezal commented on CASSANDRA-19118:
---
It indeed seems like the cqlsh tests mimic the approach started by ccm, at this
point I don't see any particular reason to follow that approach further.
My gut feeling is that it's a temporary solution that turned out to live much
longer until someone encountered a problem with it - which happened now.
> 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 40m
> 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
> {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: ,
> Got: ; (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
[jira] [Commented] (CASSANDRA-19118) Add support of vector type to COPY command
[
https://issues.apache.org/jira/browse/CASSANDRA-19118?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17799569#comment-17799569
]
Ekaterina Dimitrova commented on CASSANDRA-19118:
-
FYI, I just noticed that we are using also cassandra-test for the Python
DTests. git blame shows:
{code:java}
commit cb42c1a8d563ffd5cfab5d5c0ba3690d337958a3
install driver & ccm as editable eggs
{code}
No ticket was mentioned. And it seems in Cassandra; this was just mimicked for
the cqlsh tests in CASSANDRA-14951.
[~djoshi] and Ariel Weisberg , do you have any idea as to why this is used? (I
saw you worked on CASSANDRA-14951, so just checking in case you know more)
> 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 40m
> 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
> {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: ,
> Got: ; (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
[jira] [Commented] (CASSANDRA-19118) Add support of vector type to COPY command
[
https://issues.apache.org/jira/browse/CASSANDRA-19118?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17799555#comment-17799555
]
Andres de la Peña commented on CASSANDRA-19118:
---
Here are CI runs using [this
commit|https://github.com/apache/cassandra/pull/2957/commits/1ef9228bd317fb91320053d9904c57864f8a71cd]
to use Python driver 3.28.0 with pylib tests:
||Branch||CI||
|5.0|[j11|https://app.circleci.com/pipelines/github/adelapena/cassandra/3362/workflows/e047f048-a3da-454f-bd2d-469ebaa3f387]
[j17|https://app.circleci.com/pipelines/github/adelapena/cassandra/3362/workflows/dc768eff-7829-4c18-830a-b63a7fba9edd]|
|trunk|[j11|https://app.circleci.com/pipelines/github/adelapena/cassandra/3361/workflows/445e2d73-5553-43b5-a316-9d8686d8b907]
[j17|https://app.circleci.com/pipelines/github/adelapena/cassandra/3361/workflows/38929172-b4b0-4db5-bcf4-60ad9d6c836d]|
Not sure if we should have a separate ticket to upgrade the driver version. I'm
also unsure why that was using a "cassandra-test" branch instead of just a
specific driver version.
> 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 40m
> 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
> {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: ,
> Got: ; (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
