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.

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

[BUG] Expand doesn't support alias in GA environment #910

Open
qianheng-aws opened this issue Nov 15, 2024 · 0 comments
Open

[BUG] Expand doesn't support alias in GA environment #910

qianheng-aws opened this issue Nov 15, 2024 · 0 comments
Assignees
Labels
0.6 backport 0.6 bug Something isn't working Lang:PPL Pipe Processing Language support sanity-0.6

Comments

@qianheng-aws
Copy link
Contributor

What is the bug?
These 2 queries got failure because of syntax error.

source = myglue_test.default.region | where 'EUROPE' | eval array=json_array(1, 2, 3, 4) | expand array as uid | fields uid, r_name

source = myglue_test.tpch_csv.orders | eval array=json_array(1, 2, 3) | expand array as uid | fields uid, o_comment

How can one reproduce the bug?
Run the above queries in GA env.

What is the expected behavior?
It should run successfully.

What is your host/environment?

Do you have any screenshots?
If applicable, add screenshots to help explain your problem.

Do you have any additional context?
Looks like this commit is missing in GA branch p1-antlr-grammar:
#868

So the current env doesn't support AS after EXPAND, see diff:

p1-antlr-grammar:
expandCommand
    : EXPAND fieldExpression
    ;

main: 
expandCommand
    : EXPAND fieldExpression (AS alias = qualifiedName)?
    ;
@qianheng-aws qianheng-aws added bug Something isn't working untriaged labels Nov 15, 2024
@YANG-DB YANG-DB added Lang:PPL Pipe Processing Language support 0.6 sanity-0.6 backport 0.6 and removed untriaged labels Nov 15, 2024
@YANG-DB YANG-DB self-assigned this Nov 15, 2024
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
0.6 backport 0.6 bug Something isn't working Lang:PPL Pipe Processing Language support sanity-0.6
Projects
None yet
Development

No branches or pull requests

2 participants