Skip to content

[BUG] JSQLParser 5.4-SNAPSHOT : Clickhouse : PREWHERE not supported in Clickhouse SELECT #2361

Closed as duplicate

Description

@tomershay

Failing SQL Feature:

In ClickHouse, PREWHERE is a query execution optimization that helps reduce how much data needs to be read from disk before filtering.

Reproduce the issue with this query:

SELECT *
FROM events
PREWHERE event_date = today()
WHERE user_id = 42;

Error:
ParseException: Encountered: <S_IDENTIFIER> / "event_date", at line 3, column 10, in lexical state DEFAULT.

Metadata

Metadata

Assignees

No one assigned

    Labels

    No labels
    No labels

    Type

    No type

    Projects

    No projects

      Milestone

      No milestone

      Relationships

      None yet

      Development

      No branches or pull requests

      Issue actions