crate

crate copied to clipboard

# Problem Currently under certain configurations and workloads it can happen that nodes crash with an OOM or have degraded responsivness for quite some time (Queries taking ms, taking seconds...

mfussenegger

Ability to provide session settings in HTTP request

8

### Problem Statement Session settings are increasingly used to influence CrateDB’s behavior during query execution. For queries over the PostgreSQL wire protocol, session management is handled at the protocol level....

proddata

Support parameter placeholder in 'insert into ... returning ?' for literals

1

### CrateDB version 5.10.1 ### CrateDB setup information _No response_ ### Problem description It seems that we cannot bind values for the 'RETURNING' part of an INSERT query. ### Steps...

surister

Cannot create dynamic columns for integers exceeding long range

2

### CrateDB version 5.10.3 ### CrateDB setup information _No response_ ### Problem description When we create a table with `DYNAMIC OBJECT`, CrateDB cannot dynamically insert integers bigger than `INTEGER` that...

surister

Automatically calculate heap size

6

This works in Docker / Kubernetes and bare Linux systems ## Summary of the changes / Why this improves CrateDB When running in Kubernetes you can just change the limits...

robd003

### Problem Statement Currently query expressions can turn out to be more expensive then expected when they cannot use lucene index structures. For users it is not easily visible which...

mfussenegger

Add a scalar function that takes a unfinished SQL statements and returns completion suggestions

2

## Use case Extending both the AdminUI and crash with semantic aware auto-completion, which uses a server to suggest schemas, tables, functions and keywords. This could be done on the...

mfussenegger

Support hash join execution strategy for `FULL JOIN`

1

### Problem Statement `FULL JOIN`s result in a nested loop join execution strategy and are therefore slow on large data sets. Example: ```sql CREATE TABLE IF NOT EXISTS "doc"."t1" (...

hammerhead

Interval addition / summation in CrateDB does not normalize time units.

4

### CrateDB version 5.10 ### CrateDB setup information local single node ### Problem description CrateDB does not normalize interval arithmetic results, leading to non-standard representations. Adding two intervals can produce...

proddata

### Problem Statement [Lookup-joins](https://github.com/crate/crate/pull/15664) are implemented in CratedDB but are currently disabled because they are still in an experimental state. Lookup-joins showed performance improvements of over 10 times in recent...

mkleen