can i know the alternative for twitter river to import data from mysql server for lasticsearch-2.3.0
I think you meant jdbc river.
Logstash jdbc input
JDBC Importer for elasticsearch: https://github.com/jprante/elasticsearch-jdbc
And my favorite one: direct connection from the application... http://david.pilato.fr/blog/2015/05/09/advanced-search-for-your-legacy-application/
ya i meant jdbc river and can i use logstash on windows.
Yes you can.
is there any documentation available for how logstash can be configured on windows.as all links talk about linux.
Download. Unzip. Launch.
Basically that's it.
You can still use my JDBC importer to import data from MySQL
It runs in a separate Java VM. You have to build Windows scripts for yourself to make it run.
this is my query
$json='{
"query":
{
"bool":
{
"must":[
{
"bool":
{
"should":[
{
"bool":{
"must":[
{
"term":{
"Keywords": "'.$keyword1.'",
"operator":"and"
}
},
{
"term":{
"TEST_PLAN_NAME": "'.$keyword1.'",
"operator":"and"
}
}
]
}
}
]
}
},
{
"bool":
{
"should":[
{
"bool":{
"must":[
{
"term":{
"Keywords": "'.$keyword2.'",
"operator":"and"
}
},
{
"term":{
"TEST_PLAN_NAME": "'.$keyword2.'",
"operator":"and"
}
}
]
}
}
]
}
}
]
}
}
}';
here keyword1 is my first word for example brown dog which is queried against keywords field or test_plan_name_field.keyword2 is my second keyword for example lazy fox which is queried against keyword field or test_plan_name field.I want brown and dog both words to be present in either keywords or test_plan _name field and there should be and logic between keyword1 and keyword2.That is brown dog and lazy fox.but its givivng me zero hit.i am using standard analyzer.