Re: ALTER TABLE xyz RECOVER PARTITIONS not working ...

2015-02-11 Thread praveen akinapally
Hi Joshua, MSCK REPAIR TABLE source_system; will work. Thanks and Regards, Praveen Akinapally. On Mon, Feb 2, 2015 at 8:42 AM, Joshua Eldridge wrote: > I'm hoping someone else has had this problem. I tried searching, but > couldn't find anything ... > > I'm running

Re: Window Function with Ignore Nulls?

2015-02-11 Thread praveen akinapally
Hi Hulbert, Select id, last_value(address,true) over (partition by id order by file_date) as address from address_table; works in Hive 0.13.1. Not sure about Hive 0.11. Try and let me know. Regards, Praveen Akinapally On Fri, Dec 19, 2014 at 5:43 AM, Hulbert, Leland wrote: >