Using time in hstreamdb

[gwafflar]

Hello,
I cannot use functions related to time in my queries.

CREATE VIEW impression_daily AS SELECT DAY(event_at) AS day_, COUNT(*) AS impressions_count, FROM impressions_stream GROUP BY day_ ;

event_at is of the type TIMESTAMP.
According to the official doc should work, but I receive the error that DAY doesn't exist. Same problem using DATE(), CAST, etc.
What do I do wrong ?

[Commelina]

Thanks for your report! According to the document, the query can be written by function CAST(... AS ...):

CREATE VIEW impression_daily AS SELECT CAST(event_at AS DATE) AS day_, COUNT(*) AS impressions_count FROM impressions_stream GROUP BY day_;

However, there is a bug related to TIMESTAMPs and aliases in GROUP BY clause, which prevents the system to produce correct outputs for the query above. We will fix it as soon as possible and then you can try it again using the latest commit.

Also, note that DATE is used for date literals (e.g. INSERT INTO some_stream (some_column) VALUES (DATE 2022-12-12)) or a type (e.g. CAST(... AS DATE)) and DAY is not a function name now (we will recheck our doc to make it up to date!).

[4eUeP]

Fixed by #1215