I am trying to get results for specific time period using hourof(timestamp).
SELECT timestamp, hourOf(timestamp),event_received from Metric where metricName = 'event_received' and EventType = 'TimeBlockChanged' SINCE 1 day ago WITH TIMEZONE 'America/Los_Angeles'
When using the above query , I am getting results for all timestamps. However, when I try to query for a specific timestamp, I am not getting the desired results.
SELECT sum( event_received) from Metric where metricName = 'event_received' and EventType = 'WorkerChanged' and hourOf(timestamp) = '2:00' SINCE 1 day ago WITH TIMEZONE 'America/Los_Angeles
In the first query, it clearly seen , that there are events for hourof(timestamp)=‘2:00’ . However, they are not visible when I try to query for that specific time.
Could some one help