Home | About | Sematext search-lucene.com search-hadoop.com
NEW: Monitor These Apps!
elasticsearch, apache solr, apache hbase, hadoop, redis, casssandra, amazon cloudwatch, mysql, memcached, apache kafka, apache zookeeper, apache storm, ubuntu, centOS, red hat, debian, puppet labs, java, senseiDB
 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 are using non-string partition columns in production as well.

Thanks,
Aniket

On Sat, May 26, 2012 at 1:20 AM, Philip Tromans
<[EMAIL PROTECTED]>wrote:

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

--
"...:::Aniket:::... Quetzalco@tl"
NEW: Monitor These Apps!
elasticsearch, apache solr, apache hbase, hadoop, redis, casssandra, amazon cloudwatch, mysql, memcached, apache kafka, apache zookeeper, apache storm, ubuntu, centOS, red hat, debian, puppet labs, java, senseiDB