Repository navigation
I use it to analyze clickhouse sql，But there is a problem，Can you show me #1535
Description
select
b.name,
a.pay_amount,
a.partner_team_id
from
order_pay a
GLOBAL join team b on a.partner_team_id = b.id
error
net.sf.jsqlparser.JSQLParserException: Encountered unexpected token: "GLOBAL" "GLOBAL"
at line 1, column 73.
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>
at net.sf.jsqlparser.parser.CCJSqlParserUtil.parseStatement(CCJSqlParserUtil.java:165)
at net.sf.jsqlparser.parser.CCJSqlParserUtil.parse(CCJSqlParserUtil.java:59)
at net.sf.jsqlparser.parser.CCJSqlParserUtil.parse(CCJSqlParserUtil.java:37)
Because Clickhouse distributed tables need to use global join syntax
version：jsqlparser 4.0
jdk:1.8
Activity
manticore-projects commentedon May 13, 2022
Greetings!
Clickhouse's specific
GLOBAL JOINis not supported yet, but your contribution/PR will be very welcome.lif123456 commentedon May 13, 2022
Thank you for your reply. Can you give me an idea to modify it? It helped me a lot
wumpz commentedon May 15, 2022
JoinerExpression()line 2583.Joinyour global flagtoStringand deparser to reproduce this join constructSelectTestsusingassertSqlCanBeParsedAndDeparsed(stmt);lif123456 commentedon May 16, 2022
Thank you. I'll try when I have time
feat: Clickhouse GLOBAL JOIN
Assorted Fixes #4 (#1676)