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
0
votes
1 answer

Will QuestDB work on a compressed file system?

I am using QuestDB on Linux with Ext4 file system and would like to explore an option of using a for of compression. I cannot find a list of supported File System on official website so wonder has anyone tried to run QuestDB on a filesystem with…
djbobo
  • 487
  • 2
  • 6
0
votes
1 answer

Very slow ingestion to QuestDB when using Postgres wire protocol

I have a problem with ingestion time when inserting rows into QuestDB table. Table definition: create table trade1 ( id symbol, buy_order_id string, currency string, price float, quantity float, instrument_id symbol, …
Ardelia Lortz
  • 72
  • 1
  • 8
0
votes
1 answer

Insert batch statement difference between two queries

Is there any difference between these two queries: create table tab(value int, ts timestamp) timestamp(ts) -- q1: insert batch 2 into tab values(1, systimestamp()),(2, systimestamp()) -- q2: insert batch 2 into tab select cast(x as…
marregui
  • 91
  • 4
0
votes
1 answer

Can I set up permissions per table in a database?

I'm trying to restrict the access to certain tables in a QuestDB instance, I would like to be able to have user-oriented permissions, possibly by type of operation like: user1 has read access for tables a, b and c user2 has read-write access to…
BurningFlan
  • 171
  • 7
0
votes
1 answer

How can I plot a moving average from Pandas to a chart?

Given a table that looks like the…
Brian Smith
  • 1,222
  • 7
  • 17
0
votes
1 answer

What does '[24] could not open read-only' error mean while benchmarking QuestDB in docker?

I'm running the time series benchmark suite against QuestDB in docker on Amazon Linux. The QuestDB image dies with an error like: I i.q.c.l.t.LineTcpMeasurementScheduler could not create table [tableName=cpu, ex=could not open…
BurningFlan
  • 171
  • 7
0
votes
1 answer

How to skip N rows in QuestDB SQL?

I'm creating paging output from data in QuestDB table and want to take 100 rows after X pages of 100 rows. In Postgres it would be something like select * from tbl OFFSET 200 LIMIT 100 I see LIMIT but cannot find OFFSET equivalent in QuestDB SQL,…
funnymay
  • 341
  • 1
  • 6
0
votes
1 answer

QuestDB stopped working after update to 6.0.3 on homebrew

After updating QuestDB to 6.0.3 using homebrew I cannot start it anymore $ questdb start ___ _ ____ ____ / _ \ _ _ ___ ___| |_| _ \| __ ) | | | | | | |/ _ \/ __| __| | | | _ \ | |_| | |_| | __/\__ \ |_| |_| | |_) | …
funnymay
  • 341
  • 1
  • 6
0
votes
1 answer

Can you make table read-only in QuestDB?

I have few big historical data tables in QuestDB and don't want to accidentally modify data in it. Is there a way to make table locked or read-only in QuestDB?
djbobo
  • 487
  • 2
  • 6
0
votes
1 answer

How do I delete tables in the QuestDB console?

I imported a lot of CSV files into my database for testing and I'd like to clear out a few of the tables I don't need. How can I get rid of multiple tables at once? Is there an easy way like selecting many tables in this view:
BurningFlan
  • 171
  • 7
0
votes
1 answer

How many lines is best to batch before sending the ILP data to QuestDB?

I read somewhere that Influx supports only 1000 metrics (lines of data) one can send via ILP. What is the maximum for QuestDB? I am batching 1000 lines currently before calling socket.send(), will the speed go up if I send more in one go?
Nick The Greek
  • 133
  • 5
0
votes
1 answer

Failure to use Hibernate with QuestDB: Missing Schema Table

I am using attempting to setup QuestDB with Hibernate and the Java Micronaut Framework. I am failing to map correctly to Java entities. Also, it looks like QuestDB is failing to generate a schema table on startup. I am using the postgres driver to…
darthS
  • 31
  • 4
0
votes
2 answers

Monitoring options for QuestDB?

I want to monitor QuestDB instance status, ideally in Prometheus. Would be good to see queries rate, ingestion speed, avg response time, etc. Is there a way to get this information out of QuestDB? I see only docs about minimum HTTP server which…
djbobo
  • 487
  • 2
  • 6
0
votes
1 answer

Can I make QuestDB to add column data to existing rows?

I use QuestDB and populate data from ILP messages. I want to see data coming from different sensors on the same row when tags match. For example I send first sensors,location=ny temperature=22 1465839830100400200 Table sensors is automatically…
allnau
  • 323
  • 1
  • 5
0
votes
2 answers

Custom timerange in QuestDB?

I'm currently doing queries like where startTs > '2021-04-18T00:00:00.000000Z' and startTs <= '2021-05-17T00:00:00.000000Z' It's not 1 month of data but intervals around 25 days. I wondering if there is a shorter syntax to query data between…
Nick The Greek
  • 133
  • 5
1 2 3
…
14 15