Hi ,
My conf file look like this .
input {
jdbc {
.....
statement => "Select userId as id,UserID
as userid,firstName as firstname, lastName as lastname,countryCode
as countrycode,countryName
as countryname,bid
as bid, isUser as isuser From Internal "
}
filter{
elasticsearch {
hosts => ["localhost:9200"]
enable_sort => false
index => "country"
query => "countryname:%{[countryname]} AND countryid:%{[countrycode]}"
fields => [["regionid", "regionid"]]
}
}
I have been getting the following error
Failed to query elasticsearch for previous event {:index=>"country", :error=>"[404] {"error":{"root_cause":[{"type":"index_not_found_exception","reason":"no such index [country]","resource.type":"index_or_alias"
Any help would be highly appreciated.