Has anyone had any luck using Kibana to create visualizations based on a Search API Index? The index within drupal and views is working flawlessly, and I can also add the index as a pattern and select the time field in Kibana.

However, within the Discover area, it shows that all fields are missing and no data is shown when attempting to create visualizations with the fields.

Any help would be greatly appreciated.

CommentFileSizeAuthor
#4 elasticsearch_connector_date_format.patch660 bytesAndreas Radloff

Comments

NWOM created an issue. See original summary.

nwom’s picture

nwom commented
Title: Help using Kibana » Help using Kibana - Elasticsearch Search API Index

It appears that the watchdog index can be used without problems, and the fields are not "missing". So it appears to only affect my Search API index.

nwom’s picture

nwom commented
Title: Help using Kibana - Elasticsearch Search API Index » Error: failed to parse date field [], tried both date format [date_time], and timestamp number with locale []
Category: Support request » Bug report
Issue summary: View changes
Priority: Normal » Major
Andreas Radloff’s picture

Andreas Radloff commented
Status: Active » Needs review
StatusFileSize
new elasticsearch_connector_date_format.patch660 bytes

I'm using this patch to get my date fields to index, can you try it?

EDIT: Actually I just realized this issue was for 7.x and I'm using Drupal 8 so it probably wont work. I'm using Elasticsearch 2.

Andreas Radloff’s picture

Andreas Radloff commented
Status: Needs review » Active
nwom’s picture

nwom commented
Status: Active » Needs review

@Andreas Radloff
Thanks for trying to help either way. Would you perhaps know what to change in Elasticsearch 1.x for Drupal 7? I'm trying to find a similar line, but haven't had luck so far.

nwom’s picture

nwom commented
Status: Needs review » Active
Andreas Radloff’s picture

Andreas Radloff commented

@NWOM Sorry, don't know, not my module...

nwom’s picture

nwom commented
Title: Error: failed to parse date field [], tried both date format [date_time], and timestamp number with locale [] » Kibana does not work with the Elasticsearch Search API indexes
Issue summary: View changes
Priority: Major » Normal
Status: Active » Closed (duplicate)
Related issues: +#2393885: ElasticSearch expects Milliseconds in Date Format

It appears that Kibana expects date fields' formats to include milliseconds in order to display correctly. However, currently milliseconds are currently not being stored in the index.

The following patch fixes this issue: #2393885: ElasticSearch expects Milliseconds in Date Format

nwom’s picture

nwom commented