Re: Hive sort by using a single reducer

2012-09-02 Thread Binesh Gummadi
Thanks for your quick reply. Rank is a column which has integer data. I am writing to dynamoDB database tho. Not sure why only a single reducer is used tho. I will check sql with explain command again and will report my findings. I will check your implementation too. --

Re: Hive sort by using a single reducer

2012-09-02 Thread Edward Capriolo
Sort by does not have the single reduce restriction. Not sure which rank you are using but any one should allow you to sort and rank if the query is written correctly. Our implementation on my github.com/edwardcaprioloallows this. On Sunday, September 2, 2012, Binesh Gummadi wrote: > I am trying t

Re: Load XML file into HIVE

2012-09-02 Thread Sadananda Hegde
Thanks, Matt. We might go with 'flattening' option. I was hoping I can do it using XPATH without need for any custom coding. Regards, Sadu On Thu, Aug 30, 2012 at 6:25 PM, Matt Tucker wrote: > Hi, > > I was working on this several months ago, and ended up having to flatten > each XML document to