Tables stored as ORC files use table properties to control their behavior. By using table properties, the table owner ensures that all clients store data with the same options.
| Key | Default | Notes |
|---|---|---|
| orc.compress | ZLIB | high level compression = {NONE, ZLIB, SNAPPY} |
| orc.compress.size | 262,144 | compression chunk size |
| orc.stripe.size | 67,108,864 | memory buffer in bytes for writing |
| orc.row.index.stride | 10,000 | number of rows between index entries |
| orc.create.index | true | create indexes? |
| orc.bloom.filter.columns | "" | comma separated list of column names |
| orc.bloom.filter.fpp | 0.05 | bloom filter false positive rate |
For example, to create an ORC table without high level compression:
CREATE TABLE istari (
name STRING,
color STRING
) STORED AS ORC TBLPROPERTIES ("orc.compress"="NONE");
There are many Hive configuration properties related to ORC files: