Dear Wiki user,
You have subscribed to a wiki page or wiki category on "Hadoop Wiki" for change notification.
The "Hive/ViewDev" page has been changed by JohnSichi.
http://wiki.apache.org/hadoop/Hive/ViewDev?action=diff&rev1=12&rev2=13
--------------------------------------------------
'''Update 30-Dec-2009''': Based on a design review meeting, we're going to go with the
flat model. Prasad pointed out that in the future, for materialized views, we may need the
view definition to be tracked at the partition level as well, so that when we change the view
definition, we don't have to discard existing materialized partitions if the new view result
can be derived from the old one. So it may make sense to add the view definition as a new
attribute of StorageDescriptor (since that is already present at both table and partition
level).
- '''Update 20-Jan-2010''': After further discussion with Prasad, we decided to put the view
definition on the table object instead; for details, see JIRA.
+ '''Update 20-Jan-2010''': After further discussion with Prasad, we decided to put the view
definition on the table object instead; for details, see discussion in [[https://issues.apache.org/jira/browse/HIVE-972|HIVE-972]].
Also, per [[https://issues.apache.org/jira/browse/HIVE-1068|HIVE-1068]], we added an attribute
to store the type (view, managed table, external table) for each table descriptor.
== Dependency Tracking ==
@@ -192, +192 @@
AND PARAM_KEY='EXTERNAL'
AND PARAM_VALUE='TRUE'
);
- UPDATE TBLS SET TBL_TYPE='VIRTUAL_VIEW'
- WHERE VIEW_ORIGINAL_TEXT IS NOT NULL;
}}}
For MySQL, note that the "safe updates" feature will need to be disabled since these are
full-table updates.