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

Reply via email to