I do as doc(here <https://github.com/jprante/elasticsearch-river-jdbc>) 
says,

PUT /_river/my_jdbc_river/_meta -d
{
    "type" : "jdbc",
    "jdbc" : {
        "url" : "jdbc:mysql://localhost:3306/test",
        "user" : "root",
        "password" : "123123",
        "sql" : "select * from test limit 100",
        "index" : "test",
        "type" : "test"
    }
}


GET /test/test/_search?pretty&q=*

result:

{
   "took": 5,
   "timed_out": false,
   "_shards": {
      "total": 5,
      "successful": 5,
      "failed": 0
   },
   "hits": {
      "total": 0,
      "max_score": null,
      "hits": []
   }
}

and es cmd print below msg

[2014-08-02 15:58:14,387][WARN ][river.routing ] [Lynx] no river _meta 
document found after 5 attempts

-- 
You received this message because you are subscribed to the Google Groups 
"elasticsearch" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to [email protected].
To view this discussion on the web visit 
https://groups.google.com/d/msgid/elasticsearch/a55c1a5e-ea43-494c-86c2-569ab16ea65e%40googlegroups.com.
For more options, visit https://groups.google.com/d/optout.

Reply via email to