didip opened a new issue #11535:
URL: https://github.com/apache/druid/issues/11535
### Affected Version
0.21.1
### Description
I see that we have way more data on the S3 folders but this query returns
way less number of days.
I should already have the full July dates but many of them are missing in my
query.
```sql
SELECT DATE_TRUNC('day', "__time") as "day", SUM("count") as "count"
FROM "mytable" GROUP BY DATE_TRUNC('day', "__time") order by
DATE_TRUNC('day', "__time") DESC
```
**Table:**
... Where's the rest of the days? ...
2021-07-15T00:00:00.000Z 00000000001979009692
... Where's the rest of the days? ...
2021-07-11T00:00:00.000Z 00000000001693378623
... Where's the rest of the days? ...
I also unchecked these 3, but the result is the same:
<img width="353" alt="Screen Shot 2021-08-02 at 4 48 18 PM"
src="https://user-images.githubusercontent.com/72918/127937122-c35fa40a-d420-441c-bb45-e438f7b8db86.png";>
--
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.
To unsubscribe, e-mail: [email protected]
For queries about this service, please contact Infrastructure at:
[email protected]
---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]
![https://user-images.githubusercontent.com/72918/127937122-c35fa40a-d420-441c-bb45-e438f7b8db86.png"](https://user-images.githubusercontent.com/72918/127937122-c35fa40a-d420-441c-bb45-e438f7b8db86.png"){kind=link}