# Logging ES queries in elasticsearch-spark-30

**URL:** <https://discuss.elastic.co/t/logging-es-queries-in-elasticsearch-spark-30/302435>\
**Category:** Elasticsearch\
**Tags:** es-hadoop\
**Created:** [April 14, 2022, 1:27pm UTC](https://discuss.elastic.co/t/logging-es-queries-in-elasticsearch-spark-30/302435 "2022-04-14T13:27:35Z")\
**Posts on this page:** 3\
**Page:** 1

<div class="post-metadata">

**Author:** ![sergeyka](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/sergeyka/32/100185_2.png) [@sergeyka](https://discuss.elastic.co/u/sergeyka)\
**Post date:** [April 14, 2022, 1:27pm UTC](https://discuss.elastic.co/t/logging-es-queries-in-elasticsearch-spark-30/302435/1 "2022-04-14T13:27:35Z")

</div>

Is there a way to log Elasticsearch queries issued by the `elasticsearch-spark-30_2.12` library?

What I tried:

1. Setting everything to `trace` log level. URLs of requests sent to Elasticsearch were printed, but not the body of the POST requests. Since all the query was in the body this hardly helps.
2. Enabling logging as documented for Elasticsearch High-Level Java Client, i.e. setting `logging.level.tracer=TRACE`. That did not produce any results.

---

<div class="post-metadata">

**Author:** ![Keith\_Massey](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/keith_massey/32/83666_2.png) [@Keith\_Massey](https://discuss.elastic.co/u/Keith_Massey)\
**Post date:** [April 15, 2022, 2:03pm UTC](https://discuss.elastic.co/t/logging-es-queries-in-elasticsearch-spark-30/302435/2 "2022-04-15T14:03:48Z")

</div>

I haven't tried it yet, but I believe if you set `org.elasticsearch.hadoop.rest.commonshttp.CommonsHttpTransport` logging to trace for your spark tasks it will log out the request body. [elasticsearch-hadoop/CommonsHttpTransport.java at master · elastic/elasticsearch-hadoop · GitHub](https://github.com/elastic/elasticsearch-hadoop/blob/master/mr/src/main/java/org/elasticsearch/hadoop/rest/commonshttp/CommonsHttpTransport.java#L676)

---

<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:** [May 13, 2022, 2:04pm UTC](https://discuss.elastic.co/t/logging-es-queries-in-elasticsearch-spark-30/302435/3 "2022-05-13T14:04:12Z")

</div>

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