I’m trying to add an elasticsearch datasource but can’t get past the Time field name. I tried @timestamp but it doesn’t work. The only time-related field I see in my index is creation_date, which I also tried as @creation_date for time field name but it fails. The error is “no date field named @timestamp found”. What am I missing?
Remove the at symbol, if your field name does not contain it do not use it, the at symbol is not speciall, it just commonly named with at symbol prefix
@sbanik you can use the field whose type is date in elastic search for this mapping. you should use the exact same field name as in the index type.
What if my column is not date type?
Will string type in date format work too???
Does this problem has been solved? I have the same question.
i met with the same issue. after reading grafana doc on elasticsearch datasource, realized that you have to set the index name correctly, you have to enter [index-name]-YYYY.MM.DD in index name field if your index pattern is daily and everyday indexes are like this index-name-2019.10.24.
After setting the index correctly, it is not complaining @timestamp doesn’t exist anymore.
I had the same issue. I had the correct index and Time field name entered. But Grafana didn’t find the date field name.
FIX: Be sure to fill the correct version of Elasticsearch in “Elasticsearch details”
I am having similar problem in loading data to grafana with field name in millisec timestamp format. I don’t have any time object in the data .
I would like to consider that data.dateTime as time for the series. How can i do that? Is there any way to convert before loading?
Its not accepting that nested time timestamp int as time.
@imjvreddy can you please post a sample document from your elasticsearch?
and is the index name /dev or just dev?