calcite-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Vladimir Sitnikov <sitnikov.vladi...@gmail.com>
Subject Re: Implementing a table that can be queried by index (noob question)
Date Sat, 09 May 2015 21:10:46 GMT
>I can force my query to run with a nestedloop(fullscan,
>indexscan) or would this involve changes to Calcite?

If you put "forceDecorrelate=false" connection property, Calcite will
leave correlations in place.
"Correlate" is Calcite's term for "nested loop"
More details here:
https://github.com/apache/incubator-calcite/blob/e237804b0e4d7ac17249708a5cf823e0c1fe1625/core/src/main/java/org/apache/calcite/rel/core/Correlate.java#L51-60

Then you might want adding rules that swap table access with
correlated index scan.

>I didn't know about the call, but yes, I'd like to join if it is an open
>invite.

That's open. Follow this thread:
http://mail-archives.apache.org/mod_mbox/calcite-dev/201505.mbox/%3CCAB%3DJe-GdhkSbuYm0JF_O0D-Ez7qY8NNbQ%3DQrNwBDdFOA5%2BJQ2Q%40mail.gmail.com%3E

Vladimir

Mime
View raw message