Retrieving data from Database using Elastic search


(srinu konda) #1

Hi,
I am trying to pull data from database using Elastic Search,

I have created below river:

PUT http://localhost:9200/jdbc_river/river1/_meta
{
"type":"jdbc"
"jdbc":
{
"url":"Mysql URL"
"driver":"Mysql driver"
"username":"username"
"password":"XXXXXXX"
"sql":"select * from orders"
}
}

Note:Above code working fine but when am trying to create one more
river(below code) its not working for me

PUT http://localhost:9200/jdbc1/river2/_meta
{
"type":"jdbc1"
"jdbc1":
{
"url":"Mysql URL"
"driver":"Mysql driver"
"username":"username"
"password":"XXXXXXX"
"sql":"select * from employee"
}
}

Please help me, Am trying to display the Elastic Search result using kibana.

Thanks & Regards,
Srinivas.

--
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+unsubscribe@googlegroups.com.
To view this discussion on the web visit https://groups.google.com/d/msgid/elasticsearch/b6e5a3da-06f5-48f4-be43-d5c8f59a33dc%40googlegroups.com.
For more options, visit https://groups.google.com/d/optout.


(David Pilato) #2

Type should be jdbc

--
David :wink:
Twitter : @dadoonet / @elasticsearchfr / @scrutmydocs

Le 18 juin 2014 à 08:18, srinu konda konda.srinu89@gmail.com a écrit :

Hi,
I am trying to pull data from database using Elastic Search,

I have created below river:

PUT http://localhost:9200/jdbc_river/river1/_meta
{
"type":"jdbc"
"jdbc":
{
"url":"Mysql URL"
"driver":"Mysql driver"
"username":"username"
"password":"XXXXXXX"
"sql":"select * from orders"
}
}

Note:Above code working fine but when am trying to create one more river(below code) its not working for me

PUT http://localhost:9200/jdbc1/river2/_meta
{
"type":"jdbc1"
"jdbc1":
{
"url":"Mysql URL"
"driver":"Mysql driver"
"username":"username"
"password":"XXXXXXX"
"sql":"select * from employee"
}
}

Please help me, Am trying to display the Elastic Search result using kibana.

Thanks & Regards,
Srinivas.

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+unsubscribe@googlegroups.com.
To view this discussion on the web visit https://groups.google.com/d/msgid/elasticsearch/b6e5a3da-06f5-48f4-be43-d5c8f59a33dc%40googlegroups.com.
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+unsubscribe@googlegroups.com.
To view this discussion on the web visit https://groups.google.com/d/msgid/elasticsearch/4E2E2666-EFCE-4DCF-9304-1660E534E25E%40pilato.fr.
For more options, visit https://groups.google.com/d/optout.


(system) #3