# Query joining multiple datasources does not return

**URL:** https://community.dremio.com/t/query-joining-multiple-datasources-does-not-return/753
**Category:** Uncategorized
**Created:** [February 13, 2018, 5:43am UTC](https://community.dremio.com/t/query-joining-multiple-datasources-does-not-return/753 "2018-02-13T05:43:36Z")
**Posts on this page:** 6
**Page:** 1

<div class="post-metadata">

### Author: ![HLNA](https://avatars.discourse-cdn.com/v4/letter/h/f1d935/32.png) [@HLNA](https://community.dremio.com/u/HLNA)
#### Post date: [February 13, 2018, 5:43am UTC](https://community.dremio.com/t/query-joining-multiple-datasources-does-not-return/753/1 "2018-02-13T05:43:36Z")

</div>

I am just doing a simple query in which I am joining the same small table (40 records) in different datasources.

The qry is like this:-  
SELECT a.\*  
FROM a JOIN b ON [a.id](http://a.id) = [b.id](http://b.id)  
join c ON [a.id](http://a.id) = [c.id](http://c.id) (… and all other datasources)  
WHERE [a.id](http://a.id) = 6666;

The server.log is stuck at this step  
turn\_items e ON c.item\_id = e.item\_id\nWHERE c.item\_id = 51551446;",“start”:1518500045745,“finish”:1518500045759,“outcome”:“FAILED”,“username”:“admin”,“commandDescription”:""}  
2018-02-12 21:34:12,904 [FABRIC-rpc-event-queue] INFO c.d.s.e.rpc.CoordToExecHandlerImpl - Received remote fragment start instruction for 257d872d-7195-b63c-1275-f4d26b21f100:0:0  
2018-02-12 21:34:12,916 [FABRIC-rpc-event-queue] INFO c.d.s.e.rpc.CoordToExecHandlerImpl - Received remote fragment start instruction for 257d872d-7195-b63c-1275-f4d26b21f100:1:0  
2018-02-12 21:34:12,925 [FABRIC-rpc-event-queue] INFO c.d.s.e.rpc.CoordToExecHandlerImpl - Received remote fragment start instruction for 257d872d-7195-b63c-1275-f4d26b21f100:2:0  
2018-02-12 21:34:14,120 [e1 - 257d872d-7195-b63c-1275-f4d26b21f100:frag:2:0] INFO c.d.s.e.f.FragmentStatusReporter - 257d872d-7195-b63c-1275-f4d26b21f100:2:0: State to report: FINISHED

---

<div class="post-metadata">

### Author: ![can](https://sea2.discourse-cdn.com/flex020/user_avatar/community.dremio.com/can/32/40_2.png) [@can](https://community.dremio.com/u/can)
#### Post date: [February 13, 2018, 9:16pm UTC](https://community.dremio.com/t/query-joining-multiple-datasources-does-not-return/753/2 "2018-02-13T21:16:03Z")

</div>

@HLNA could you share the [query profile](https://www.dremio.com/tutorials/share-query-profile/) please?

---

<div class="post-metadata">

### Author: ![HLNA](https://avatars.discourse-cdn.com/v4/letter/h/f1d935/32.png) [@HLNA](https://community.dremio.com/u/HLNA)
#### Post date: [February 14, 2018, 5:57am UTC](https://community.dremio.com/t/query-joining-multiple-datasources-does-not-return/753/3 "2018-02-14T05:57:07Z")

</div>

Can is it possible to share the profile privately, without the forum?

---

<div class="post-metadata">

### Author: ![kelly](https://sea2.discourse-cdn.com/flex020/user_avatar/community.dremio.com/kelly/32/11_2.png) [@kelly](https://community.dremio.com/u/kelly)
#### Post date: [February 14, 2018, 1:34pm UTC](https://community.dremio.com/t/query-joining-multiple-datasources-does-not-return/753/4 "2018-02-14T13:34:21Z")

</div>

Yes, you can mail to can @ [dremio.com](http://dremio.com)

---

<div class="post-metadata">

### Author: ![HLNA](https://avatars.discourse-cdn.com/v4/letter/h/f1d935/32.png) [@HLNA](https://community.dremio.com/u/HLNA)
#### Post date: [February 15, 2018, 3:35am UTC](https://community.dremio.com/t/query-joining-multiple-datasources-does-not-return/753/5 "2018-02-15T03:35:10Z")

</div>

@kelly@can

Atached is another query profile. This is causing considerable frustration as sometimes these queries work and sometimes they don’t work. I am using redshift jdbc url replacing postgres jdbc, I am using same mariadb (as its supplied in dremio), I have checked both mysql servers for wait\_timeout which is 28800

Help Appreciated!  
[5cff6d55-dddf-4ddd-b507-5512db6dd7f1.zip](https://us1.discourse-cdn.com/flex020/uploads/dremio/original/1X/f4b5fe7bf87277af49f5a80c61ec249274b28503.zip) (12.3 KB)

---

<div class="post-metadata">

### Author: ![balaji.ramaswamy](https://sea2.discourse-cdn.com/flex020/user_avatar/community.dremio.com/balaji.ramaswamy/32/843_2.png) [@balaji.ramaswamy](https://community.dremio.com/u/balaji.ramaswamy)
#### Post date: [February 15, 2018, 6:12am UTC](https://community.dremio.com/t/query-joining-multiple-datasources-does-not-return/753/6 "2018-02-15T06:12:08Z")

</div>

Hi @HLNA

This seems like a know issue (Could not send query: unexpected end of exception) that we already have an internal bug created. How often is this exception happening? In other words is it consistently reproducible?

Thanks,  
@balaji.ramaswamy
