Mathias Fußenegger

CREATE SERVER / FOREIGN DATA WRAPPER

3

## Use case Adding another server or storage (blob store) to CrateDB (Either another CrateDB cluster, or a JDBC compatible data source) to transparently query data from the other system....

Support correlated subquery within select list

2

This is a subset of https://github.com/crate/crate/issues/9320 ## Use case Using tools like Grafana, or client drivers like PostgreSQL JDBC client (`getMetaData().getUDTs`), [TypeORM](https://typeorm.io/) and many others. ## Feature description Allow a...

**Use case**: Wanting to delete older records using `DELETE FROM` or `DROP TABLE` after running out of disk space to get some more free space again. **Feature description**: Due to...

Support `sum` on values of type interval

4

**Use case**: Get the total duration over many events. Something like `select sum(age(ended, started)) from myevents` or `select sum(ended - started) from myevents` - depending on https://github.com/crate/crate/issues/12479 See https://github.com/crate/crate/blob/dc3ce297b1597d482949a2e57479890feb3adbf4/server/src/main/java/io/crate/execution/engine/aggregation/impl/SumAggregation.java#L67-L98 for...

Currently each `WHEN` clause of a case expressions is normalized into `IF` tree: https://github.com/crate/crate/blob/9a857e3204467365f0163f204eab51e9cdb1c212/server/src/main/java/io/crate/analyze/expressions/ExpressionAnalyzer.java#L485-L556 The resulting structure can be very large which can cause issues, like [stackoverflows](https://github.com/crate/crate/issues/12227) We could probably...

Add `RECURSIVE` support to common table expressions (WITH)

1

Continuation of https://github.com/crate/crate/issues/11757 Basic `WITH` got implemented in https://github.com/crate/crate/pull/12540 We should extend it with support for the `RECURSIVE` clause to support the query mentioned in https://github.com/crate/crate/issues/11757. A simpler version looks...

**Use case**: Getting the duration of an event that has a `started` and `ended` column. **Feature description**: Currently subtracting one timestamp from another returns a `timestamp` instead of `interval`. This...

## Summary of the changes / Why this improves CrateDB WIP ``` Benchmark Mode Cnt Score Error Units IndexingBenchmark.measure_index_writer_add_document avgt 8 768.747 ± 68.979 ns/op IndexingBenchmark.measure_index_writer_add_document_and_commit avgt 8 531742.933 ±...

First class table & partitions within cluster state

1

## Current state CrateDB tables and partitioned tables were initially built on top of ES index and aliases functionality. A table has a 1:1 mapping to an ES index. A...

**Use case**: - Diagnose why subscribed tables are not advancing - Get an idea how much replication lags behind. (And if it is catching up) **Feature description**: Currently temporal errors...