[
https://issues.apache.org/jira/browse/HIVE-1941?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=12993791#comment-12993791
]
John Sichi commented on HIVE-1941:
----------------------------------
A use case for a partitioned view on top of an unpartitioned table would be
when the table is an external table (being loaded by some other mechanism) or a
non-native table (e.g. HBase). I think both of these are likely to come up
eventually, so we might as well allow them from day one. The view partition
would be used to indicate that some particular portion of the dataset has been
fully loaded.
I verified that no join case currently works in strict mode because the
predicate does not get pushed down both ways. I will open a followup for that
(it's really something we should be optimizing regardless of views instead of
forcing the user to duplicate the predicate).
If you look at my negative test cases, notice that in strict mode we prevent
the case where the underlying table partitioning is not satisfied by the view.
However, the exception is raised during ADD PARTITION (rather than during
CREATE VIEW) because that's when we compile the dummy query.
Regarding prefixes: as Raghu mentioned for indexing, a prefix would only be
relevant if we move to a hierarchical model for partitioning, which we don't
currently have.
Regarding dependencies, we should work on that after HIVE-1073 is in place to
track them (we need them in the metastore).
> support explicit view partitioning
> ----------------------------------
>
> Key: HIVE-1941
> URL: https://issues.apache.org/jira/browse/HIVE-1941
> Project: Hive
> Issue Type: New Feature
> Components: Query Processor
> Affects Versions: 0.6.0
> Reporter: John Sichi
> Assignee: John Sichi
> Attachments: HIVE-1941.1.patch, HIVE-1941.2.patch, HIVE-1941.3.patch,
> HIVE-1941.4.patch
>
>
> Allow creation of a view with an explicit partitioning definition, and
> support ALTER VIEW ADD/DROP PARTITION for instantiating partitions.
> For more information, see
> http://wiki.apache.org/hadoop/Hive/PartitionedViews
--
This message is automatically generated by JIRA.
-
For more information on JIRA, see: http://www.atlassian.com/software/jira
