Page History

...

With the ability to skip large sets of rows based on filter predicates, you can sort a table on its secondary keys to achieve a big reduction in execution time. For example, if the primary partition is transaction date, the table can be sorted on state, zip code, and last name. Then looking for records in one state will skip the records of all other states.

Hive QL HiveQL Syntax

File formats are specified at the table (or partition) level. You can specify the ORC file format with Hive QL HiveQL statements such as these:

...