-
Notifications
You must be signed in to change notification settings - Fork 0
Interval math causes error #27
Copy link
Copy link
Open
Description
Use the sample data and view from the readme
SEMANTIC SELECT
year,
region,
AGGREGATE(revenue) AS revenue,
AGGREGATE(revenue) AT (ALL region) AS year_total,
AGGREGATE(revenue) / AGGREGATE(revenue) AT (ALL region) AS pct_of_year
FROM sales_v
where make_date(year,1,1) between '2023-01-01' and '2023-01-01' + interval '30' days;
causes error:
Invalid Input Error:
Query error: Parser Error: syntax error at or near "_inner"
LINE 4: ...,1,1) between '2023-01-01' and '2023-01-01' + interval '30' _inner.days) AS revenue,
^
LINE 4: ...,1,1) between '2023-01-01' and '2023-01-01' + interval '30' _inner.days) AS revenue,
^
LINE 1: SEMANTIC SELECT
Reactions are currently unavailable
Metadata
Metadata
Assignees
Labels
No labels