Re: Dynamic partition set to null

2011-02-13 Thread khassounah
Thanks Ryan... that does seem to be my issue. I found the first thread after I sent this email, but not the second thread saying it will be fixed next week. thanks Khaled > You are likely encountering a bug w/ Amazon's S3 code: > https://forums.aws.amazon.com/thread.jspa?threadID=56358&tstart=25

Re: Dynamic partition set to null

2011-02-13 Thread Ryan Huebsch
You are likely encountering a bug w/ Amazon's S3 code: https://forums.aws.amazon.com/thread.jspa?threadID=56358&tstart=25 Try inserting into a non-S3 backed table to see if this is indeed your problem. Based on the Amazon forums they are expected a fix this week: https://forums.aws.amazon.com/

Re: Dynamic partition set to null

2011-02-13 Thread Ning Zhang
Khaled, which version of Hive are you running? I tried a similar query in trunk (0.7.0-SNAPSHOT) and it worked. The error does't mean the data is wrong (ds=null), it means the compiled query plan doesn't indicate it is a dynamic partition (which is very unlikely for this simple query) or the M

Re: Dynamic partition set to null

2011-02-12 Thread khassounah
Hi Pat.. I have hive.exec.dynamic.partition.mode=nonstrict and hive.exec.dynamic.partition=true. That let hive accept the dynamic partitions, but it still fails. Khaled > Check that you have hive.exec.dynamic.partition.mode set to false. That > or have a static partition column first in your par

Re: Dynamic partition set to null

2011-02-12 Thread Christopher, Pat
Check that you have hive.exec.dynamic.partition.mode set to false. That or have a static partition column first in your partitioning clause. Pat -- Sent from my Palm Pre On Feb 12, 2011 11:09 PM, khassou...@mediumware.net wrote: Hello, I have the followin

Dynamic partition set to null

2011-02-12 Thread khassounah
Hello, I have the following table definition (simplified to help in debugging): create external table pvs ( time INT, server STRING, thread_id STRING ) partitioned by ( dt string ) row format delimited fields terminated by '\t' stored as textfile