[CALCITE-4279] SEARCH operator cannot be pushed into Druid

• Type: Bug
• Status: Closed
• Priority: Major
• Resolution: Fixed
• Fix Version/s: 1.26.0
• Component/s: druid-adapter
• Labels: pull-request-available
• Assignee: Julian Hyde
• Reporter: Stamatis Zampetakis
• Created: 25/Sep/20 12:41
• Updated: 06/Oct/20 17:16
• Resolved: 01/Oct/20 23:55

Description

CALCITE-4173 and a few other follow ups, introduced a new internal operator, SEARCH, replacing IN-list and BETWEEN in relational expressions. However, the code for handling the transformations to Druid was not updated thus the processing cannot be pushed into Druid.

This is reflected in the IT tests of the Druid adapter where there are about 22 queries with failures at the moment.

Issue Links

• is caused by: CALCITE-4173 Add internal SEARCH operator and Sarg literal, replacing use of IN in RexCall
• is caused by: CALCITE-4237 AssertionError in SqlTypeFactoryImpl.leastRestrictive when running slow tests
• is related to: CALCITE-4278 Add Druid adapter tests in GitHub CI
• relates to: CALCITE-4249 JDBC adapter cannot translate NOT LIKE in join condition
• links to: GitHub Pull Request #2183