Stack Overflow
Stack Overflow

Questions tagged [questdb]

QuestDB is a high-performance, open-source SQL database used in financial services, IoT, machine learning, DevOps and observability.

QuestDB is an open-source SQL database for applications in financial services, IoT, machine learning, DevOps and observability. Questions with this tag should be about compatibility with the main interfaces:

  • queries and ingestion using PostgreSQL wire protocol
  • ingestion over InfluxDB Line Protocol
  • REST API for queries, bulk imports, and exports

Questions with this tag may also focus on SQL syntax and usage for time-oriented language features. For questions with language compatibility, add these tags where appropriate (e.g. [python-2.7] or [python-3.x]).

215 questions
2
votes
1 answer

Repeat the same filter avoiding the UNION ALL clause

I would like to filter my data within a time interval but in consecutive days for a determined amount of days. I know I can achieve that using select insert_datetime from table WHERE insert_datetime IN '2022-09-02T01:00:00;10m' UNION ALL select…
Cgra
  • 23
  • 2
2
votes
2 answers

Kafka/questDB JDBC Sink Connector: tables not created using "topics.regex"

I am using "confluentinc/kafka-connect-jdbc:10.2.6" as my JDBC connector to transfer Kafka topics into my questDB. When I provide explicit topic names it is working as expected. But when I use topic names based on regex then it's not working, the…
CarloP
  • 99
  • 1
  • 12
2
votes
1 answer

questdb： Table Busy is often displayed when data is inserting

Table Busy is often displayed when data is inserting. The error message is: Exception in thread "pool-3-thread-1" org.springframework.jdbc.UncategorizedSQLException: Error updating database. Cause: org.postgresql.util.PSQLException: ERROR: table…
Learzhu
  • 21
  • 1
2
votes
1 answer

Is there an NPM package for QuestDB?

I’m new to QuestDB, and I‘m wondering if there’s an npm package for it. I can see an npmjs.com/questdb package, but it doesn’t seem to have any data in it. Please tell me if there is. Thanks!
tallphin
  • 31
  • 5
2
votes
1 answer

Query to check configuration properties of running QuestDB instance

I was wondering if there is a way to query QuestDB for its configuration properties through SQL. I have noticed meta functions to see tables and table columns.
marregui
  • 91
  • 4
2
votes
1 answer

How can I update a QuestDB docker version without losing the container's data?

I have a QuestDB container that's running an older version at the moment, it's started and stopped by --name so that the data is persisted: docker run --name old_questdb \ -p 9000:9000 -p 9009:9009 questdb/questdb:5.0.5.4-linux-amd64 Is there any…
BurningFlan
  • 171
  • 7
2
votes
0 answers

QuestDB support for the Julia programming language

Julia is a high performance programming language that can handle large amounts of data fast, and it seems to be gaining momentum (https://www.hpcwire.com/2021/01/13/julia-update-adoption-keeps-climbing-is-it-a-python-challenger/). I have not seen…
marregui
  • 91
  • 4
2
votes
1 answer

Questdb authentication for web console?

I'm trying to add authentication to questdb web ui, as I don't want it to be exposed to the public internet. But it seems there are no options out of the box?
samO0
  • 61
  • 2
2
votes
1 answer

How to query distinct rows for every but one fields in QuestDB?

I have a table like A int, B int, C timestamp and there are multiple rows where B and C are same but A is different. How can select one of the rows only (with any of A values) per each (B, C) unique pair in QuestDB? If I had window function support…
Nick The Greek
  • 133
  • 5
2
votes
1 answer

How to avoid error "Cannot insert rows out of order" in QuestDB?

I'm trying to migrate data to QuestDB and inserting historical records, I create table as create table records( type INT, interval INT, timestamp TIMESTAMP, name STRING) timestamp(timestamp) and insert data from CSV by curl uploading it. I get back…
Doncarleone512
  • 346
  • 1
  • 7
2
votes
1 answer

Bulk out-of-order data import into QuestDB

I'm looking into using QuestDB for a large amount of financial trade data. I have read and understood https://questdb.io/docs/guides/importing-data but my case is slightly different. I have trade data for multiple instruments. For each instrument,…
eyevz
  • 63
  • 6
2
votes
1 answer

How can I programmatically download data from QuestDB?

Is there a way to download query results from the database such as tables or other datasets? The UI supports a CSV file download, but this is manual work to browse and download files at the moment. Is there a way I can automate this? Thanks
funnymay
  • 341
  • 1
  • 6
2
votes
1 answer

Issue writing from Influx Line Protocol to QuestDB

My problem is that I cannot wrote data to Quest DB with Influx Line Protocol (ILP) is I have an already created table with a schema. If I have an empty table (i.e. with no schema) then I can do the schema and the schema is auto-created. My questions…
Newskooler
  • 3,973
  • 7
  • 46
  • 84
2
votes
2 answers

How do I find shortcuts to run queries on the QuestDB console?

I'm using the QuestDB console (https://questdb.io/docs/reference/web-console) and I would like to know if there are keyboard shortcuts for operations such as running queries?
terminusfoundation 94
  • 93
  • 4
2
votes
1 answer

How do I authenticate QuestDb with database users

I'm considering using QuestDb for a small hobby project but I can't seem to wrap my head around how authentication is dealt with in QuestDb. I peeked at the Enterprise page and it almost looks like authentication is only available to…
Donkers
  • 21
  • 2
1
2
3
…
14 15