Hive Sort By Table optimization

[Cristian Giha <Cr...@equifax.com>]

Hi,

I am trying to understand how I can use effectively the SORT BY clause on a clustered table. For example, when I am creating a table, I am using the clause

Create external table TEST(...)
Clustered By (id) Into "N" buckets
...

So, I am putting data from another  table with a clause Select id, ... from another_table cluster by(id). It's work okey, I don't understand what improvements I have when I add the

Clustered By (id) Sorted by(ID) Into "N" buckets

Or maybe sorted by a second column. It's only for Join table queries or  has its another optimizations?

Regards.

Cristian Giha Sepúlveda