Re: non-string partition columns

2012-05-29 Thread Ashutosh Chauhan
FWIW.. HCatalog only allows partition columns of type string precisely because in backend datastore type information is not recorded. In my opinion, partition type should be restricted to type string until we fix this problem, otherwise it gives unexpected behavior to endusers and/or bug-reps. One

Re: non-string partition columns

2012-05-29 Thread Namit Jain
OK, I will keep the support. Add special casing for string columns in DDLTask On 5/29/12 9:27 AM, "Edward Capriolo" wrote: >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

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 26, 2012 at 1:20 AM, Phil

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 sorts > of da

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" wrote: > Should I

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 >support for non-string >p

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.org/jira/browse/HIV

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

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 >non-string. >This is due to a