malloy

malloy copied to clipboard

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:...

lloydtabb

weird bug with date ranges

2

``` run: bigquery.sql(""" SELECT DATE '2001-01-01' as join_date, DATE '2001-02-01' as expiry_date """) -> { select: round_wrong is round(days(join_date to expiry_date)) no_round_right is days(join_date to expiry_date) } ```  The...

mtoy-googly-moogly

Implement the proposal outlined here: https://github.com/malloydata/whatsnext/blob/main/wns/WN-0003/wn-0003.md From the issue above: > We can handle unknown scalar functions in the Malloy but we have to use an ugly workaround for aggregate...

carlineng

Similar to #1555, but supporting the percentile calculations in a `calculate:` clause instead of an `aggregate:` clause. We should support both `percentile_cont` and `percentile_disc`, where `cont` interpolates between the two...

carlineng

We have gotten a lot of feature requests from users asking for percentile functions. We should support both `percentile_cont`, and `percentile_disc`. From the [Snowflake documentation](https://docs.snowflake.com/en/sql-reference/functions/percentile_cont): "The function PERCENTILE_CONT interpolates between...

carlineng

narreola

Window Functions

5

Add support for window functions. A few we'd probably like to support: - LAG / LEAD : "how long did it take for User to get from step A to...

anikaks

``` run: duckdb.sql("SELECT DATE '2001-01-01' AS dstart, DATE '2002-02-01' AS dend") -> { select: dstart, dend, ddiff is months(dstart to dend) } ``` Errors with `Cannot measure interval using 'month'`...

mtoy-googly-moogly

Error using a dimension w/ a nested field reference in a join

2

### What happens? I have a Source with a nested field, and I create a dimension on that Source that references the nested field: ``` source: raw_vals is bigquery.table(`mytable`) extend...

carlineng

`exclude(expr, dimension_name)` in an aggregate statement is checked at compile time, and if the dimension is not a grouping file for the query operation, or a query operation this query...

mtoy-googly-moogly