Replacement for twitter river to import data from mysql

Elastic Stack Elasticsearch
1

can i know the alternative for twitter river to import data from mysql server for lasticsearch-2.3.0

2

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/

3

ya i meant jdbc river and can i use logstash on windows.

4

Yes you can.

5

is there any documentation available for how logstash can be configured on windows.as all links talk about linux.

6

Download. Unzip. Launch.

Basically that's it.

7

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.

8

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.