Re: UNNEST in relational algebra

2021-11-16 Thread Spotify
html#collection-functions. > > Cordialement / Best Regards, > *Thomas Rebele, PhD* | R Developer | Germany | www.tibco.com > > > On Tue, Nov 16, 2021 at 2:30 PM Daniel (Spotify) Ståhl > wrote: > > > Hi > > We are trying to generate relational algebra for

UNNEST in relational algebra

2021-11-16 Thread Spotify
Hi We are trying to generate relational algebra for SQL that uses UNNEST of arrays in BigQuery. Here are three examples of SQL (in Big Query standard query syntax) that we want to be able to handle and generate from relational algebra. Any tips on how you would do that in Calcite? SELECT id,