# Replacement for twitter river to import data from mysql

**URL:** <https://discuss.elastic.co/t/replacement-for-twitter-river-to-import-data-from-mysql/53096>\
**Category:** Elasticsearch\
**Created:** [June 17, 2016, 6:25am UTC](https://discuss.elastic.co/t/replacement-for-twitter-river-to-import-data-from-mysql/53096 "2016-06-17T06:25:12Z")\
**Posts on this page:** 9\
**Page:** 1

<div class="post-metadata">

**Author:** ![megha\_gowda](https://avatars.discourse-cdn.com/v4/letter/m/7bcc69/32.png) [@megha\_gowda](https://discuss.elastic.co/u/megha_gowda)\
**Post date:** [June 17, 2016, 6:25am UTC](https://discuss.elastic.co/t/replacement-for-twitter-river-to-import-data-from-mysql/53096/1 "2016-06-17T06:25:13Z")

</div>

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

---

<div class="post-metadata">

**Author:** ![dadoonet](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/dadoonet/32/137187_2.png) [@dadoonet](https://discuss.elastic.co/u/dadoonet)\
**Post date:** [June 17, 2016, 6:38am UTC](https://discuss.elastic.co/t/replacement-for-twitter-river-to-import-data-from-mysql/53096/2 "2016-06-17T06:38:27Z")

</div>

I think you meant jdbc river.

Logstash jdbc input  
JDBC Importer for elasticsearch: [https://github.com/jprante/elasticsearch-jdbc](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/](http://david.pilato.fr/blog/2015/05/09/advanced-search-for-your-legacy-application/)

---

<div class="post-metadata">

**Author:** ![megha\_gowda](https://avatars.discourse-cdn.com/v4/letter/m/7bcc69/32.png) [@megha\_gowda](https://discuss.elastic.co/u/megha_gowda)\
**Post date:** [June 17, 2016, 6:52am UTC](https://discuss.elastic.co/t/replacement-for-twitter-river-to-import-data-from-mysql/53096/3 "2016-06-17T06:52:07Z")

</div>

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

---

<div class="post-metadata">

**Author:** ![dadoonet](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/dadoonet/32/137187_2.png) [@dadoonet](https://discuss.elastic.co/u/dadoonet)\
**Post date:** [June 17, 2016, 7:07am UTC](https://discuss.elastic.co/t/replacement-for-twitter-river-to-import-data-from-mysql/53096/4 "2016-06-17T07:07:22Z")

</div>

Yes you can.

---

<div class="post-metadata">

**Author:** ![megha\_gowda](https://avatars.discourse-cdn.com/v4/letter/m/7bcc69/32.png) [@megha\_gowda](https://discuss.elastic.co/u/megha_gowda)\
**Post date:** [June 17, 2016, 8:11am UTC](https://discuss.elastic.co/t/replacement-for-twitter-river-to-import-data-from-mysql/53096/5 "2016-06-17T08:11:10Z")

</div>

is there any documentation available for how logstash can be configured on [windows.as](http://windows.as) all links talk about linux.

---

<div class="post-metadata">

**Author:** ![dadoonet](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/dadoonet/32/137187_2.png) [@dadoonet](https://discuss.elastic.co/u/dadoonet)\
**Post date:** [June 17, 2016, 9:10am UTC](https://discuss.elastic.co/t/replacement-for-twitter-river-to-import-data-from-mysql/53096/6 "2016-06-17T09:10:19Z")

</div>

Download. Unzip. Launch.

Basically that's it.

---

<div class="post-metadata">

**Author:** ![jprante](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/jprante/32/44941_2.png) [@jprante](https://discuss.elastic.co/u/jprante)\
**Post date:** [June 17, 2016, 9:28am UTC](https://discuss.elastic.co/t/replacement-for-twitter-river-to-import-data-from-mysql/53096/7 "2016-06-17T09:28:32Z")

</div>

You can still use my JDBC importer to import data from MySQL

> **[jprante/elasticsearch-jdbc](https://github.com/jprante/elasticsearch-jdbc/)**
>
> elasticsearch-jdbc - JDBC importer for Elasticsearch

It runs in a separate Java VM. You have to build Windows scripts for yourself to make it run.

---

<div class="post-metadata">

**Author:** ![megha\_gowda](https://avatars.discourse-cdn.com/v4/letter/m/7bcc69/32.png) [@megha\_gowda](https://discuss.elastic.co/u/megha_gowda)\
**Post date:** [June 30, 2016, 10:06am UTC](https://discuss.elastic.co/t/replacement-for-twitter-river-to-import-data-from-mysql/53096/8 "2016-06-30T10:06:46Z")

</div>

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.

---

<div class="post-metadata">

**Author:** ![system](https://us1.discourse-cdn.com/elastic/original/3X/1/a/1ac57faf039f6b580b3f104ef42a2a89e41014de.png) [@system](https://discuss.elastic.co/u/system)\
**Post date:** [July 5, 2017, 10:39pm UTC](https://discuss.elastic.co/t/replacement-for-twitter-river-to-import-data-from-mysql/53096/9 "2017-07-05T22:39:16Z")

</div>