You are viewing a plain text version of this content. The canonical link for it is here.

Posted to user@hive.apache.org by Patcharee Thongtra <Pa...@uni.no> on 2015/10/13 13:27:28 UTC

orc table with sorted field

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