Re: sql in clause conversion from H2 to Calcite

[MJ]

Thanks. Really looking forward to it.



---Original---
From: "Alex Plehanov"<plehanov.a...@gmail.com&gt;
Date: Mon, Mar 31, 2025 19:12 PM
To: "user"<user@ignite.apache.org&gt;;
Subject: Re: sql in clause conversion from H2 to Calcite


Hello,

Calcite engine in Ignite 2.16 can't expand the array parameter to table. It can 
be done with the UNNEST operator, but it's planned for 2.18 Ignite release.


пн, 17 мар. 2025 г. в 15:49, MJ <6733...@qq.com&gt;:

Ignite 2.16


Thanks,
MJ


         Original
         
       
From:Stephen Darlington <sdarling...@apache.org&gt;
Sent Time:2025-03-17- 20:00
To:user <user@ignite.apache.org&gt;
Subject:Re: sql in clause conversion from H2 to Calcite



Are you using Ignite 2 or Ignite 3?

On Mon, 17 Mar 2025 at 11:15, MJ <6733...@qq.com&gt; wrote:
Hi,


Any idea how to convert H2's in clause sql to Calcite version ?&nbsp; For H2, 
the sql - select * from tbl where col in (select col from (table col varchar = 
?)) works well with array objects as parameter . Is there the similar for 
Calcite ?




Thanks,
MJ