Apologies for my silence. I don't really have thoughts on the matter at this point. It might be helpful if you can give an example of what you're proposing. Unless I'm missing something (very possible), it's not part of the SQL standard.
-- Michael Mior mm...@apache.org 2018-04-03 18:48 GMT-04:00 Shuyi Chen <suez1...@gmail.com>: > Friendly ping, any thoughts? Much appreciated. > > Shuyi > > On Tue, Mar 27, 2018 at 11:59 PM, Shuyi Chen <suez1...@gmail.com> wrote: > > > Hi community, > > > > I am thinking of adding the following support in Calcite to support named > > row construction, e.g. > > > > SELECT (a as first_name, b as last_name, (c as zip code, d as street, e > as > > state) as address) as record FROM example_table > > > > The output will be struct with field names specified in the SQL. The > usage > > scenario is that say, in streaming SQL, the downstream sink's schema can > > not be changed, so we will need to use SQL to construct a struct with the > > proper naming according to the schema in order to write to the downstream > > sinks. Thanks a lot. > > > > Shuyi > > > > -- > > "So you have to trust that the dots will somehow connect in your future." > > > > > > -- > "So you have to trust that the dots will somehow connect in your future." >
