Simple filter failed with "not in" operator

1

Hi.

I just want to filter some date stored with string with some complex request which certain are accelerated and some are prepared in my view with with clause and i encounter an execution error while attempting to use “not in”. 1st time it happens.

refpatr_prec_prefin2 as (
select r3.* from refpatr_prec_prefin1 r3
union
select r2.* from refpatr_prec_oqp r2 where r2.dtearrc not in (select distinct r1.dtearrc from refpatr_prec_prefin1 r1 where r1.noug=r2.noug)
)

In this section i want for the 2nd part of union to get only records which don’t have been gotten with the same date in order to filter duplicate records. But it fails with org.apache.calcite.rel.logical.LogicalFilter cannot be cast to org.apache.calcite.rel.core.Join.

What do u suggest?

Best regards.

deea5a02-20d6-4909-98fc-06bc99d2a880.zip (162,8 Ko)

2

I’ve found 2 other subject with similar error in forum but it seems that there’s no solution since. I’m with Dremio free 20.1.0.

Thx.

3

can you try with last version?

4

@dacopan @The_Yab974 Seems to be still an open bug, let me verify and come back here

5

Hi.

As it’s happening on a production environnement so I need to plan the upgrade test in order to check if it can fix the issue.

Best regards.