zed
zed copied to clipboard
brimdata
A novel data lake based on super-structured data
## tl;dr ``` $ super -c "SELECT cast(a AS VARCHAR) FROM 'test.csv';" type "varchar" does not exist at line 1, column 18: SELECT cast(a AS VARCHAR) FROM 'test.csv'; ~~~~~~~ ```...
## tl;dr ``` $ super -c "SELECT 3::string" parse error at line 1, column 11: SELECT 3::string === ^ === ``` ## Details Repro is with super commit cabf51f. This...
## tl;dr ``` $ super -f text -c "SELECT x, y FROM 'a.csv' i1(x, y);" cannot apply aliased columns to dynamically typed data at line 1, column 26: SELECT x,...
## tl;dr The [ClickBench q34 SQL](https://github.com/ClickHouse/ClickBench/blob/351f77f5e1ca34b292a745928dfeef5e4a86a8f3/clickhouse/queries.sql#L35) is currently rejected by SuperDB though it was previously accepted and would produce the correct result in the past. ``` $ super -version Version:...
The `REGEXP_REPLACE` function is called the same way in ClickBench query 28 with [Postgres](https://github.com/ClickHouse/ClickBench/blob/196772a3889552c8dd73fdf1822592428f57e4bf/postgresql/queries.sql#L29), [DuckDB](https://github.com/ClickHouse/ClickBench/blob/196772a3889552c8dd73fdf1822592428f57e4bf/duckdb/queries.sql#L29), and [ClickHouse](https://github.com/ClickHouse/ClickBench/blob/196772a3889552c8dd73fdf1822592428f57e4bf/clickhouse/queries.sql#L29). However, if we attempt the same call with SuperDB's `REGEXP_REPLACE` function it currently...
At the moment, `mdtest-spq` examples all expect compact SUP output, but several examples would be much more readable with alternate formats. ## Details There's several examples of this, but the...
The merge of the changes in #5669 is correlated with the performance of the [Search+ query from the `super` command docs](https://superdb.org/docs/commands/super/#search-1) becoming more than 4x worse. ## Detail Repro is...
```shell ❯ super --version Version: v1.18.0-350-g733dc02a1 ❯ super -c "bucket(59s, 1m)" 0s ❯ super -c "bucket(59m, 1h)" 0s ``` I think `bucket` should retain the label of the second argument...
SuperDB is not expected to have support for [Window Functions](https://www.postgresql.org/docs/current/tutorial-window.html) (as they exist in SQL) in its first GA release, but the functionality will be added eventually. Existing issue #5308...
## What's Changing This is my attempt to document how the tools present values in a canonical form in the human-readable output formats such as SUP. ## Why When fielding...