https://community.cloudera.com/t5/Archives-of-Support-Questions/What-size-of-tables-make-the-best-out-of-ORC-format/m-p/96726#M10279 <P>Is there any particular size of the Hive table from where ORC table shows better performance compared to other types [especially text]? User is planning to have the default stripe size.</P> Mon, 09 Nov 2015 11:02:32 GMT vpoornalingam 2015-11-09T11:02:32Z https://community.cloudera.com/t5/Archives-of-Support-Questions/What-size-of-tables-make-the-best-out-of-ORC-format/m-p/96726#M10279 <P>Is there any particular size of the Hive table from where ORC table shows better performance compared to other types [especially text]? User is planning to have the default stripe size.</P> Mon, 09 Nov 2015 11:02:32 GMT https://community.cloudera.com/t5/Archives-of-Support-Questions/What-size-of-tables-make-the-best-out-of-ORC-format/m-p/96726#M10279 vpoornalingam 2015-11-09T11:02:32Z https://community.cloudera.com/t5/Archives-of-Support-Questions/What-size-of-tables-make-the-best-out-of-ORC-format/m-p/96727#M10280 <P>Regarding table size, it can be tunned using stripe size, compress size and indexes, see this documentation: <A target="_blank" href="http://orc.apache.org/docs/hive-config.html">http://orc.apache.org/docs/hive-config.html</A></P><P>About performance, I believe ORC will have better performance than text files in most of the situations, but I would say Avro or SequenceFile will have a better performance for queries/use cases that needs full scans with all the columns (in tables with lots of columns). There might be an overhead for ORC to rebuild lines with lots and lots of columns.</P> Mon, 09 Nov 2015 21:32:03 GMT https://community.cloudera.com/t5/Archives-of-Support-Questions/What-size-of-tables-make-the-best-out-of-ORC-format/m-p/96727#M10280 gbraccialli3 2015-11-09T21:32:03Z