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>: > Ignite 2.16 > > Thanks, > MJ > > Original > ------------------------------ > From:Stephen Darlington <sdarling...@apache.org> > Sent Time:2025-03-17- 20:00 > To:user <user@ignite.apache.org> > 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> wrote: > > Hi, > > Any idea how to convert H2's in clause sql to Calcite version ? 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 > > >
