Georg Traar

Results 66 issues of Georg Traar

### Problem Statement Using Tableau to build visualizations and reports off CrateDB with the PostgreSQL connection, the lack of native support for the comparison operators "IS DISTINCT FROM" and "IS...

contributions welcome
feature: sql: operators
complexity: no estimate
tool: Tableau

_Originated from community question: https://community.cratedb.com/t/prometheus-failed-to-write-data-into-cratedb-after-encountering-error-a-document-with-the-same-primary-key-exists-already/1724_ --- We probably could add the option to use upserts or make it the even default approach. Since the table definition is using primary keys...

enhancement
go

Right now the **Cluster** view consists of a **nodelist** and a **node-detail** view for a single node. For clusters with many nodes, switching between nodes might become tedious. Also it...

feature
complexity: no estimate
feature: nodes

Right now the system tables are filtered (sys, information_schema, pg_catalog) in the Admin UI. People often aren't aware, that tables like `sys.jobs` or `sys.jobs_log` exists. Therefore I would propose to...

feature
complexity: no estimate
feature: tables

With 4.5.0 UDFs became available in all versions. Right now one has to know where to look for existing UDFs defined in the `information_schema.routines` table like so: ```sql SELECT routine_schema,...

feature
complexity: no estimate
feature: views

## Summary of the changes / Why this is an improvement Adding a view for User Defined Functions helps to manage and replace UDFs within CrateDB. Before one would need...

### Problem Statement When interactively writing queries in CrateDB one needs to specify the list of columns in two locations for aggregations, which can lead to broken queries and pontential...

feature: ux
feature: sql: group by
leverage: low

### Problem Statement CrateDB's current export functionality is limited to JSON format, which results in the loss of type information and suboptimal data handling. The COPY TO command lacks support...

needs info or feedback
needs concrete use-case
need refined description

It is confusing that without providing a dedicated port, we don't default to 4200 in all cases, e.g. when specifying to use TLS e.g. ```sh crash --hosts 'host' --> http://host:4200...

> [!NOTE] > This is intended as temporary meta issue to document some potential bugs and potetnital feature improvements regarding using a PostgreSQL server as foreign server within CrateDB, specifically...

need refined description