[jira] [Resolved] (HIVE-11049) With Clause should cache data & reuse

["Jesus Camacho Rodriguez (JIRA)" <ji...@apache.org>]

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

Jesus Camacho Rodriguez resolved HIVE-11049.
--------------------------------------------
    Resolution: Duplicate

Closing as duplicate of HIVE-11752. Full integration with CBO is still a pending task; but support for _spool_ operators needs to be added to Calcite first.

> With Clause should cache data & reuse 
> --------------------------------------
>
>                 Key: HIVE-11049
>                 URL: https://issues.apache.org/jira/browse/HIVE-11049
>             Project: Hive
>          Issue Type: Improvement
>            Reporter: Laljo John Pullokkaran
>            Assignee: Jesus Camacho Rodriguez
>             Fix For: 1.3.0
>
>
> Hive supports with clause. However Hive don't cache the result set of with clause and reuse it.
> Instead we inline the query definition of the with clause. This results in re execution of with clause query every where it is referenced.



--
This message was sent by Atlassian JIRA
(v6.3.4#6332)