Oh, maybe not well calibrated. Let me know if there is anything I could do to help on review.
Thanks! On Feb 24, 2020, 10:53 PM -0800, Julian Hyde <[email protected]>, wrote: > I don’t know whether you are joking, but that is not a small PR. > > > > On Feb 24, 2020, at 10:34 PM, wmy7ymw <[email protected]> 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 <[email protected] > > <mailto:[email protected]>> wrote: > > > > > Got it. Good to learn these usages. Thanks for sharing. > > > > > > On Wed, Feb 12, 2020 at 12:22 PM Julian Hyde <[email protected] > > > <mailto:[email protected]>> 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)>> >
