Group by time with unixtime in elasticsearch

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!

What is your mapping?

Hi David Pilato,
I'm using default mapping

Use a date data type instead.

1 Like

Thanks David so much

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