Data is there in ElasticSearch indexed using jprante river plugin. https://github.com/jprante/elasticsearch-jdbc
Kibana was able to search data successfully yesterday. Started my machine today, Kibana unable to read indexed data with No results found on Discover screen.
http://localhost:9200/_mapping?pretty=true
{
".kibana" : {
"mappings" : {
"config" : {
"properties" : {
"buildNum" : {
"type" : "long"
},
"defaultIndex" : {
"type" : "string"
}
}
},
"index-pattern" : {
"properties" : {
"customFormats" : {
"type" : "string"
},
"fields" : {
"type" : "string"
},
"intervalName" : {
"type" : "string"
},
"timeFieldName" : {
"type" : "string"
},
"title" : {
"type" : "string"
}
}
},
"dashboard" : {
"properties" : {
"description" : {
"type" : "string"
},
"hits" : {
"type" : "integer"
},
"kibanaSavedObjectMeta" : {
"properties" : {
"searchSourceJSON" : {
"type" : "string"
}
}
},
"panelsJSON" : {
"type" : "string"
},
"title" : {
"type" : "string"
},
"version" : {
"type" : "integer"
}
}
},
"visualization" : {
"properties" : {
"description" : {
"type" : "string"
},
"kibanaSavedObjectMeta" : {
"properties" : {
"searchSourceJSON" : {
"type" : "string"
}
}
},
"savedSearchId" : {
"type" : "string"
},
"title" : {
"type" : "string"
},
"version" : {
"type" : "integer"
},
"visState" : {
"type" : "string"
}
}
},
"search" : {
"properties" : {
"columns" : {
"type" : "string"
},
"description" : {
"type" : "string"
},
"hits" : {
"type" : "integer"
},
"kibanaSavedObjectMeta" : {
"properties" : {
"searchSourceJSON" : {
"type" : "string"
}
}
},
"sort" : {
"type" : "string"
},
"title" : {
"type" : "string"
},
"version" : {
"type" : "integer"
}
}
}
}
},
"ded" : {
"mappings" : {
"TradeLicenseAudit" : {
"properties" : {
"CAT_NAME" : {
"type" : "string"
},
"DOC_TYPE" : {
"type" : "string"
},
"PASSPORT_NO" : {
"type" : "string"
},
"PRTDATE" : {
"type" : "date",
"format" : "dateOptionalTime"
},
"PRTEVENT" : {
"type" : "string"
},
"PRTREMARK" : {
"type" : "string"
},
"PRTTIME" : {
"type" : "date",
"format" : "dateOptionalTime"
},
"PRTUSER" : {
"type" : "string"
},
"TRADELICENSE_NO" : {
"type" : "long"
},
"TRANSACTION_NO" : {
"type" : "long"
}
}
}
}
},
"ded2" : {
"mappings" : {
"TradeLicenseAudit2" : {
"properties" : {
"CAT_NAME" : {
"type" : "string",
"index" : "not_analyzed"
},
"DOC_TYPE" : {
"type" : "string",
"index" : "not_analyzed"
},
"PASSPORT_NO" : {
"type" : "string"
},
"PRTDATE" : {
"type" : "date",
"format" : "dateOptionalTime"
},
"PRTEVENT" : {
"type" : "string"
},
"PRTREMARK" : {
"type" : "string"
},
"PRTTIME" : {
"type" : "date",
"format" : "dateOptionalTime"
},
"PRTUSER" : {
"type" : "string"
},
"TRADELICENSE_NO" : {
"type" : "long"
},
"TRANSACTION_NO" : {
"type" : "long"
}
}
}
}
}
}