[jira] [Updated] (CALCITE-2206) JDBC adapter incorrectly pushes windowed aggregates down to HSQLDB

2018-04-11 Thread Julian Hyde (JIRA)

 [ 
https://issues.apache.org/jira/browse/CALCITE-2206?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
 ]

Julian Hyde updated CALCITE-2206:
-
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:
{code:sql}
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"
{code}

  was:
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:
{code:sql}
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"
{code}


> JDBC adapter incorrectly pushes windowed aggregates down to HSQLDB
> --
>
> Key: CALCITE-2206
> URL: https://issues.apache.org/jira/browse/CALCITE-2206
> Project: Calcite
>  Issue Type: Bug
>  Components: jdbc-adapter
>Affects Versions: 1.15.0
>Reporter: Pavel Gubin
>Assignee: Julian Hyde
>Priority: Major
>
> 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:
> {code:sql}
> 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"
> {code}



--
This message was sent by Atlassian JIRA
(v7.6.3#76005)


[jira] [Updated] (CALCITE-2206) JDBC adapter incorrectly pushes windowed aggregates down to HSQLDB

2018-04-11 Thread Julian Hyde (JIRA)

 [ 
https://issues.apache.org/jira/browse/CALCITE-2206?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
 ]

Julian Hyde updated CALCITE-2206:
-
Summary: JDBC adapter incorrectly pushes windowed aggregates down to HSQLDB 
 (was: Queries with window functions fail when using HSQLDB)

> JDBC adapter incorrectly pushes windowed aggregates down to HSQLDB
> --
>
> Key: CALCITE-2206
> URL: https://issues.apache.org/jira/browse/CALCITE-2206
> Project: Calcite
>  Issue Type: Bug
>  Components: jdbc-adapter
>Affects Versions: 1.15.0
>Reporter: Pavel Gubin
>Assignee: Julian Hyde
>Priority: Major
>
> 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:
> {code:sql}
> 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"
> {code}



--
This message was sent by Atlassian JIRA
(v7.6.3#76005)