Hi Gopal
Can you try running with (& see what your query read-perf looks like) > https://gist.github.com/t3rmin4t0r/087b61f79514673c307bb9a88327a4db > > CREATE TABLE IF NOT EXISTS passaggi1718 > ( > ... > ) > PARTITIONED BY (DATAPASSAGGIO string) > CLUSTERED BY (ORAPASSAGGIO) INTO 8 BUCKETS > SORTED BY (ORAPASSAGGIO, ID_TICKETTYPE, ID_PERSONTYPE, NPOOLNR, NKASSANR) > STORED AS ORC > TBLPROPERTIES("orc.compress"="ZLIB"); > > > With such a table, does one need to sort within the INSERT statement too ? Or a simple insert will be automatically sorted as the table DDL mention ? Thanks for clarifications