In the use of the Kibana plug-in Discover feature, there are two shortcuts for "filter in" (finding data that matches this value) and "filter out" (excluding data that matches this value), and when working with date data, you are prompted with the following error:
Discover:failed to parse Date field [975542400000] with format [Year_month_day]
failed to parse date field [975542400 with format [Year_month_day]
As a hint, it should be an error that the mapping of the index cannot parse the data, the front-end committed data is in integer (long) format, but the background is parsed as a string.
The workaround is simple and modifies how dates are mapped in the index:
"Birthday": {
"type": "Date",
"format": "strict_date_optional_time| | Epoch_millis "
},
With the support of this mapping format, when inserting data, the date format can be "2017/07/07", and the integer data is also supported in the Ajax submission method of Kibana.
In addition, during the creation of the data map, it is important to note the difference between index and word breaker (analyze), data that is not indexed will not be retrieved, and in the case of dates, if no index is created, the timeline will not be created in Kibana. Conclusion
Data retrieval and visualization is only the external presentation of big data, and the index mapping pattern and inline relation are the soul of big data.