hadoop-hive-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Johan Oskarsson (JIRA)" <j...@apache.org>
Subject [jira] Commented: (HIVE-91) Allow external tables with different partition directory structure
Date Fri, 19 Dec 2008 13:09:44 GMT

    [ 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.


Mime
View raw message