abhishekagarwal87 commented on issue #10476:
URL: https://github.com/apache/druid/issues/10476#issuecomment-703546489
hmm. it seems to be a bug. Maybe as a workaround, you can try doing below
```
SELECT TIMESTAMPADD(HOUR,time_extract(t1.__time,'Hour')
,DATE_TRUNC('DAY',t1.__time)) AS __timestamp,
(max_val1 - min_val1) AS VAL1,
(max_val2 - min_val2) AS VAL2,
(max_val3 - min_val3) AS VAL3,
t1.UID AS UID
FROM
(SELECT __time,
DATE_TRUNC('HOUR', __time) AS truncatedTime,
VAL1 AS max_val1,
UID,
VAL2 AS max_val2,
VAL3 AS max_val3
FROM one_month
WHERE __time > TIME_PARSE('2020-09-26','yyyy-MM-dd')
and __time in
(SELECT MAX(__time)
FROM one_month
WHERE __time > TIME_PARSE('2020-09-26','yyyy-MM-dd')
GROUP BY TIMESTAMPADD(HOUR,time_extract(__time,'Hour')
,DATE_TRUNC('DAY',__time)) ,
UID) ) AS t1
INNER JOIN
(SELECT __time ,
DATE_TRUNC('HOUR', __time) AS truncatedTime,
VAL1 AS min_val1,
UID,
VAL2 AS min_val2,
VAL3 AS min_val3
FROM one_month
WHERE __time > TIME_PARSE('2020-09-26','yyyy-MM-dd')
and __time in
(SELECT MIN(__time)
FROM one_month
WHERE __time > TIME_PARSE('2020-09-26','yyyy-MM-dd')
GROUP BY TIMESTAMPADD(HOUR,time_extract(__time,'Hour')
,DATE_TRUNC('DAY',__time)) ,
UID) ) AS t2 ON t1.truncatedTime =t2.truncatedTime AND
t1.UID = t2.UID
```
----------------------------------------------------------------
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.
For queries about this service, please contact Infrastructure at:
[email protected]
---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]
