CQL error in base_table.py line 327

[I22Scode]

Hi I could not get a vector store created in Cassandra (running locally in docker) The keyspace exists and I have other tables in the Cassandra cluster.

The exception repored is cassandra.protocol.SyntaxException: <Error from server: code=2000 [Syntax error in CQL query] message="line 1:110 mismatched input '<' expecting ')' (..., body_blob TEXT, vector VECTOR[<]...)">

The stack trace is:

File "C:\Users\Jerome\Code\ML-studies.venv\Lib\site-packages\langchain_community\vectorstores\cassandra.py", line 121, in init self.table = MetadataVectorCassandraTable( ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^ File "C:\Users\Jerome\Code\ML-studies.venv\Lib\site-packages\cassio\table\mixins.py", line 720, in init super().init(*pargs, new_kwargs) File "C:\Users\Jerome\Code\ML-studies.venv\Lib\site-packages\cassio\table\mixins.py", line 195, in init super().init(*pargs, *kwargs) File "C:\Users\Jerome\Code\ML-studies.venv\Lib\site-packages\cassio\table\mixins.py", line 490, in init super().init(pargs, kwargs) File "C:\Users\Jerome\Code\ML-studies.venv\Lib\site-packages\cassio\table\base_table.py", line 44, in init self.db_setup() File "C:\Users\Jerome\Code\ML-studies.venv\Lib\site-packages\cassio\table\mixins.py", line 246, in db_setup super().db_setup() File "C:\Users\Jerome\Code\ML-studies.venv\Lib\site-packages\cassio\table\mixins.py", line 498, in db_setup super().db_setup() File "C:\Users\Jerome\Code\ML-studies.venv\Lib\site-packages\cassio\table\base_table.py", line 289, in db_setup self.execute_cql(create_table_cql, op_type=CQLOpType.SCHEMA) File "C:\Users\Jerome\Code\ML-studies.venv\Lib\site-packages\cassio\table\base_table.py", line 327, in execute_cql return cast(Iterable[RowType], self.session.execute(statement, args)) ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^

The CQL statement has VECTOR<str as part of the column definition and it looks to be a wrong syntax.

Thank you

[liamka]

already solve this? @I22Scode

[hemidactylus]

Hello @I22Scode could you please check your Cassandra version? The VECTOR<float, N> syntax comes with Cassandra 5, perhaps this is the issue?

CassIO's CI runs against the "cassandra:5" Docker image, and as part of the CI integration testing statements such as the CREATE TABLE that is making your database angry are run several times.