You are viewing a plain text version of this content. The canonical link for it is here.
Posted to dev@calcite.apache.org by "Lindsey Meyer (JIRA)" <ji...@apache.org> on 2019/07/29 21:58:00 UTC
[jira] [Created] (CALCITE-3218) Syntax error while parsing DATEADD
Lindsey Meyer created CALCITE-3218:
--------------------------------------
Summary: Syntax error while parsing DATEADD
Key: CALCITE-3218
URL: https://issues.apache.org/jira/browse/CALCITE-3218
Project: Calcite
Issue Type: Bug
Reporter: Lindsey Meyer
Syntax error while parsing DATEADD
{code:java}
SELECT
DATE(CONVERT_TIMEZONE('UTC', 'America/Los_Angeles', events.event_date )) AS "events.event_date",
COALESCE(SUM(events.daily_user_count ), 0) AS "events.daily_active_users",
COALESCE(SUM(events.monthly_user_count ), 0) AS "events.monthly_active_users"
FROM public.events_proto AS events
WHERE
(((events.event_date ) >= ((CONVERT_TIMEZONE('America/Los_Angeles', 'UTC', DATEADD(day,-364, DATE_TRUNC('day',CONVERT_TIMEZONE('UTC', 'America/Los_Angeles', GETDATE())) )))) AND (events.event_date ) < ((CONVERT_TIMEZONE('America/Los_Angeles', 'UTC', DATEADD(day,365, DATEADD(day,-364, DATE_TRUNC('day',CONVERT_TIMEZONE('UTC', 'America/Los_Angeles', GETDATE())) ) ))))))
GROUP BY 1
HAVING
NOT (COALESCE(SUM(events.monthly_user_count ), 0) = 0)
ORDER BY 1 DESC
LIMIT 500{code}
{code:java}
`Column 'year' not found in any table`
`DATEADD(year,1,...`
{code}
--
This message was sent by Atlassian JIRA
(v7.6.14#76016)