Thanks Stamatis. The link you shared is really helpul.
-Original Message-
From: Stamatis Zampetakis
Sent: Wednesday, January 27, 2021 2:33 AM
To: dev@calcite.apache.org
Subject: [EXTERNAL] Re: Re: Request help in implementing subquery in WHERE
condition
Hi Hrudaya,
In the code you
s.
>
> Regards,
> Hrudaya
>
> -Original Message-
> From: Julian Hyde
> Sent: Tuesday, January 26, 2021 9:25 AM
> To: dev@calcite.apache.org
> Subject: [EXTERNAL] Re: Request help in implementing subquery in WHERE
> condition
>
> Yes; I usually only call bui
help with this.
Regards,
Hrudaya
-Original Message-
From: Julian Hyde
Sent: Tuesday, January 26, 2021 9:25 AM
To: dev@calcite.apache.org
Subject: [EXTERNAL] Re: Request help in implementing subquery in WHERE condition
Yes; I usually only call build() once per RelBuilder program, and leave
Sent: Tuesday, January 26, 2021 1:30 AM
To: dev@calcite.apache.org
Subject: [EXTERNAL] Re: Request help in implementing subquery in WHERE condition
Hi Hrudaya,
Not sure how you display the SQL query and what interleaves the first and
second calls to RelBuilder but note that RelBuilder#build
uot;)
>>.join(JoinRelType.LEFT,
>> relBuilder.equals(
>>relBuilder.field(2, "ja", "user_id"),
>>relBuilder.field(2, "u", "user_id")));
>>
>>relBuilder.project(relBuilder.field(&quo
r.equals(
> relBuilder.field(2, "ja", "user_id"),
> relBuilder.field(2, "u", "user_id")));
>
> relBuilder.project(relBuilder.field("org1", "ref"));
>
> /// When I do additional scans and joins,
uot;, "ref"));
/// When I do additional scans and joins, my query changes to
SELECT [org].[ref]
FROM [req]
LEFT JOIN [org] ON [req].[location_id] = [org].[org_id]
LEFT JOIN [appl] ON [req].[req_id] = [appl].[req_id]
LEFT JOIN [users] ON [appl].[user_id] = [users].[user_id]
I would reall
Hi everyone,
I am trying to implement a subquery in the WHERE condition.
My query is similar to below,
SELECT [org].[ref],
[users].[ref]
FROM [req]
LEFT JOIN [org] ON ([req].[location_id] = [org].[org_id])
LEFT JOIN [appl] ON ([req].[req_id] = [appl].[req_id])
LEFT JOIN [users]