[prev in list] [next in list] [prev in thread] [next in thread] 

List:       hadoop-commits
Subject:    =?utf-8?q?=5BHadoop_Wiki=5D_Update_of_=22Hive/ViewDev=22_by_JohnSichi?=
From:       Apache Wiki <wikidiffs () apache ! org>
Date:       2010-01-28 23:39:19
Message-ID: 20100128233919.10600.91687 () eos ! apache ! org
[Download RAW message or body]

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.


[prev in list] [next in list] [prev in thread] [next in thread]