lloyd tabb

Help Simulating a lateral Join

4

The query below simulates a lateral join from a nested array. The problem is I can't reference the array length in the join so I generate a large array and...

Incorrect results in Query..

2

### What happens? The following query should return no results. It is essentially computing a ratio. In different versions of DuckDB it returns different results with the same data. ```...

row_number() produces incorrect results

4

The following query produces incorrect results. id2 should always be 1 or 2 but I'm seeing different numbers. ``` run: duckdb.table('malloytest.airports') -> { group_by: faa_region aggregate: airport_count is count() calculate:...

measure: x is (elevation + elevation).sum()

1

``` measure: x is (elevation + elevation).sum ``` is illegal. We get a weird error when parsing and we should probably recommend the syntax ``` measure: x is source.sum(elevation+elevation) ```

BigQuery has added UNNEST WITH OFFSET to compute the index of an unnested array. We should try and use it instead of row_number() over() as it is likely more efficient.

In Snowflake you can't use a view that contains a pipeline as a nest. Other dialects handle this with correlated subqueries over arrays. Unfortunately Snowflake doesn't support correlated subqueries. Here...

except vs private ?

3

I'm not sure we have the concept of 'except' right. Consider: ``` source: a is airports extend { where: state='CA' } extend { except: state } run: a -> {select:...

Docs Barn Raising

3

I'd like to take some time and all take a pass through the documentation. There is some cruft, multiple documents that point to the same thing. Some bad instructions (connections...

Don't allow a nested select in a `group_by:` query.

4

I'm not sure how to reliably generate code in this case. For now lets dis-allow it. ``` foo -> { group_by: something nest: bar is { select: something_else // error:...