Apache Hive Performance Tuning
Also available as:
PDF

Advanced ORC properties

Usually, you do not need to modify ORC properties, but occasionally, Hortonworks Support advises making such changes.

Key Default Setting Notes
orc.compress ZLIB Compression type (NONE, ZLIB, SNAPPY).
orc.compress.size 262,144 Number of bytes in each compression block.
orc.stripe.size 268,435,456 Number of bytes in each stripe.
orc.row.index.stride 10,000 Number of rows between index entries (>= 1,000).
orc.create.index true Sets whether to create row indexes.
orc.bloom.filter.columns -- Comma-separated list of column names for which a Bloom filter must be created.
orc.bloom.filter.fpp 0.05 False positive probability for a Bloom filter. Must be greater than 0.0 and less than 1.0.