You are viewing a plain text version of this content. The canonical link for it is here.
Posted to user@ignite.apache.org by MJ <67...@qq.com> on 2025/03/17 11:14:42 UTC
sql in clause conversion from H2 to Calcite
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
Re: sql in clause conversion from H2 to Calcite
Posted by MJ <67...@qq.com>.
Thanks. Really looking forward to it.
---Original---
From: "Alex Plehanov"<plehanov.alex@gmail.com>
Date: Mon, Mar 31, 2025 19:12 PM
To: "user"<user@ignite.apache.org>;
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 <6733471@qq.com>:
Ignite 2.16
Thanks,
MJ
Original
From:Stephen Darlington <sdarlington@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 <6733471@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
Re: sql in clause conversion from H2 to Calcite
Posted by Alex Plehanov <pl...@gmail.com>.
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 <67...@qq.com>:
> Ignite 2.16
>
> Thanks,
> MJ
>
> Original
> ------------------------------
> From:Stephen Darlington <sd...@apache.org>
> Sent Time:2025-03-17- 20:00
> To:user <us...@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 <67...@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
>
>
>
Re: sql in clause conversion from H2 to Calcite
Posted by MJ <67...@qq.com>.
Ignite 2.16
Thanks,
MJ
Original
From:Stephen Darlington <sdarlington@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 <6733471@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
Re: sql in clause conversion from H2 to Calcite
Posted by Stephen Darlington <sd...@apache.org>.
Are you using Ignite 2 or Ignite 3?
On Mon, 17 Mar 2025 at 11:15, MJ <67...@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
>