What is a benefit of creating an external table from Parquet rather than CSV when using a CREATE TABLE AS SELECT statement?
What is a benefit of creating an external table from Parquet rather than CSV when using a CREATE TABLE AS SELECT statement?
Parquet files have the ability to be optimized because they are columnar storage formats designed for large-scale data processing frameworks. This optimization can lead to improved performance, especially in terms of query execution times and storage efficiency. The ability to partition files, have a well-defined schema, and the conversion to Delta tables are useful features, but the key benefit when using a CREATE TABLE AS SELECT statement is the capability of optimization which enhances performance and efficiency.
Parquetare columnar and can be optimized. However, I think the key part is " when using a CREATE TABLE AS SELECT statement?", that's C
D partquet file are columnar and otimised