[ 
https://issues.apache.org/jira/browse/HIVE-91?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=12658080#action_12658080
 ] 

Johan Oskarsson commented on HIVE-91:
-------------------------------------

Do you mean something along the lines of:
ALTER TABLE table_name ADD PARTITIONS (partition_col = '2008/12/04', 
another='spain') location ('/wherever/2008/12/04/spain')

That would certainly work for our case and looks like a cleaner solution.

> Allow external tables with different partition directory structure
> ------------------------------------------------------------------
>
>                 Key: HIVE-91
>                 URL: https://issues.apache.org/jira/browse/HIVE-91
>             Project: Hadoop Hive
>          Issue Type: Improvement
>          Components: Metastore
>            Reporter: Johan Oskarsson
>            Assignee: Johan Oskarsson
>            Priority: Minor
>
> 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.

-- 
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.

Reply via email to