AVRO is a row-based storage format whereas PARQUET is a columnar based storage format.
PARQUET is much better for analytical querying i.e. reads and querying are much more efficient than writing.
Write operations in AVRO are better than in PARQUET.
AVRO is much matured than PARQUET when it comes to schema evolution. PARQUET only supports schema append whereas AVRO supports a much-featured schema evolution i.e. adding or modifying columns.
PARQUET is ideal for querying a subset of columns in a multi-column table. AVRO is ideal in case of ETL operations where we need to query all the columns.
