[CALCITE-2671] GeodeFilter change to transform multiple OR s to use IN SET OQL predicate to significantly improve query performance

• Type: Improvement
• Status: Open
• Priority: Major
• Resolution: Unresolved
• Component/s: geode-adapter
• Assignee: Unassigned
• Reporter: Sandeep Chada
• Created: 14/Nov/18 13:14
• Updated: 22/Feb/19 01:21

Description

In Geode when we are querying thousands of rows using an IN query, IN SET query predicate gives high query performance than multiple OR s.

I am making the change in the GeodeFilter translateMatch function by first checking if IN SET is applicable then only use it, otherwise the multiple OR code is called.