Pavel Gubin created CALCITE-2206:

             Summary: Window functions pushed to JDBC databases regardless of 
their support
                 Key: CALCITE-2206
             Project: Calcite
          Issue Type: Bug
          Components: jdbc-adapter
    Affects Versions: 1.15.0
            Reporter: Pavel Gubin
            Assignee: Julian Hyde

Queries containing window functions fail when using HSQLDB (or any other DB 
that does not support window functions) because optimiser 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"

This message was sent by Atlassian JIRA

Reply via email to