RE: Performance problems with Hive script

2012-01-24 Thread Butani, Harish
obs or long scripts of SQL. It's in alpha state; I am looking for users to work with. Regards, Harish. From: Igor Tatarinov [mailto:i...@decide.com] Sent: Monday, January 23, 2012 11:27 PM To: user@hive.apache.org Subject: Re: Performance problems with Hive script To compute moving aver

Re: Performance problems with Hive script

2012-01-23 Thread Igor Tatarinov
To compute moving averages, you should implement a custom reducer instead of doing a big join. That will work *much* faster. Also, Hive already has date_add(). Why did you have to implement your own? https://cwiki.apache.org/confluence/display/Hive/LanguageManual+UDF#LanguageManualUDF-DateFunction