Skip to content
New issue

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

Sign up for GitHub

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

Already on GitHub? Sign in to your account

Jump to bottom

SparkSQL 中的子查询若没有别名，会被解析成两条 SQL #19

Open
amosannn opened this issue Sep 6, 2024 · 0 comments
Open

SparkSQL 中的子查询若没有别名，会被解析成两条 SQL #19

amosannn opened this issue Sep 6, 2024 · 0 comments

Comments

@amosannn
Copy link

amosannn commented Sep 6, 2024 •
edited
Loading

若子查询没有设置 alias，SparkSqlHelper.parseStatement() 会报错，输入的 statement 会被解析成两段 SQL
image

测试用例 queryTest3()（去除该子查询的别名 b）：

superior-sql-parser/superior-spark-parser/src/test/kotlin/io/github/melin/superior/parser/spark/SparkSqlParserTest.kt

Line 1352 in 9846212

) b limit 111

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Assignees
No one assigned
Labels
None yet
Projects
None yet
Milestone
No milestone
Development

No branches or pull requests
1 participant
@amosannn