I don’t know whether you are joking, but that is not a small PR.
> On Feb 24, 2020, at 10:34 PM, wmy7ymw <wmy7...@gmail.com> wrote: > > Could someone take a look at this tiny PR: > https://github.com/apache/calcite/pull/1811 > <https://github.com/apache/calcite/pull/1811> ? Thanks in advance! > > On Wed, Feb 12, 2020 at 12:46 PM wmy7ymw <wmy7...@gmail.com > <mailto: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 >> <mailto: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 >>> <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)> >>> < >>> https://cwiki.apache.org/confluence/display/Hive/LanguageManual+UDF#LanguageManualUDF-explode(array) >>> >>> <https://cwiki.apache.org/confluence/display/Hive/LanguageManual+UDF#LanguageManualUDF-explode(array)>>