You signed in with another tab or window. Reload to refresh your session.You signed out in another tab or window. Reload to refresh your session.You switched accounts on another tab or window. Reload to refresh your session.Dismiss alert
But when performing calculations, only the first style plans in normal expressions:
-- plansselect event_time - interval '5' seconds from stream;
-- errors with "Cannot coerce arithmetic expression Timestamp(Nanosecond, None) - Utf8 to valid types"select event_time -'5 seconds'from stream;
However, when computing virtual columns of a create table (for example for defining a watermark) both syntaxes plan, but the second one produces a compilation error:
CREATE TABLE (
...
watermark TIMESTAMP GENERATED ALWAYS AS (CAST(timestamp as TIMESTAMP) - '5 seconds'),
error[E0277]: cannot subtract `std::string::String` from `SystemTime`
--> pipeline/src/main.rs:98:39
|
98 | ... } - "5 seconds".to_string()),
| ^ no implementation for `SystemTime - std::string::String`
|
The text was updated successfully, but these errors were encountered:
We have two syntaxes for creating an interval:
INTERVAL '5' second
'5 seconds'
Both work as arguments to window functions:
But when performing calculations, only the first style plans in normal expressions:
However, when computing virtual columns of a create table (for example for defining a watermark) both syntaxes plan, but the second one produces a compilation error:
The text was updated successfully, but these errors were encountered: