hadoop-hive-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "John Sichi (JIRA)" <j...@apache.org>
Subject [jira] Commented: (HIVE-972) support views
Date Tue, 22 Dec 2009 20:22:29 GMT

    [ 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.


Mime
View raw message