You did not specify an index for the JDBC river to index to, so it assumes the index name is "jdbc".
It means, if you search curl '0:9200/jdbc/_search' you should see some of the indexed documents. Jörg On Wed, Jun 25, 2014 at 11:00 AM, Jorge von Rudno < jorge.vonrudno...@googlemail.com> wrote: > Dear colleagues, > > I just start to work with ES and after read the documentation, I am trying > to load the data from my postgres db. To do this I found that the plugin > river jdbc should be work for this purpose. > After following the instruction to install the plugin, I run the following > command and my expectation is to have the whole data in the index created > for river: > > curl -XPUT 'http://localhost:9200/_river/customers/_meta' -d' > { > "type" : "jdbc", > "jdbc" : { > "url" : "jdbc:postgresql://192.100.10.17:5432/customers", > "user" : "postgres", > "password" : "", > "sql" : "SELECT ba.customernumber, ba.company, ba.address, > ba.zipcode, ba.city, ba.telefon, ba.telefax, ba.latitude, ba.longitude, > rd.status, branchenid, kb.mainbranch, sort FROM basis ba LEFT JOIN > aditionaldata rd ON ba.customernumber = rd.customernumber LEFT JOIN > customerbranch AS kb ON ba.customernumber = kb.customernumber WHERE ba.main > = 1 AND rd.status != 5", > "strategy" : "oneshot" > } > }' > > After run the command I get the notification message: > > {"_index":"_river","_type":"customers","_id":"_meta","_version":1,"created":true} > > As I say before I was expecting to get all the data but if I make a query > I just get: > > { > "took": 1, > "timed_out": false, > "_shards": { > "total": 1, > "successful": 1, > "failed": 0 > }, > "hits": { > "total": 1, > "max_score": 1, > "hits": [ > { > "_index": "_river", > "_type": "customers", > "_id": "_meta", > "_score": 1, > "_source": { > "type": "jdbc", > "jdbc": { > "url": "jdbc:postgresql://192.100.10.17:5432/kunden", > "user": "postgres", > "password": "", > "sql": "SELECT ba.customernumber, ba.company, > ba.address, ba.zipcode, ba.city, ba.telefon, ba.telefax, ba.latitude, > ba.longitude, rd.status, branchenid, kb.mainbranch, sort FROM basis ba LEFT > JOIN aditionaldata rd ON ba.customernumber = rd.customernumber LEFT JOIN > customerbranch AS kb ON ba.customernumber = kb.customernumber WHERE ba.main > = 1 AND rd.status != 5", > "strategy": "oneshot" > } > } > } > ] > } > } > > My question is if I just omit something or I am doing something wrong. > > In advance thanks a lot. > > Regards > > Jorge von Rudno > > -- > 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 elasticsearch+unsubscr...@googlegroups.com. > To view this discussion on the web visit > https://groups.google.com/d/msgid/elasticsearch/dafcf553-14fb-4ee9-b52e-380341b3ab1c%40googlegroups.com > <https://groups.google.com/d/msgid/elasticsearch/dafcf553-14fb-4ee9-b52e-380341b3ab1c%40googlegroups.com?utm_medium=email&utm_source=footer> > . > For more options, visit https://groups.google.com/d/optout. > -- 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 elasticsearch+unsubscr...@googlegroups.com. To view this discussion on the web visit https://groups.google.com/d/msgid/elasticsearch/CAKdsXoFV_o4eMnOjgDhs9MxHhnRYN%3D8X3XCd1h6Su7RfB7Lchg%40mail.gmail.com. For more options, visit https://groups.google.com/d/optout.
