Re: sorting in hive -- general

2015-03-09 Thread max scalf
Thank you... On Mon, Mar 9, 2015 at 2:23 AM, r7raul1...@163.com wrote: > read this article > http://www.philippeadjiman.com/blog/2009/12/20/hadoop-tutorial-series-issue-2-getting-started-with-customized-partitioning/ > > > then read > https://cwiki.apache.org/confluence/display/Hive/LanguageManu

Re: sorting in hive -- general

2015-03-09 Thread r7raul1...@163.com
read this article http://www.philippeadjiman.com/blog/2009/12/20/hadoop-tutorial-series-issue-2-getting-started-with-customized-partitioning/ then read https://cwiki.apache.org/confluence/display/Hive/LanguageManual+SortBy r7raul1...@163.com From: max scalf Date: 2015-03-08 07:02 To: HD

Re: sorting in hive -- general

2015-03-07 Thread Alexander Pivovarov
sort by query produces multiple independent files. order by - just one file usually sort by is used with distributed by. In older hive versions (0.7) they might be used to implement local sort within partition similar to RANK() OVER (PARTITION BY A ORDER BY B) On Sat, Mar 7, 2015 at 3:02 PM, ma