How to translate unnest format for postgres to trino SQL #1076
-
|
Postgresql (and spark) allow you to unnest/explode inside the SELECT statement, but trino SQL requires you to move it to a lateral join or cross join. Transpile doesn't take care of this - does anyone have any ideas/approaches? |
Beta Was this translation helpful? Give feedback.
Answered by
tobymao
Feb 2, 2023
Replies: 1 comment
-
|
you can add a custom transform for this in transforms.py sqlglot already transpile presto cross join unnest to spark lateral view explode |
Beta Was this translation helpful? Give feedback.
0 replies
Answer selected by
andrewhong5297
Sign up for free
to join this conversation on GitHub.
Already have an account?
Sign in to comment
you can add a custom transform for this in transforms.py
sqlglot already transpile presto cross join unnest to spark lateral view explode