Re: max() returns NULL on partition column

2013-04-22 Thread Robin Morris
Thanks for confirming that I wasn't imagining this. Turns out this was a known bug (HIVE-2955 https://issues.apache.org/jira/browse/HIVE-2955 ) and is already fixed in version 0.10.0 Robin On 4/22/13 11:25 AM, "Mike Liddell" wrote: >Robin, >I was interested so tried a quick repro. Yes I see th

RE: max() returns NULL on partition column

2013-04-22 Thread Mike Liddell
Robin, I was interested so tried a quick repro. Yes I see the behavior too. Environment: hive-0.9.0 on windows. Hive> CREATE TABLE ptable(val int) PARTITIONED BY(year int, month int, day int); Hive> LOAD DATA LOCAL INPATH d:/data/2013-01-01.data.txt INTO TABLE ptable PARTITION(2013,1,1); // the