In which scenario might Apache ORC be preferred over Apache Parquet?
Select an answer to reveal the explanation.
Short Explanation and Infographic
Apache ORC was developed within the Hadoop/Hive ecosystem and includes native ACID transaction support for Hive; making it the preferred format for Hive-managed tables; while Parquet has broader cross-engine support.
Full explanation below image
Full Explanation
Apache ORC was developed within the Hadoop/Hive ecosystem and includes native ACID transaction support for Hive; making it the preferred format for Hive-managed tables; while Parquet has broader cross-engine support. The incorrect options ("When the workload is primarily Presto or Trino SQL analytics", "When data must be read by Python pandas without a special reader", "When files must be human-readable without any decoding") are distractors that don't fully capture the concept described.