Skip to content
New issue

Have a question about this project? # for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “#”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? # to your account

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

Open
wqq-java opened this issue Sep 19, 2024 · 0 comments

Comments

@wqq-java
Copy link

wqq-java commented Sep 19, 2024

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]

# for free to join this conversation on GitHub. Already have an account? # to comment
Projects
None yet
Development

No branches or pull requests

2 participants