Sections
I have a question about the Catch sections.
I have a basic table that is split into a date field. My view is a simple view that makes a selection * from a base table.
My question is, will the view be split when the request is requested by the end user? or do I need to execute any other commands to be able to use sections by view?
I have this question due to the following statement on wiki.apache.org https://cwiki.apache.org/confluence/display/Hive/PartitionedView on this topic, which mentioned:
1. One possible approach, mentioned in HIVE-1079, is to automatically define partitions for partitions based on the partitions of the base tables. A command such as SHOW PARTITIONS can then synthesize the virtual partition descriptors on the fly. This is fairly easy to do for use case # 1, but potentially very difficult to use options # 2 and # 3. So for now, we're doing this approach.
Best regards, Nisha
source to share
In my previous interactions, we used views extensively and all of our tables were split. We relied on the ability of the hive query planner to perform proper partitioning in these views, and this was done successfully. There have actually been a few edge cases / complex scenarios requiring hive Hortonworks source code update. But in general / simpler cases, clipping the partitions worked.
source to share