hive query optimization

Hi all, Some queries in hive are executing for too long.So i have overriden some parameters in hive, for some querys performance increased rapidly when i overriden this properities for some querys no change in performance.Can any one you tell me any other optimizations in hive apart from partitio

Re: Invalid Table Alias

There seems to be something wrong with the query (the red highlighted portion). What is mi in "abs(datediff(mi"? On Sun, Jul 22, 2012 at 11:28 AM, Techy Teck wrote: > Can anyone give some sort of pointers or suggestions why the below query is > giving me exception and the same query works fine in

Re: Invalid Table Alias

Can anyone give some sort of pointers or suggestions why the below query is giving me exception and the same query works fine in SQL server. Below is the SQL fiddle that works in SQL Server- http://sqlfiddle.com/#!3/d87b2/4 On Fri, Jul 20, 2012 at 6:47 PM, Techy Teck wrote: > In hive we canno

Cannot load array of struct using json serde

Hello, If I have posted this question in the wrong mailing list, kindly suggest the right one because I have just joined the group. My JSON is in the following format: {"ProfileId":111,"CustomerId":111,"UserId":222,"DateString":"2011-01-01 14:24:52","Machine":"MyMachine","AppName":"TTT","