hive buckets sorted

[#1]

Hi:

what is better sorted or order when i create table like this??

CLUSTERED BY (COD_NRBE)
SORTED BY (ID_INTERNO_PE,MI_FECHA_FIN_MES)
INTO 60 BUCKETS
stored as ORC

[#2 · Accepted solution]

@Roberto Sancho

Hope below post help you to understand the differences.

http://stackoverflow.com/questions/13715044/hive-cluster-by-vs-order-by-vs-sort-by