Skip to content

[FEATURE] PREWHERE clause in ClickHouse is not currently supported by the parser #2079

Open
@wqq-java

Description

@wqq-java

Grammar or Syntax Description

  • The PREWHERE clause in ClickHouse is not currently supported by the parser.
  • Example: PREWHERE clause is used for filtering rows before the SELECT list is processed.

SQL Example

``` 
    SELECT * FROM table PREWHERE column_name = 'value'
```

exception=Encountered unexpected token: "prewhere" <S_IDENTIFIER>
at line 30, column 9.

Was expecting one of:

","
";"
"APPLY"
"CONNECT"
"CROSS"
"EXCEPT"
"FOR"
"FULL"
"GROUP"
"HAVING"
"INNER"
"INTERSECT"
"JOIN"
"LEFT"
"MINUS"
"NATURAL"
"ORDER"
"OUTER"
"PIVOT"
"RIGHT"
"START"
"STRAIGHT_JOIN"
"UNION"
"WHERE"
"WINDOW"
<EOF>

Additional context

JSQLParser Version: [4.7.0]
ClickHouse Version: [23.x]
Reference documentation: [https://clickhouse.com/docs/en/sql-reference/statements/select/prewhere]

Metadata

Metadata

Assignees

No one assigned

    Type

    No type

    Projects

    No projects

    Milestone

    No milestone

    Relationships

    None yet

    Development

    No branches or pull requests

    Issue actions