Re: Supporting named row construction in Calcite SQL

2018-04-04 Thread Julian Hyde
If I recall correctly, Google BigQuery has SELECT AS STRUCT. It’s not standard, but if it does what you need we could consider adopting that syntax. Julian > On Apr 4, 2018, at 10:23 AM, Albert wrote: > > if it is not SQL standard, it's just a matter of categorizing it

Re: DISTINCT ON clause

2018-04-04 Thread Aman Sinha
Would the Calcite community be ok with having a new function called 'ANY_VALUE()' which is of type SqlAggFunction ? The usage of this would be with a GROUP BY, similar to what Gian described for Druid but with the difference that the keyword any_value makes it explicit that there is no ordering

Re: [ANNOUNCE] New committer: Shuyi Chen

2018-04-04 Thread Rong Rong
Congratulations Shuyi! -- Rong On Wed, Apr 4, 2018 at 6:05 AM, Fabian Hueske wrote: > Hi Shuyi, > > Congratulations for becoming a Calcite committer and thank you for all the > contributions to Calcite (and Flink)! > > Best, > Fabian > > 2018-04-04 1:18 GMT+02:00 Michael

Re: [ANNOUNCE] New committer: Shuyi Chen

2018-04-04 Thread Fabian Hueske
Hi Shuyi, Congratulations for becoming a Calcite committer and thank you for all the contributions to Calcite (and Flink)! Best, Fabian 2018-04-04 1:18 GMT+02:00 Michael Mior : > If you ever see any opportunity to speak about Calcite, you're always > welcome to do so. If you