Re: OPTIMIZING A HIVE QUERY

2012-08-14 Thread sudeep tokala
nfluence/display/Hive/LanguageManual+Joins > > > > Regards, > Bejoy KS > > ------ > *From:* sudeep tokala > *To:* user@hive.apache.org > *Sent:* Tuesday, August 14, 2012 11:00 PM > *Subject:* Re: OPTIMIZING A HIVE QUERY > > hi Bertrand, > &

Re: OPTIMIZING A HIVE QUERY

2012-08-14 Thread sudeep tokala
RDMS. You want to keep > a normalized source of data but sometimes 'unnomarlizing' it can greatly > improves your performance. That's one of the advantage of document store. > It is very dependent on your use cases. > > Bertrand > > On Tue, Aug 14, 2012 at 7:30

Re: OPTIMIZING A HIVE QUERY

2012-08-14 Thread sudeep tokala
data which can not be > stored into memory, you need to serialize them. The only solution is to > store the data in a smarter way which would not require you to do the join. > By the way, how do you know the serialisation is the bottleneck? > > Bertrand > > > On Tue, Aug 1

Re: OPTIMIZING A HIVE QUERY

2012-08-14 Thread sudeep tokala
On Tue, Aug 14, 2012 at 11:08 AM, sudeep tokala wrote: > Hi all, > > How to avoid serialization and deserialization overhead in hive join query > ? will this optimize my query performance. > > Regards > sudeep >