# What exactly is \<DREMIO\_COORDINATOR\>

**URL:** <https://community.dremio.com/t/what-exactly-is-dremio-coordinator/87>\
**Category:** Uncategorized\
**Created:** [July 20, 2017, 7:20pm UTC](https://community.dremio.com/t/what-exactly-is-dremio-coordinator/87 "2017-07-20T19:20:25Z")\
**Posts on this page:** 4\
**Page:** 1

<div class="post-metadata">

**Author:** ![supert165](https://avatars.discourse-cdn.com/v4/letter/s/c67d28/32.png) [@supert165](https://community.dremio.com/u/supert165)\
**Post date:** [July 20, 2017, 7:20pm UTC](https://community.dremio.com/t/what-exactly-is-dremio-coordinator/87/1 "2017-07-20T19:20:26Z")

</div>

I’m trying to connect through a jdbc driver and on the docs page ([https://docs.dremio.com/drivers/dremio-jdbc-driver.html](https://docs.dremio.com/drivers/dremio-jdbc-driver.html)) it says to use

jdbc:dremio:direct=\<DREMIO\_COORDINATOR\>:31010

to connect. I have used this URI however I’m not exactly sure what the \<DREMIO\_COORDINATOR\> variable is supposed to be. Is this the name of my node under admin? Am I missing something?

---

<div class="post-metadata">

**Author:** ![laurent](https://sea2.discourse-cdn.com/flex020/user_avatar/community.dremio.com/laurent/32/16_2.png) [@laurent](https://community.dremio.com/u/laurent)\
**Post date:** [July 20, 2017, 7:28pm UTC](https://community.dremio.com/t/what-exactly-is-dremio-coordinator/87/2 "2017-07-20T19:28:44Z")

</div>

Dremio servers can have two roles: coordinator and executor. Coordinator manages the user requests, parse the queries, and executor is in charge of connecting to datasources to execute the query (hence the name).

By default, each Dremio node is both a coordinator and an executor, so you can replace \<DREMIO\_COORDINATOR\> with any hostname. But if you choose to assign roles to your nodes, then you would need to select a node with the coordinator role to connect to.

---

<div class="post-metadata">

**Author:** ![siddteotia](https://sea2.discourse-cdn.com/flex020/user_avatar/community.dremio.com/siddteotia/32/59_2.png) [@siddteotia](https://community.dremio.com/u/siddteotia)\
**Post date:** [July 20, 2017, 7:31pm UTC](https://community.dremio.com/t/what-exactly-is-dremio-coordinator/87/3 "2017-07-20T19:31:30Z")

</div>

It is a node that handles the user requests and coordinates the execution of the query. The coordinator also manages query planning and based on the degree of parallelization in the plan, execution work is farmed out to executor nodes.

---

<div class="post-metadata">

**Author:** ![siddteotia](https://sea2.discourse-cdn.com/flex020/user_avatar/community.dremio.com/siddteotia/32/59_2.png) [@siddteotia](https://community.dremio.com/u/siddteotia)\
**Post date:** [July 20, 2017, 7:32pm UTC](https://community.dremio.com/t/what-exactly-is-dremio-coordinator/87/4 "2017-07-20T19:32:06Z")

</div>

My response crossed with Laurent’s. His response has more details.