TIME data type is not supported in Clickhouse. What are the best practices to deal with such data? Currently we are using following formula:
HOUR(timestamp)*100+MINUTE(timestamp) BETWEEN 930 and 1000
to get the data filtered by time part. That adds calculation overhead so probably it is better to store the time part in it's own column. What to store there? Should we store in such way or for example number of milliseconds/seconds/minutes starting from midnight?