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.
