zed
zed copied to clipboard
brimdata
A novel data lake based on super-structured data
At the moment, the [Super Data Model](https://superdb.org/docs/formats/data-model/) lacks a specific `DATE` type like SQL has. In the meantime, `time` types with a zeroed-out time portion can be used. ## Details...
There's an enhancement that's been proposed via inline text in the [Expressions doc](https://superdb.org/docs/language/expressions/#formatted-string-literals): > If any expression results in an error, then the value of the f-string is the first...
The SQL spec indicates the `MIN` and `MAX` aggregate functions should work with many data types, but these functions in SuperDB currently only support numeric types. ## Details Repro is...
## tl;dr Given input `data1.sup`: ``` {foo: 1} error("missing") ``` And `data2.sup`: ``` {bar: 2} ``` The following query causes a panic: ``` $ super -c " from data1.sup |...
## tl;dr ``` $ echo '{a:[1,2],c:1} {a:[3,4],c:1}' | super -z -c "over a with c => (sort | head 1 | yield {c})" - panic: runtime error: index out of...
SuperDB's CSV/TSV readers currently depend on the presence of a header row to explicitly specify field names, whereas other SQL systems can let in unnamed fields which can then be...
SuperSQL currently lacks built-in aggregate functions for calculating statistics (such as standard deviation and variance). ## Details At the time this issue is being opened, super is at commit 6ca49b7a....
The [Formats](https://superdb.org/docs/formats/) docs have placeholders for "decimal" types `decimal32`,`decimal64`, `decimal128`, and `decimal256` such as are often used in financial applications. This issue tracks their implementation in the SuperDB tooling.
Repro is with super commit 7a5d7b95. As pointed out in https://github.com/brimdata/super/issues/5802#issuecomment-2797782585, the result of the [Left Join example](https://superdb.org/docs/tutorials/join/#left-join) from the `join` tutorial differs when run in vector runtime. ``` $...
It's been noted that the size of a CSUP file generated from the GitHub archive data used in the [`super` command perf queries](https://superdb.org/docs/commands/super/#performance) jumped significantly due to the changes in...