Hi David!!, Thanks a lot for your answer. Concerning your question I just
run the command:
GET /_river/_search
{
"query": {
"match_all": {}
}
}
and I 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.168.20.27: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",
"type": "customers",
"strategy": "oneshot"
}
}
}
]
}
}
Anyway if I change the name of the index for example by "my_index_name",
have the same result in the new index.
In advance thanks for your interest to help me.
Regards.
Jorge von Rudno
2014-06-25 11:04 GMT+02:00 David Pilato <[email protected]>:
> How did you run your search?
> By any chance did you search in _river index?
>
>
>
> --
> *David Pilato* | *Technical Advocate* | *Elasticsearch.com*
> @dadoonet <https://twitter.com/dadoonet> | @elasticsearchfr
> <https://twitter.com/elasticsearchfr>
>
>
> Le 25 juin 2014 à 11:00:08, Jorge von Rudno (
> [email protected]) a écrit:
>
> 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 [email protected].
>
> 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 a topic in the
> Google Groups "elasticsearch" group.
> To unsubscribe from this topic, visit
> https://groups.google.com/d/topic/elasticsearch/ULC8-xaimLs/unsubscribe.
> To unsubscribe from this group and all its topics, send an email to
> [email protected].
> To view this discussion on the web visit
> https://groups.google.com/d/msgid/elasticsearch/etPan.53aa9091.2eb141f2.9da9%40MacBook-Air-de-David.local
> <https://groups.google.com/d/msgid/elasticsearch/etPan.53aa9091.2eb141f2.9da9%40MacBook-Air-de-David.local?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 [email protected].
To view this discussion on the web visit
https://groups.google.com/d/msgid/elasticsearch/CAFqKu%3DZvWmzFFxwGYQ9wWb9D%3DmgsjAGu%2BG%3DRJXd_rAq4pKhq%2Bw%40mail.gmail.com.
For more options, visit https://groups.google.com/d/optout.
