# Subquery is failing on SQL Server

**URL:** <https://community.dremio.com/t/subquery-is-failing-on-sql-server/2164>\
**Category:** Uncategorized\
**Created:** [November 2, 2018, 9:09pm UTC](https://community.dremio.com/t/subquery-is-failing-on-sql-server/2164 "2018-11-02T21:09:02Z")\
**Posts on this page:** 8\
**Page:** 1

<div class="post-metadata">

**Author:** ![bharath\_natarajan](https://avatars.discourse-cdn.com/v4/letter/b/94ad74/32.png) [@bharath\_natarajan](https://community.dremio.com/u/bharath_natarajan)\
**Post date:** [November 2, 2018, 9:09pm UTC](https://community.dremio.com/t/subquery-is-failing-on-sql-server/2164/1 "2018-11-02T21:09:02Z")

</div>

SELECT a.orderid,a.orderdate,a.productname,a.companyname,a.region,a.categoryname,a.quantity,a.unitprice,a.sales\_revenue,a.discount  
FROM Northwind.“Logical Schema”.NORTHWIND\_DATA\_MODEL a  
where  
a.categoryname in (‘Beverages’,‘Condiments’,‘Confections’,‘Dairy Products’,‘Produce’,‘Seafood’)  
and a.orderid in (select b.orderid from Northwind.“Reports”.“European Orders” b)

Here is error

Node [rel#351726:Subset#43.LOGICAL.ANY([]).[]] could not be implemented; planner state:  
Root: rel#351726:Subset#43.LOGICAL.ANY([]).[]

---

<div class="post-metadata">

**Author:** ![akikax](https://avatars.discourse-cdn.com/v4/letter/a/ee7513/32.png) [@akikax](https://community.dremio.com/u/akikax)\
**Post date:** [November 3, 2018, 2:24am UTC](https://community.dremio.com/t/subquery-is-failing-on-sql-server/2164/2 "2018-11-03T02:24:11Z")

</div>

If I were you, I would rewrite the logic of that query to use a join clause…

---

<div class="post-metadata">

**Author:** ![bharath\_natarajan](https://avatars.discourse-cdn.com/v4/letter/b/94ad74/32.png) [@bharath\_natarajan](https://community.dremio.com/u/bharath_natarajan)\
**Post date:** [November 3, 2018, 4:55am UTC](https://community.dremio.com/t/subquery-is-failing-on-sql-server/2164/3 "2018-11-03T04:55:18Z")

</div>

True, it can be written as a join. But there are cases where I need subquery to work. Just wondering if Dremio can support subqueries like this…

---

<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:** [November 3, 2018, 5:15pm UTC](https://community.dremio.com/t/subquery-is-failing-on-sql-server/2164/4 "2018-11-03T17:15:31Z")

</div>

Which version of Dremio is that? And I assume that’s SQL server?

---

<div class="post-metadata">

**Author:** ![bharath\_natarajan](https://avatars.discourse-cdn.com/v4/letter/b/94ad74/32.png) [@bharath\_natarajan](https://community.dremio.com/u/bharath_natarajan)\
**Post date:** [November 3, 2018, 6:20pm UTC](https://community.dremio.com/t/subquery-is-failing-on-sql-server/2164/5 "2018-11-03T18:20:59Z")

</div>

It is sql server and dremio 3.0

---

<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:** [November 4, 2018, 1:54pm UTC](https://community.dremio.com/t/subquery-is-failing-on-sql-server/2164/6 "2018-11-04T13:54:32Z")

</div>

Hi @bharath_natarajan

We certainly support subqueries but just discovered an issue with our planner that generates the above error in a subquery. We have an internal ticket already filed for this to get this sorted out and will have it fixed in one of the upcoming releases

Thanks  
@balaji.ramaswamy

---

<div class="post-metadata">

**Author:** ![Monika\_Goel](https://avatars.discourse-cdn.com/v4/letter/m/258eb7/32.png) [@Monika\_Goel](https://community.dremio.com/u/Monika_Goel)\
**Post date:** [November 21, 2018, 7:02pm UTC](https://community.dremio.com/t/subquery-is-failing-on-sql-server/2164/7 "2018-11-21T19:02:52Z")

</div>

Hi @balaji.ramaswamy

I am also getting same error in Dremio 3.0C edition as well as with 2.1.6C version with IN sub-query.

Is it known issue for 2.1.6C version as well?

---

<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:** [November 21, 2018, 7:29pm UTC](https://community.dremio.com/t/subquery-is-failing-on-sql-server/2164/8 "2018-11-21T19:29:47Z")

</div>

Hi . @Monika_Goel

Yes, it is a known issue in 2.1.6 as well

Thanks  
@balaji.ramaswamy