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 _Not sure if bug or feature request_ Consider the following data model: ```sql CREATE TABLE metrics ( "ts" TIMESTAMP WITH TIME ZONE NOT NULL, "ts_month" TIMESTAMP WITH...
### Problem Statement When there is a type casting error, an `SQLParseException` is thrown. The exception mentions which value failed to be casted, but not which column or expression caused...
## Problem Currently values of type `object` are represented as LinkedHashMap, in part to preserve ordering for dynamic column creation (https://github.com/crate/crate/commit/40cb1dbe0d41f838bce5c83aa0890bc03e6d2475) `LinkedHashMap` is rather heavy using up lots of memory,...
Use cases Making blob store a an object store Feature An additional non strict column in the blob table wont hurt unless there is a reason for not. Currently there...
## Summary of the changes / Why this improves CrateDB Follows https://github.com/crate/crate/pull/18754#issuecomment-3608848325. Below is a temporary benchmark simulating joining on primary key columns(resulting in HashGroup size=1 always): ``` [setup] statements...
WIP 👷 Via the [Contextual](https://docs.oracle.com/en/java/javase/25/docs/api/jdk.jfr/jdk/jfr/Contextual.html) JFR mechanism this would allow to associate built-in JFR events with queries. For example: ``` ❯ $JDK25/bin/jfr print --events io.crate.Stmt /tmp/profile.jfr | head io.crate.Stmt {...
### CrateDB version 6.0.4 ### CrateDB setup information Number of nodes: 3 CRATE_HEAP_SIZE: 1.75GB Storage: 32GB crate.yml contents: Default CR1 settings ### Problem description I ran an insert into statement...
Closes https://github.com/crate/crate/issues/18794
### Problem Statement [Pgpool-II](https://www.pgpool.net/docs/latest/en/html/) calls the PostgreSQL access privilege inquiry function `pg_catalog.has_function_privilege`. CrateDB doesn't implement this function yet. - https://github.com/crate/cratedb-examples/pull/1292#pullrequestreview-3555517765 - https://www.postgresql.org/docs/current/functions-info.html#FUNCTIONS-INFO-ACCESS - https://pgpedia.info/h/has_function_privilege.html ### Possible Solutions Implement the function,...
### Problem Statement Currently, if the `translog.flush_threshold_size`, configured by default to `512MB`, is reached, a full `refresh` is triggered, leading to flushing the indexing buffers of all segments, besides of...
