questdb/questdb

Extend ILP to allow to set non-designated timestamp column to current server timestamp

开放

#2,139 创建于 2022年5月19日

 (0 条评论) (0 个反应) (0 位负责人)Java (972 个派生)batch import
Help wantedNew feature

仓库指标

星标
 (13,403 个星标)
PR 合并指标
 (平均合并 5天 13小时) (30 天内合并 108 个 PR)

描述

Is your feature request related to a problem?

Sometime it's useful to see the difference between the event timestamp and the timestamp it is got written in QuestDB. To do that a column with server timestamp auto generated by QuestDB is needed.

Describe the solution you'd like.

Add feature to ILP parser to write server timestamp to a column

table,ticker=BTC price=123.42,server_timestamp=now() 1652971930000000000

I suggest using syntax now() because it's relatively short and descriptive

This should create table

column type value
ticker Symbol BTC
price Double 123.42
server_timestamp Timestamp 2022-05-19T14:52:12
timestamp Timestamp 2022-05-19T14:52:10

Describe alternatives you've considered.

Alternative would be to add default value in table create statement. Defaults are useful on their own and deserve their own issue.

Adding syntax to ILP will still be useful since many users do not pre-create tables before sending ILP data

Additional context.

No response

贡献者指南