[ 
https://issues.apache.org/jira/browse/HIVE-972?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=12793799#action_12793799
 ] 

Namit Jain commented on HIVE-972:
---------------------------------

I think we can go with Lenient Dependency Invalidation - which means that the 
view gets invalid if any DDL happens on the underlying table.
Column level dependencies can be ignored as of now. The view depends on 
persistent objects (other tables and views).

We should support:

alter view <viewname> compile;

The views can be automatically compiled when referenced in a query, but may 
lead to unexpected results for select '*'. So, in the first cut,
we can ask the user to explicitly validate the view.

Other issue is regarding the error messages. If the query is equivalent to: 
select ... from (view-def-select);
will the error positions be correct ?


> support views
> -------------
>
>                 Key: HIVE-972
>                 URL: https://issues.apache.org/jira/browse/HIVE-972
>             Project: Hadoop Hive
>          Issue Type: New Feature
>          Components: Metastore, Query Processor
>            Reporter: Namit Jain
>            Assignee: John Sichi
>
> Hive currently does not support views. 
> It would be a very nice feature to have.

-- 
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.

Reply via email to