gistfile1.json

curl -XPUT http://localhost:9200/_river/test_mysql_river/_meta -d '
{
  "type":"jdbc",
  "jdbc": {
    "strategy":"simple",
    "poll":"1m",
    "driver":"com.mysql.jdbc.Driver",
    "url" : "jdbc:mysql://localhost:3306/ohim",
    "user":"root",
    "password":"",
    "sql":"select idappli as _id,upperdeno,dtcreated from mark",
    "fetchsize":100
  },
  "index":{
    "index":"mysql",
    "type":"mark",
    "versioning":true,
    "bulk_size":1000,
    "acknowledge" : false
  }
}'