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

["Kevin Risden (JIRA)" <ji...@apache.org>]

    [ https://issues.apache.org/jira/browse/CALCITE-2206?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16436729#comment-16436729 ] 

Kevin Risden commented on CALCITE-2206:
---------------------------------------

[~julianhyde] and [~Pavel Gubin]

It looks like this change is causing test failures in org.apache.calcite.test.JdbcAdapterTest.

I was looking at CALCITE-2063 and keep seeing a bunch of failures. I checked out commit 000622daf9af011b88022b4679dd08c7d09f1475 just before this one and the test case passes. For reference there are failures in Travis (https://travis-ci.org/apache/calcite/jobs/365902521) and Apache Jenkins (https://builds.apache.org/job/Calcite-Master/251/jdk=JDK%201.8%20(latest),label_exp=ubuntu&&!cloud-slave/consoleFull)

For reference here is the command I was running to reproduce the failures:
{code:java}
mvn clean test -Dtest=JdbcAdapterTest -DfailIfNoTests=false -pl core -am{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
>             Fix For: 1.17.0
>
>
> 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)