Could someone take a look at this tiny PR: https://github.com/apache/calcite/pull/1811 ? Thanks in advance!
On Wed, Feb 12, 2020 at 12:46 PM wmy7ymw <wmy7...@gmail.com> wrote: > Got it. Good to learn these usages. Thanks for sharing. > > On Wed, Feb 12, 2020 at 12:22 PM Julian Hyde <jh...@apache.org> wrote: > >> >> >> > Hmm, man, there seems no UNNEST in Hive. But maybe it's introduced in a >> new >> > version. >> >> >> I was mistaken. >> >> It’s PostgreSQL that has an UNNEST function and allows it in the SELECT >> clause [1]. >> >> Hive allows table functions in the SELECT clause, which has similar >> problems of multiplying rows [2]. >> >> Julian >> >> [1] https://www.postgresql.org/docs/9.2/functions-array.html < >> https://www.postgresql.org/docs/9.2/functions-array.html> >> >> [2] >> https://cwiki.apache.org/confluence/display/Hive/LanguageManual+UDF#LanguageManualUDF-explode(array) >> < >> https://cwiki.apache.org/confluence/display/Hive/LanguageManual+UDF#LanguageManualUDF-explode(array)> >> >> >> >>