questdb/questdb

CREATE TABLE AS SELECT does not support all possible casting 12 days ago

Bug Good first issue

17.2K

QuestDB is a high performance, open-source, time-series database

Java

#capital-markets#cpp#database#financial-analysis#grafana#java#kdb#low-latency#market-data#olap#parquet#postgresql#questdb#real-time-analytics#simd#sql#tick-data#time-series#time-series-database#tsdb

domain specific functions for finance and aggregation 19 days ago

Enhancement Help wanted New feature SQL Good first issue hacktoberfest

questdb/questdb

17.2K

QuestDB is a high performance, open-source, time-series database

Java

#capital-markets#cpp#database#financial-analysis#grafana#java#kdb#low-latency#market-data#olap#parquet#postgresql#questdb#real-time-analytics#simd#sql#tick-data#time-series#time-series-database#tsdb

Table partitions for all tables in the QuestDB about 1 month ago

New feature Good first issue hacktoberfest

questdb/questdb

17.2K

QuestDB is a high performance, open-source, time-series database

Java

#capital-markets#cpp#database#financial-analysis#grafana#java#kdb#low-latency#market-data#olap#parquet#postgresql#questdb#real-time-analytics#simd#sql#tick-data#time-series#time-series-database#tsdb

Exact match using `LIKE` instead of `=` prevents index scan compilation 2 months ago

Bug SQL Good first issue hacktoberfest external

questdb/questdb

17.2K

QuestDB is a high performance, open-source, time-series database

Java

#capital-markets#cpp#database#financial-analysis#grafana#java#kdb#low-latency#market-data#olap#parquet#postgresql#questdb#real-time-analytics#simd#sql#tick-data#time-series#time-series-database#tsdb

Unhelpful SQL syntax error 3 months ago

SQL Good first issue hacktoberfest

questdb/questdb

17.2K

QuestDB is a high performance, open-source, time-series database

Java

#capital-markets#cpp#database#financial-analysis#grafana#java#kdb#low-latency#market-data#olap#parquet#postgresql#questdb#real-time-analytics#simd#sql#tick-data#time-series#time-series-database#tsdb

Fix escaping of special characters in JSON response from /exec?query=... 4 months ago

Bug Good first issue REST API hacktoberfest

questdb/questdb

17.2K

QuestDB is a high performance, open-source, time-series database

Java

#capital-markets#cpp#database#financial-analysis#grafana#java#kdb#low-latency#market-data#olap#parquet#postgresql#questdb#real-time-analytics#simd#sql#tick-data#time-series#time-series-database#tsdb

OOM logging is badly formatted 4 months ago

Enhancement Good first issue Bug 0

questdb/questdb

17.2K

QuestDB is a high performance, open-source, time-series database

Java

#capital-markets#cpp#database#financial-analysis#grafana#java#kdb#low-latency#market-data#olap#parquet#postgresql#questdb#real-time-analytics#simd#sql#tick-data#time-series#time-series-database#tsdb

Add support FILL by PREV 5 months ago

Help wanted New feature SQL

questdb/questdb

17.2K

QuestDB is a high performance, open-source, time-series database

Java

#capital-markets#cpp#database#financial-analysis#grafana#java#kdb#low-latency#market-data#olap#parquet#postgresql#questdb#real-time-analytics#simd#sql#tick-data#time-series#time-series-database#tsdb

CONVERT PARTITION should accept plural PARTITIONS as well 5 months ago

Enhancement SQL Good first issue Friction internal

questdb/questdb

17.2K

QuestDB is a high performance, open-source, time-series database

Java

#capital-markets#cpp#database#financial-analysis#grafana#java#kdb#low-latency#market-data#olap#parquet#postgresql#questdb#real-time-analytics#simd#sql#tick-data#time-series#time-series-database#tsdb

LT/ASOF JOIN with timestamp in ON clause crashes with AssertionError instead of returning proper error 6 months ago

Bug Help wanted Good first issue

questdb/questdb

17.2K

QuestDB is a high performance, open-source, time-series database

Java

#capital-markets#cpp#database#financial-analysis#grafana#java#kdb#low-latency#market-data#olap#parquet#postgresql#questdb#real-time-analytics#simd#sql#tick-data#time-series#time-series-database#tsdb

Port remaining parallelizable aggregate functions to off-heap data structures 7 months ago

Enhancement Help wanted SQL Performance hacktoberfest

questdb/questdb

17.2K

QuestDB is a high performance, open-source, time-series database

Java

#capital-markets#cpp#database#financial-analysis#grafana#java#kdb#low-latency#market-data#olap#parquet#postgresql#questdb#real-time-analytics#simd#sql#tick-data#time-series#time-series-database#tsdb

Add support for exposing database state similar to pg_stat_database and pg_stat_activity 8 months ago

New feature SQL Good first issue hacktoberfest

questdb/questdb

17.2K

QuestDB is a high performance, open-source, time-series database

Java

