Re: Dynamic Partition Inserts

2010-08-17 Thread Luke Crouch
Hmm ... any indications of when 0.6 will officially release? This will go to a large-scale production system so we'd like to have a stable official release if possible. Thanks, -L On Mon, Aug 16, 2010 at 11:47 AM, Ning Zhang wrote: > Dynamic partition is supported in hive 0.6+. 0.6 is not offic

Re: Dynamic Partition Inserts

2010-08-16 Thread Ning Zhang
Dynamic partition is supported in hive 0.6+. 0.6 is not officially released yet, but you can find the branch at http://svn.apache.org/repos/asf/hadoop/hive/branches/branch-0.6. Ning On Aug 16, 2010, at 6:39 AM, Luke Crouch wrote: Do I need a certain version of Hive? I'm tried this: > set hive

Re: Dynamic Partition Inserts

2010-08-16 Thread Luke Crouch
Do I need a certain version of Hive? I'm tried this: > set hive.exec.dynamic.partition=true; > set hive.exec.dynamic.partition.mode=nostrict; And still get: 10/08/16 13:37:36 INFO parse.ParseDriver: Parsing command: FROM ( FROM ( SELECT project, file, os, country, dt FROM downloads WHERE dt='201

Re: Dynamic Partition Inserts

2010-08-15 Thread Ning Zhang
p.apache.org>>; mailto:l...@geek.net>> Subject: Re: Dynamic Partition Inserts Project needs to be the last column In the select list Also, you need to set a variable to Enable dynamic prtn inserts Sent from my iPhone On Aug 14, 2010, at 9:46 AM, "Luke Crouch" mailto:lcro.

Re: Dynamic Partition Inserts

2010-08-15 Thread Luke Crouch
t; > Thanks, > -namit > > > From: Namit Jain [nj...@facebook.com] > Sent: Saturday, August 14, 2010 10:38 AM > To: ; > Subject: Re: Dynamic Partition Inserts > > Project needs to be the last column > In the select list > > Also, you need to set a

RE: Dynamic Partition Inserts

2010-08-14 Thread Namit Jain
Partition Inserts Project needs to be the last column In the select list Also, you need to set a variable to Enable dynamic prtn inserts Sent from my iPhone On Aug 14, 2010, at 9:46 AM, "Luke Crouch" wrote: > I'm trying to do a dynamic partition insert like so: > > F

Re: Dynamic Partition Inserts

2010-08-14 Thread Namit Jain
Project needs to be the last column In the select list Also, you need to set a variable to Enable dynamic prtn inserts Sent from my iPhone On Aug 14, 2010, at 9:46 AM, "Luke Crouch" wrote: > I'm trying to do a dynamic partition insert like so: > > FROM ( > FROM ( >

Dynamic Partition Inserts

2010-08-14 Thread Luke Crouch
I'm trying to do a dynamic partition insert like so: FROM ( FROM ( SELECT project, file, os, country, dt FROM test_downloads WHERE dt='2010-06-30' CLUSTER BY project, file, dt ) a SELECT TRANSFORM(project,