crate
crate copied to clipboard
crate
CrateDB is a distributed and scalable SQL database for storing and analyzing massive amounts of data in near real-time, even with complex queries. It is PostgreSQL-compatible, and based on Lucene.
### Problem Statement There's a noticeable concern with the current method of allocating shards to nodes. Right now, there appears to be no randomness in how shards are assigned (see...
### Problem Statement Given two arrays, I want to know if they overlap or not. Example: ```sql CREATE TABLE t1 ( id INTEGER PRIMARY KEY, my_array ARRAY(INTEGER) ); INSERT INTO...
Relates to https://github.com/crate/crate/pull/16621#issuecomment-2355069537. Results: ``` Benchmark Mode Cnt Score Error Units DistinctFromBenchmark.benchmarkDistinctQueryBuilding avgt 4 4,142 ± 0,067 us/op DistinctFromBenchmark.benchmarkEqualQueryBuilding avgt 4 2,936 ± 0,017 us/op DistinctFromBenchmark.benchmarkDistinctFromQueryRun avgt 4 34,469 ±...
### Problem Statement The command `SET ROLE TO 'role1';` that sets the current user identifier of the current SQL session to be `role1` is not compatible with Postgres, which does...
## Summary of the changes / Why this improves CrateDB There are 3 storageSupport types(GeoShape, GeoPoint, Object) that carry `null` eqQuery. And when eqQuery == null, we fall back to...
## Problem Currently we have an expression evaluation system based on `Input` and `Row`, where both operate with `Object` instances. This often leads to concrete evaluations that look like: -...
### CrateDB version latest master ### CrateDB setup information _No response_ ### Problem description _No response_ ### Steps to Reproduce ``` cr> create table t (o object); CREATE OK, 1...
### Problem Statement With the right set of heavy queries, it is possible to exhaust the entire available CPUs on a CrateDB Cloud cluster. The cluster at that point becomes...
### Problem Statement In some rare cases, e.g. due to disk failures, some files of a shard can get corrupted. If there isn't a good copy of that shard somewhere...
Currently CrateDB allows both sides to be patterns while Postgres allows patterns in RHS only: ``` cr> select 'a_' like any(['aa']); +------+ | true | +------+ | TRUE | +------+...