Hi,How can I create a partitioned orc table with sorted field(s)? I tried to use sorted by keyword, but failed parse exception>
CREATE TABLE peoplesort (name string, age int) partition by (bddate int) SORTED BY (age) stored as orc
Is it possible to have some sorted columns? From hive ddl page, it seems only bucket table can be sorted.
Any suggestions please BR, Patcharee