[HIVE-91] Allow external tables with different partition directory structure

• Type: Improvement
• Status: Closed
• Priority: Minor
• Resolution: Fixed
• Fix Version/s: 0.3.0
• Component/s: Metastore
• Hadoop Flags: Reviewed
• Assignee: Johan Oskarsson
• Reporter: Johan Oskarsson
• Created: 01/Dec/08 17:45
• Updated: 15/Jun/12 22:50
• Resolved: 22/Jan/09 20:14

Description

A lot of users have datasets in a directory structures similar to this in hdfs: /dataset/yyyy/MM/dd/<one or more files>
Instead of loading these into Hive the normal way it would be useful to create an external table with the /dataset location and then one partition per yyyy/mm/dd. This would require the partition "naming to directory"-function to be made more flexible.

Issue Links

• breaks: HIVE-3148 LOCATION clause is not honored when adding multiple partitions
• incorporates: HIVE-115 Command for adding partition without loading data
• is blocked by: HIVE-126 Don't fetch information on Partitions from HDFS instead of MetaStore