Here is my mapping:
PUT /_river/fault/_meta
{
"type" : "jdbc",
"jdbc" : {
"url" : "jdbc:postgresql://localhost:5432/gis",
"user" : "test",
"password" : "test",
"sql" : [
{
"statement" : "select latitude as \"location.lat\",longitude \"location.lon\",zone from alarms"
}
],
"index" : "fault",
"type" : "alert_status",
"schedule": "0 0/1 * * * ?"
},
"type_mapping" : {
"alert_status" : {
"properties" : {
"location" : {
"type" : "geo_point",
"lat_lon" : true
}
}
}
}
}
I had posted issue about creating geo_point here.