[CALCITE-2206] JDBC adapter incorrectly pushes windowed aggregates down to HSQLDB

• Type: Bug
• Status: Closed
• Priority: Major
• Resolution: Fixed
• Affects Version/s: 1.15.0
• Fix Version/s: 1.17.0
• Component/s: jdbc-adapter
• Assignee: Julian Hyde
• Reporter: Pavel Gubin
• Created: 07/Mar/18 11:28
• Updated: 20/Jul/18 08:18
• Resolved: 11/Apr/18 07:59

Description

JDBC adapter incorrectly pushes windowed aggregates down to HSQLDB. Queries containing window functions fail when using HSQLDB (or any other DB that does not support window functions) because the optimizer converts them to native SQL with window functions which are not supported by HSQLDB. For example:

select "store_id", "product_id", sum("unit_sales") unit_sales, row_number() over (
partition by "store_id" order by sum("unit_sales") desc
) row_num
from "sales_fact_1998"
group by "store_id", "product_id"

Issue Links

• relates to: CALCITE-2253 Fix matching predicate for JdbcProjectRule rule
• links to: PR 646