Re: Running and Sliding on Aggregates

2010-11-18 Thread Michael Roessler
Thanks Jeff. I'll add something to the JIRA case. I'm after what I think are fairly common use cases, such as: create table corporate_expenses(cost_center INT, fiscal_date STRING, expense_amount DOUBLE); given tab-delimited file data.txt: SALES 20101118 39392020 SALES

Re: Running and Sliding on Aggregates

2010-11-16 Thread Jeff Hammerbacher
Hey Michael, I unfortunately can't tell you how to get around this limitation, but I can point you to the JIRA issue that attempts to capture the requirements: https://issues.apache.org/jira/browse/HIVE-896. If you could describe your use case there, we can capture it for posterity in hope that so