File formats supported by Presto

Question

What are file formats supported by Presto? Is there any specific file formats recommended for better performance. I would be interested to know if there is any columnar file format like RCfile that's optimized for Presto?

Answer 1

We test every Trino (formerly PrestoSQL) release with Parquet, ORC, RCFile, Avro, SequenceFile, TextFile, and other formats, but Presto should support any standard Hadoop file format. At Facebook most of our data is in ORC format, so currently this format has the best performance on Presto.