QMF 13.1.1 now supports importing and exporting data in the Avro and Parquet file formats. These file formats provide substantial performance improvement while importing and exporting data as compared to the traditional file formats, such as CSV.

User can import Avro and Parquet File formats into QMF from import wizard. Also, user can export generated result set into File system with export type as Avro and Parquet.

Parquet and Avro are popular file formats for storing large datasets. While Parquet is a columnar storage format, Avro is row-based. Each format has its strengths and use cases, making the choice between them context dependent.

Parquet excels in analytics, Avro's strength lies in efficient row-wise operations. Avro is well-suited for frequent read-and-write operations, so it's the best choice when quick data manipulation and updates are required.

File Formats:

-          Avro - Apache Avro (*.avro)

-          Parquet - Apache Parquet (*.parquet)

Illustration:

Import wizard:

Export wizard:

Thank you. Happy reading!

#Db2 #QMF #Db2 for z/OS #Db2tools #Db2 Tools for z/OS #Db2QMF #QMFAvroParquet