Re: Cannot INSERT OVERWRITE on clustered table with > 8 buckets

[Nicolas Paris]

​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