Can Hive optimizer take advantage of tables CLUSTERED BY … SORTED BY … when performing aggregations or analytic functions (window aggregations)? If so, how?
more details at SO: optimize Hive table storage for subsequent Aggregations and/or Window Analytic Functions <http://stackoverflow.com/questions/27001856>
