Home | About | Sematext search-lucene.com search-hadoop.com
 Search Hadoop and all its subprojects:

Switch to Threaded View
Hive >> mail # dev >> non-string partition columns


Copy link to this message
-
Re: non-string partition columns
We're using non-string partition columns in production. I think non string
partition columns are a good thing to have - it allows you to do all sorts
of date range calculations etc. AFAIK, MySQL's partition columns can be of
any type.

Phil.
On May 26, 2012 7:55 AM, "Namit Jain" <[EMAIL PROTECTED]> wrote:

> Should I go ahead and file a jira to disallow non-string partition columns
> ?
> Or, someone depends on that functionality.
>
>
> On 5/25/12 10:01 AM, "Namit Jain" <[EMAIL PROTECTED]> wrote:
>
> >Yes, but the meta-question is:
> >
> >Is anyone dependent on non-string partition columns ? Should we drop the
> >support for non-string
> >partition columns ?
> >
> >
> >Thanks,
> >-namit
> >
> >On 5/24/12 11:21 PM, "Ashutosh Chauhan" <[EMAIL PROTECTED]> wrote:
> >
> >>Some discussion for this has happened on
> >>https://issues.apache.org/jira/browse/HIVE-2702 Is the underlying
> problem
> >>same as the one which I described on that jira ?
> >>
> >>Thanks,
> >>Ashutosh
> >>
> >>On Thu, May 24, 2012 at 10:59 PM, Namit Jain <[EMAIL PROTECTED]> wrote:
> >>
> >>> Should we disallow non-string partition columns completely ?
> >>> Does anyone depend on that ?
> >>>
> >>>
> >>> On 5/24/12 6:49 PM, "Namit Jain" <[EMAIL PROTECTED]> wrote:
> >>>
> >>> >
> >>> >http://svn.apache.org/viewvc?view=revision&revision=1308427
> >>> >
> >>> >The patch above broke drop partitions if the partition happens to be
> >>> >non-string.
> >>> >This is due to a JDO issue with non-string columns.
> >>> >
> >>> >Is anyone using non-string partition columns ?
> >>> >Should be force the partition columns to be only of type string ?
> >>> >The documentation probably does not specify anything clearly.
> >>> >
> >>> >If someone is dependent on non-string partition column, we need to
> >>>revert
> >>> >this patch, or make a
> >>> >special case for string partition columns.
> >>> >
> >>> >Thanks,
> >>> >-namit
> >>> >
> >>> >
> >>>
> >>>
> >
>
>