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

John Sichi commented on HIVE-972:
---------------------------------

Prasad, regarding select *:  the static expansion semantics are standard and 
work the same way in all of the major DBMS's (Oracle, MySQL, SQL Server, etc).  
The reasoning is that views are often used as insulation layers, so that 
changes to the underlying schema are only exposed in a controlled fashion (i.e. 
an application may start tracking some new internal piece of info about a 
person which is not appropriate to expose via the views accessed by a UI.  In 
systems that support GRANT, privileges are often granted on only a view, not 
the underlying table, so dynamically expanding a view could leak information.  
The counterarguments you make are certainly valid, but since the rules have 
already been set and agreed on by the big guys for a long time in this area, 
probably best to follow them to minimize surprises for users accustomed to the 
standard behavior.


> 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