Re: non-string partition columns

2012-05-29 Thread Ashutosh Chauhan
s. > > > >On Tue, May 29, 2012 at 4:10 AM, Aniket Mokashi > >wrote: > >> We are using non-string partition columns in production as well. > >> > >> Thanks, > >> Aniket > >> > >> On Sat, May 26, 2012 at 1:20 AM, Philip Tromans >

Re: non-string partition columns

2012-05-29 Thread Namit Jain
:10 AM, Aniket Mokashi >wrote: >> We are using non-string partition columns in production as well. >> >> Thanks, >> Aniket >> >> On Sat, May 26, 2012 at 1:20 AM, Philip Tromans >> wrote: >> >>> We're using non-string partition columns i

Re: non-string partition columns

2012-05-29 Thread Edward Capriolo
We use them to we store our dates as integers like 20120130. This allows us to do partition pruning with ranges. On Tue, May 29, 2012 at 4:10 AM, Aniket Mokashi wrote: > We are using non-string partition columns in production as well. > > Thanks, > Aniket > > On Sat, May 2

Re: non-string partition columns

2012-05-29 Thread Aniket Mokashi
We are using non-string partition columns in production as well. Thanks, Aniket On Sat, May 26, 2012 at 1:20 AM, Philip Tromans 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

Re: non-string partition columns

2012-05-26 Thread Philip Tromans
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&quo

Re: non-string partition columns

2012-05-25 Thread Namit Jain
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" wrote: >Yes, but the meta-question is: > >Is anyone dependent on non-string partition columns ? Should we drop the >

Re: non-string partition columns

2012-05-25 Thread Namit Jain
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" wrote: >Some discussion for this has happened on >https://issues.apache

Re: non-string partition columns

2012-05-24 Thread Ashutosh Chauhan
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 wrote: > Should we disallow non-string partition columns complet

Re: non-string partition columns

2012-05-24 Thread Namit Jain
Should we disallow non-string partition columns completely ? Does anyone depend on that ? On 5/24/12 6:49 PM, "Namit Jain" wrote: > >http://svn.apache.org/viewvc?view=revision&revision=1308427 > >The patch above broke drop partitions if the partition happens to be &g

non-string partition columns

2012-05-24 Thread Namit Jain
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 onl