sql-metadata icon indicating copy to clipboard operation
sql-metadata copied to clipboard

Incorrect table names when using Presto UNNEST

Open saif-el opened this issue 3 years ago • 1 comments

If I parse this, valid Presto, query:

SELECT col_
FROM my_table
CROSS JOIN UNNEST(my_col) AS t(col_)

I get three table names:

  • my_table (correct)
  • my_col (incorrect)
  • col_ (incorrect)

I know Presto flavor SQL is not completely supported yet. But if it is not too much work, can we please add support for queries where UNNEST is being used?

saif-el avatar Feb 02 '22 06:02 saif-el

Hi, how is going on

river2022next avatar Jul 05 '23 04:07 river2022next