Group by time with unixtime in elasticsearch

Elastic Stack Elasticsearch
1

Hi all, I've imported data from mysql into elasticsearch that has a date field with unixtime format(such as: 1514851200). I want to group by date with this field.
i had using query:
"histogram": {
"field": "sentdate",
"interval": 86400,
}
But it not correct, Please help me. Thanks a lot!

2

What is your mapping?

3

Hi David Pilato,
I'm using default mapping

4

Use a date data type instead.

1 Like
5

Thanks David so much

6

This topic was automatically closed 28 days after the last reply. New replies are no longer allowed.