@cl and @Jan Pojer let us look into this, the engineering team will be with you tomorrow 👍

Hi QuestDB team as i known for now SAMPLE BY can be used with LIMIT but when i'm using FILL it's still not working Example:

i've request an feature for questdb in the past pls questdb check this i've talk with @Pei https://github.com/questdb/questdb/issues/2761

Evening all - Happy Friday. In what situation would you recommend hourly partitions?

welcome @Shivam Barot and @Jonathan Wiemer!

Dear QuestDB community 👋 In case you’re not aware of it, version 6.5.5 has been release last week! 🔥 Release notes: https://github.com/questdb/questdb/releases/tag/6.5.5

Hi @vkarathanasi 👋 welcome!

welcome @Martin Brutsche

Hi there, in our company we are monitoring different physical assets and currently we have an individual database for each of these assets. This is a requirement we got. I just wanted to CREATE DATABASE in my QuestDB instance, but as it mentions "table" expected, am I right assuming, that it is not possible to have different databases within a QuestDB instance? So I suppose the only thing that I could do is to run one container for each assest and then assign these containers to different ports? Is that correct or are there other possibilities as well? Cheers Martin

Hi @Alex Stark welcome 👋

Hi questdb team i've problem about connection questdb for example: • Gorm is connected to questdb but theree is no query in few mins • then query i got: bad connection • then try query again it's worked due gorm auto reconnection How i can fix it?

welcome @Nik Richers!

hi questdb team, I wanna ask. how to start questdb on startup linux ubuntu server. I’ve questdb on VM, but if the vm restarted questdb not running automatically. this case show when the cloud service provider maintenance and the instance must be restart.

Hi QuestDB Team, environment QuestDB version: questdb-6.5.4 linux-amd64 Client: golangclient with 20 senders.(always keep connection) I found something weird when using QuestDB, Even though there is no data wring or reading during the time. but the system load is higher than data writing. I checked out the logs, and there are tons of logs printing. Does anyone have ideas about this?

Does questdb provide go-driver for database access now?

Hi there, I have an issue with a very specific table, it is just one column of timestamps. this column is also the dedicated "timestamp" column. It's created with the following SQL statement

CREATE TABLE ts(time_stamp TIMESTAMP) timestamp(time_stamp) PARTITION BY DAY;

I am using the questdb python library to insert data using the Influx DB line protocol. I have the following python code:

from datetime import datetime
from questdb.ingress import Buffer, Sender

user='admin'
password='quest'
host='localhost'
port=9009
database='qdb'

buf = Buffer()

ts_one = datetime.fromtimestamp(180)
ts_two = datetime.fromtimestamp(360)
print(ts_one)
print(ts_two)

buf.row('ts', symbols=None, columns= {'time_stamp': ts_one}, at=ts_two)
buf.row('ts_', symbols=None, columns= {'time_stamp': ts_one}, at=ts_two)
print(buf)

with Sender(host, port) as sender:
    sender.flush(buf)

the table

ts_

wasn't previously created. Now I'd expect to either have a timestamp at 3 or 6 minutes inside my

ts

table, but I end up with one at .18 seconds (

1970-01-01T00:00:00.180000Z

). In

ts_

on the other hand I get the expected value of 3 minutes in the

time_stamp

column and 6 minutes in a autogenerated column called

timestamp

. I get the correct value into

ts.time_stamp

if I multiply the integer used for creating the datetime by a factor 1000, but this feels hacky I have tried adding a row to the buffer with

columns=None

or

columns={}

with just

at=ts_one

but this didn't actually add a row to the buffer, I suppose because the row is in fact empty. If I omit the

at

parameter a new column will be created for the at value, and that's not what I want either. QuestDB version: 6.5.5 I've added screenshots for the values in the

ts

and

ts_

tables Any help is greatly appreciated, thank you

welcome @Diego COY and @Jonas Degelo

hi questdb team where i can get server conf file in docker container?

Hi QuestDB team,

I have installed QuestDB in a Windows server and I need to enable the COPY command. The problem is that I cannot find the server.conf file as suggested by the documentation. There is no such file in the installation directory of QuestDB. Any suggestions?

welcome @Andreas Sakellariou @Andy W @Valentin Stoyanov @Thomas Thio

Hi @Myrta welcome! 👋

Evening - Bit of an interesting problem, I have a query similar to the below which is intended on getting daily entries from the 22nd June for 150 days. This returns no records, but if I reduce the 150 down to 149 then it returns records...Any ideas?

select * from table where ts in '2022-06-22T23;1m;86400s;150'

can questdb python client ingest a pandas dataframe? Is there any samples? Thanks

Hi All! Is there any alternative influx JS client for QuestDB? Default have one line pipe architecture, not useful for async data insert

Hi. Testcontainers (java) since the last version officially supports QuestDB https://github.com/testcontainers/testcontainers-java/releases/tag/1.17.6

hey @Jakub Foltyn welcome !

hi all, quick question, when we query data from questdb instance we get no data and UI shows only error with no explanation - see screenshot below. In the log file of quest there is no error and only the following. Is it somehow related to response buffer is too small message?

Nov 21 16:15:04 questdb-sophon-raw-data-0 questdb[15121]: 2022-11-21T16:15:04.461795Z I http-server connected [ip=172.16.32.251, fd=9]
Nov 21 16:15:04 questdb-sophon-raw-data-0 questdb[15121]: 2022-11-21T16:15:04.461936Z I i.q.c.h.p.JsonQueryProcessorState [9] exec [q='select * from 'table_name'']
Nov 21 16:15:04 questdb-sophon-raw-data-0 questdb[15121]: 2022-11-21T16:15:04.461945Z I i.q.c.h.p.QueryCache miss [thread=questdb-worker-10, sql=select * from 'table_name']
Nov 21 16:15:04 questdb-sophon-raw-data-0 questdb[15121]: 2022-11-21T16:15:04.462234Z I i.q.g.SqlCompiler plan [q=`**** from (select [****] from table_name timestamp (recorder_ts))`, fd=9]
Nov 21 16:15:04 questdb-sophon-raw-data-0 questdb[15121]: 2022-11-21T16:15:04.462409Z I i.q.c.h.p.JsonQueryProcessorState [9] execute-new [skip: 0, stop: 1000]
Nov 21 16:15:05 questdb-sophon-raw-data-0 questdb[15121]: 2022-11-21T16:15:05.605549Z I i.q.c.h.p.JsonQueryProcessorState [9] Response buffer is too small, state=5
Nov 21 16:15:05 questdb-sophon-raw-data-0 questdb[15121]: 2022-11-21T16:15:05.605562Z I http-server scheduling disconnect [fd=9, reason=11]
Nov 21 16:15:05 questdb-sophon-raw-data-0 questdb[15121]: 2022-11-21T16:15:05.605582Z I http-server disconnected [ip=172.16.32.251, fd=9, src=queue]
Nov 21 16:15:05 questdb-sophon-raw-data-0 questdb[15121]: 2022-11-21T16:15:05.605680Z I i.q.c.h.p.QueryCache push [thread=questdb-worker-13, sql=select * from 'table_name']
Nov 21 16:19:59 questdb-sophon-raw-data-0 questdb[15121]: 2022-11-21T16:19:59.663314Z I i.q.c.p.ReaderPool closed 'table_name' [at=0:0, reason=IDLE]

Hello questdb folks, Per the Executive Order on Cyber Security items 5.1/5.2 I'm force to split my environment into different tiers which means I will have two questdb instances. What best practice when one wants to report on consolidated data of both instances using grafana