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

Jiang Xingbo updated SPARK-18801:
---------------------------------
    Description: 
We should be able to resolve a nested view. The main advantage is that if you 
update an underlying view, the current view also gets updated.
The new approach should be compatible with older versions of SPARK/HIVE, that 
means:
        1. The new approach should be able to resolve the views that created by 
older versions of SPARK/HIVE;
        2. The new approach should be able to resolve the views that are 
currently supported by SPARK SQL.

The new approach mainly brings in the following changes:
        1. Add a new operator called `View` to keep track of the CatalogTable 
that describes the view, and the output attributes as well as the child of the 
view;
        2. Update the `ResolveRelations` rule to resolve the relations and 
views, note that a nested view should be resolved correctly;
        3. Add `AnalysisContext` to enable us to still support a view created 
with CTE/Windows query.

  was:
We should be able to resolve a nested view. The main advantage is that if you 
update an underlying view, the current view also gets updated.
The new approach should be compatible with older versions of SPARK/HIVE, that 
means:
        1. The new approach should be able to resolve the views that created by 
older versions of SPARK/HIVE;
        2. The new approach should be able to resolve the views that are 
currently supported by SPARK SQL.

The new approach mainly brings in the following changes:
        1. Add a new operator called `View` to keep track of the CatalogTable 
that descripts the view, and the output attributes as well as the child of the 
view;
        2. Update the `ResolveRelations` rule to resolve the relations and 
views, note that a nested view should be resolved correctly;
        3. Add `AnalysisContext` to enable us to still support a view created 
with CTE/Windows query.


> Add `View` operator to help resolve a view
> ------------------------------------------
>
>                 Key: SPARK-18801
>                 URL: https://issues.apache.org/jira/browse/SPARK-18801
>             Project: Spark
>          Issue Type: Sub-task
>          Components: SQL
>            Reporter: Jiang Xingbo
>
> We should be able to resolve a nested view. The main advantage is that if you 
> update an underlying view, the current view also gets updated.
> The new approach should be compatible with older versions of SPARK/HIVE, that 
> means:
>       1. The new approach should be able to resolve the views that created by 
> older versions of SPARK/HIVE;
>       2. The new approach should be able to resolve the views that are 
> currently supported by SPARK SQL.
> The new approach mainly brings in the following changes:
>       1. Add a new operator called `View` to keep track of the CatalogTable 
> that describes the view, and the output attributes as well as the child of 
> the view;
>       2. Update the `ResolveRelations` rule to resolve the relations and 
> views, note that a nested view should be resolved correctly;
>       3. Add `AnalysisContext` to enable us to still support a view created 
> with CTE/Windows query.



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

---------------------------------------------------------------------
To unsubscribe, e-mail: issues-unsubscr...@spark.apache.org
For additional commands, e-mail: issues-h...@spark.apache.org

Reply via email to