[
https://issues.apache.org/jira/browse/CALCITE-2441?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16654324#comment-16654324
]
Andrei Sereda commented on CALCITE-2441:
----------------------------------------
{quote}
Should RelBuilder be able to expand views?
{quote}
Quite often {{RelBuilder}} is being used as API to generate SQL. Since views
are expanded for standard queries why not for {{RelBuilder}} ?
> 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)
