Carlin Eng
Carlin Eng
From a conversation today with @lloydtabb -- For any given field in a query, Malloy understands what were all the inputs to that field, and thus we can fully understand...
Right now, if a Malloy file has a single syntax error, the entire file breaks. None of the other queries in the file are runnable, and the Malloy schema viewer...
Bug report [from Slack](https://malloy-community.slack.com/archives/C025JAK8G0N/p1683136664264789). The [`LAST_DAY` function](https://cloud.google.com/bigquery/docs/reference/standard-sql/date_functions#last_day) in BigQuery takes a `date_part` as the second argument, but fails when you pass in a string. Some examples: The following query fails...
### What happens? In BigQuery, we are getting a `PROJECT cannot be used on queries with turtles` when attempgint to run the following query: ``` run: events -> { where:...
Interesting feature request from Slack. It's often the case where someone wants to use a `group_by` clause to deduplicate a table based on a set of columns. A query like...
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...
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...
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...
### 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...
### What happens? Malloy should support HLL functions, like those available in [BigQuery](https://cloud.google.com/bigquery/docs/reference/standard-sql/hll_functions) A few things that make this a bit trickier than the typical aggregate function: 1. The functions...