#capital-markets#cpp#database#financial-analysis#grafana#java#kdb#low-latency#market-data#olap#parquet#postgresql#questdb#real-time-analytics#simd#sql#tick-data#time-series#time-series-database#tsdb

Allow SAMPLE BY to use a long, rather than an INT for the units 8 months ago

New feature SQL Good first issue internal

questdb/questdb

17.2K

QuestDB is a high performance, open-source, time-series database

Java

#capital-markets#cpp#database#financial-analysis#grafana#java#kdb#low-latency#market-data#olap#parquet#postgresql#questdb#real-time-analytics#simd#sql#tick-data#time-series#time-series-database#tsdb

questdb-ilp-php - PHP port of LineProtoSender 9 months ago

Help wanted New feature Good first issue

questdb/questdb

17.2K

QuestDB is a high performance, open-source, time-series database

Java

#capital-markets#cpp#database#financial-analysis#grafana#java#kdb#low-latency#market-data#olap#parquet#postgresql#questdb#real-time-analytics#simd#sql#tick-data#time-series#time-series-database#tsdb

add `regr_r2` group by function, and funcs for RMSE and t-stats 9 months ago

New feature SQL Good first issue hacktoberfest external

questdb/questdb

17.2K

QuestDB is a high performance, open-source, time-series database

Java

#capital-markets#cpp#database#financial-analysis#grafana#java#kdb#low-latency#market-data#olap#parquet#postgresql#questdb#real-time-analytics#simd#sql#tick-data#time-series#time-series-database#tsdb

Optimise performance of var-args functions by adding loop-unrolled variants 9 months ago

Help wanted New feature SQL Good first issue hacktoberfest internal

questdb/questdb

17.2K

QuestDB is a high performance, open-source, time-series database

Java

#capital-markets#cpp#database#financial-analysis#grafana#java#kdb#low-latency#market-data#olap#parquet#postgresql#questdb#real-time-analytics#simd#sql#tick-data#time-series#time-series-database#tsdb

Escape mechanism doesn't work in like/ilike functions 10 months ago

Bug Good first issue hacktoberfest

questdb/questdb

17.2K

QuestDB is a high performance, open-source, time-series database

Java

#capital-markets#cpp#database#financial-analysis#grafana#java#kdb#low-latency#market-data#olap#parquet#postgresql#questdb#real-time-analytics#simd#sql#tick-data#time-series#time-series-database#tsdb

Expose additional Prometheus metrics for PGwire 10 months ago

New feature Good first issue hacktoberfest

questdb/questdb

17.2K

QuestDB is a high performance, open-source, time-series database

Java

#capital-markets#cpp#database#financial-analysis#grafana#java#kdb#low-latency#market-data#olap#parquet#postgresql#questdb#real-time-analytics#simd#sql#tick-data#time-series#time-series-database#tsdb

Create table with symbol cast produces zero rows 10 months ago

Bug SQL Good first issue hacktoberfest

questdb/questdb

17.2K

QuestDB is a high performance, open-source, time-series database

Java

#capital-markets#cpp#database#financial-analysis#grafana#java#kdb#low-latency#market-data#olap#parquet#postgresql#questdb#real-time-analytics#simd#sql#tick-data#time-series#time-series-database#tsdb

Disallow LATEST ON sub-queries on base table in materialized views 10 months ago

Enhancement Good first issue Materialized View

questdb/questdb

17.2K

QuestDB is a high performance, open-source, time-series database

Java

#capital-markets#cpp#database#financial-analysis#grafana#java#kdb#low-latency#market-data#olap#parquet#postgresql#questdb#real-time-analytics#simd#sql#tick-data#time-series#time-series-database#tsdb

SQL: cannot change column name casing in the query result 12 months ago

AI Summary: The task is to investigate why QuestDB's SQL query results do not reflect the specified column name casing in the `SELECT` statement (e.g., `SELECT symbol AS SYMBOL` returns `symbol` instead of `SYMBOL`). The issue needs debugging to determine if this is a bug or an intended behavior, and a fix or documentation update may be required.

Complexity: 4/5

SQL Good first issue

questdb/questdb

17.2K

QuestDB is a high performance, open-source, time-series database

Java

#capital-markets#cpp#database#financial-analysis#grafana#java#kdb#low-latency#market-data#olap#parquet#postgresql#questdb#real-time-analytics#simd#sql#tick-data#time-series#time-series-database#tsdb

[Enhancement] Add IF EXISTS to truncate table about 1 year ago

AI Summary: Implement an optional `IF EXISTS` clause for the `TRUNCATE TABLE` command in QuestDB. This would prevent errors when attempting to truncate a non-existent table, mirroring the behavior of `DROP TABLE IF EXISTS`.

Complexity: 3/5

Enhancement SQL Good first issue Friction

questdb/questdb

17.2K

QuestDB is a high performance, open-source, time-series database

Java

#capital-markets#cpp#database#financial-analysis#grafana#java#kdb#low-latency#market-data#olap#parquet#postgresql#questdb#real-time-analytics#simd#sql#tick-data#time-series#time-series-database#tsdb

Open Issues Need Help