You are viewing a plain text version of this content. The canonical link for it is here.
Posted to issues@calcite.apache.org by "Julian Hyde (JIRA)" <ji...@apache.org> on 2018/10/17 19:44:00 UTC

[jira] [Commented] (CALCITE-2441) Relational algebra doesn't work with SQL views

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

Julian Hyde commented on CALCITE-2441:
--------------------------------------

The workaround for CALCITE-1769 added in order to fix CALCITE-1774 doesn't go far enough: it can create tables but not expand views.

> Relational algebra doesn't work with SQL views
> ----------------------------------------------
>
>                 Key: CALCITE-2441
>                 URL: https://issues.apache.org/jira/browse/CALCITE-2441
>             Project: Calcite
>          Issue Type: Bug
>          Components: core
>            Reporter: Andrei Sereda
>            Assignee: Julian Hyde
>            Priority: Major
>
> Query execution fails when one tries to use [RelBuilder|https://calcite.apache.org/docs/algebra.html] on the top of SQL view:
> {quote}
> Caused by: java.lang.UnsupportedOperationException
>  at org.apache.calcite.plan.RelOptUtil$4.expandView(RelOptUtil.java:2805)
>  at org.apache.calcite.schema.impl.ViewTable.expandView(ViewTable.java:124)
>  ... 36 more
> {quote}



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