# Elastic to csv using logstash

**URL:** <https://discuss.elastic.co/t/elastic-to-csv-using-logstash/110103>\
**Category:** Logstash\
**Created:** [December 4, 2017, 8:52am UTC](https://discuss.elastic.co/t/elastic-to-csv-using-logstash/110103 "2017-12-04T08:52:17Z")\
**Posts on this page:** 6\
**Page:** 1

<div class="post-metadata">

**Author:** ![Shekhar\_Pandey](https://avatars.discourse-cdn.com/v4/letter/s/7ab992/32.png) [@Shekhar\_Pandey](https://discuss.elastic.co/u/Shekhar_Pandey)\
**Post date:** [December 4, 2017, 8:52am UTC](https://discuss.elastic.co/t/elastic-to-csv-using-logstash/110103/1 "2017-12-04T08:52:17Z")

</div>

I use the following conf file to import data from elasticsearch to csv using logstash...  
input {  
elasticsearch {  
hosts =\> "localhost:9200"  
index =\> "croma"  
query =\> '  
{"query":  
{  
"match\_phrase" : {  
"search\_data.full\_text\_boosted": "laptop bag "  
}  
}  
}'  
}  
}  
output {  
csv {  
fields =\> ["full\_text\_boosted","scores"]  
path =\> "/root/sam/csv-export.csv"  
}  
}

I also installed following logstash plugin...  
logstash-input-elasticsearch  
logstash-output-csv

But it giving the following error...  
WARNING: Could not find logstash.yml which is typically located in $LS\_HOME/config or /etc/logstash. You can specify the path using --path.settings. Continuing using the defaults  
Could not find log4j2 configuration at path /usr/share/logstash/config/log4j2.properties. Using default config which logs errors to the console

Any body can tell me where I am wrong?  
Thanks

---

<div class="post-metadata">

**Author:** ![JKhondhu](https://avatars.discourse-cdn.com/v4/letter/j/ed655f/32.png) [@JKhondhu](https://discuss.elastic.co/u/JKhondhu)\
**Post date:** [December 5, 2017, 9:18am UTC](https://discuss.elastic.co/t/elastic-to-csv-using-logstash/110103/2 "2017-12-05T09:18:56Z")

</div>

> [@Shekhar\_Pandey](#):
>
> WARNING: Could not find logstash.yml which is typically located in $LS\_HOME/config or /etc/logstash.

Hi,  
What does your directory structure look like? Where is logstash bin and config on your file system?

---

<div class="post-metadata">

**Author:** ![Shekhar\_Pandey](https://avatars.discourse-cdn.com/v4/letter/s/7ab992/32.png) [@Shekhar\_Pandey](https://discuss.elastic.co/u/Shekhar_Pandey)\
**Post date:** [December 6, 2017, 5:27am UTC](https://discuss.elastic.co/t/elastic-to-csv-using-logstash/110103/3 "2017-12-06T05:27:53Z")

</div>

Thanks for replying...it's working with match but not working with match\_phrase...any reason...

---

<div class="post-metadata">

**Author:** ![warkolm](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/warkolm/32/39224_2.png) [@warkolm](https://discuss.elastic.co/u/warkolm)\
**Post date:** [December 6, 2017, 5:38am UTC](https://discuss.elastic.co/t/elastic-to-csv-using-logstash/110103/4 "2017-12-06T05:38:28Z")

</div>

> [@Shekhar\_Pandey](#):
>
> But it giving the following error...
> 
> WARNING: Could not find logstash.yml which is typically located in $LS\_HOME/config or /etc/logstash. You can specify the path using --path.settings. Continuing using the defaults
> 
> Could not find log4j2 configuration at path /usr/share/logstash/config/log4j2.properties. Using default config which logs errors to the console

That's a warning, not an error, and you can safely ignore this.

---

<div class="post-metadata">

**Author:** ![Shekhar\_Pandey](https://avatars.discourse-cdn.com/v4/letter/s/7ab992/32.png) [@Shekhar\_Pandey](https://discuss.elastic.co/u/Shekhar_Pandey)\
**Post date:** [December 6, 2017, 5:47am UTC](https://discuss.elastic.co/t/elastic-to-csv-using-logstash/110103/5 "2017-12-06T05:47:52Z")

</div>

Thanks warkolm for your kind suggestion.

---

<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:** [January 3, 2018, 5:47am UTC](https://discuss.elastic.co/t/elastic-to-csv-using-logstash/110103/6 "2018-01-03T05:47:54Z")

</div>

This topic was automatically closed 28 days after the last reply. New replies are no longer allowed.