Skip to content

CrateDB does not understand CREATE INDEX #191

@amotl

Description

@amotl

Problem

When a model includes a column definition like this,

idx = Column(Integer, index=True)

the CrateDB SQLAlchemy dialect trips.

E               sqlalchemy.exc.ProgrammingError: (crate.client.exceptions.ProgrammingError) SQLParseException[line 1:8: no viable alternative at input 'CREATE INDEX']
E               [SQL: CREATE INDEX ix_full_md5_llm_cache_llm ON full_md5_llm_cache (llm)]
E               (Background on this error at: https://sqlalche.me/e/20/f405)

../../../.venv/lib/python3.12/site-packages/crate/client/http.py:238: ProgrammingError

Metadata

Metadata

Assignees

No one assigned

    Labels

    No labels
    No labels

    Type

    No type
    No fields configured for issues without a type.

    Projects

    No projects

    Milestone

    No milestone

    Relationships

    None yet

    Development

    No branches or pull requests

    Issue actions