orc table with sorted field

[Patcharee Thongtra]

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