Hello there i am new to elastic search i am using elasticsearch0.90.0 version . i installed jdbc river plugin and then trying to make river with this command
curl -XPUT http://192.168.1.184:9200/_river/test_raaz_river/_meta -d '
{
"type":"jdbc",
"jdbc": {
"strategy":"simple",
"poll":"1m",
"driver":"org.postgresql.Driver",
"url" : "jdbc:postgresql://192.168.1.105/:5432/saral2",
"user":"laitkor",
"password":"m2n1shlko",
"sql":"select id as _id,mo from testde",
"fetchsize":100
},
"index":{
"index":"rshi",
"type":"mark",
"versioning":true,
"bulk_size":1000,
"acknowledge" : false
}
}'
this command return result ok .
when i am trying command
curl -XGET 'localhost:9200/_river/test_raaz_river/_meta'
it gives result
{"_index":"_river","_type":"test_raaz_river","_id":"_meta","_version":1,"exists":true, "_source" :
{
"type":"jdbc",
"jdbc": {
"strategy":"simple",
"poll":"1m",
"driver":"org.postgresql.Driver",
"url" : "jdbc:postgresql://192.168.1.105/:5432/saral2",
"user":"laitkor",
"password":"m2n1shlko",
"sql":"select id as _id,mo from testde",
"fetchsize":100
},
"index":{
"index":"rshi",
"type":"mark",
"versioning":true,
"bulk_size":1000,
"acknowledge" : false
}
}}
My question is this why i am not able to fetch data is it fine or it should return something else .
Thanks in advance for help