jiacai2050 commented on issue #1597:
URL: https://github.com/apache/horaedb/issues/1597#issuecomment-2491040997
Hi, nanoseconds is not supported in horaedb now.
For your case, I think you could add another column to bypass this limit,
``` sql
CREATE TABLE IF NOT EXISTS {base} (
time timestamp NOT NULL,
time2 uint64 NOT NULL,
id uint64,
exchange string,
quote string,
price double,
size double,
TIMESTAMP KEY(time),
PRIMARY KEY(time, time2, id, exchange, quote)
) ENGINE=Analytic with (enable_ttl='false')
```
Here we add another column `time2` to primary keys, and it's defined as
`time(nanoseconds) % 1e6`, so rows with same `time` value won't be overwritten.
--
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.
To unsubscribe, e-mail: commits-unsubscr...@horaedb.apache.org
For queries about this service, please contact Infrastructure at:
us...@infra.apache.org
---------------------------------------------------------------------
To unsubscribe, e-mail: commits-unsubscr...@horaedb.apache.org
For additional commands, e-mail: commits-h...@horaedb.apache.org
