Export Parquet

The COPY TO clause can export query results to a Parquet file. It can be combined with a subquery and used as shown below.

COPY (MATCH (u:User) return u.*) TO 'user.parquet' (compression = 'snappy');

The LOAD FROM clause can be used to scan the Parquet file and to verify that the export worked:

> LOAD FROM 'user.parquet' RETURN *;

┌─────────┬───────┐
│ u.name  │ u.AGE │
│ STRING  │ INT64 │
├─────────┼───────┤
│ Adam    │ 30    │
│ Karissa │ 40    │
│ Zhang   │ 50    │
│ Noura   │ 25    │
└─────────┴───────┘

Available options are:

Option	Default Value	Description
`COMPRESSION`	`SNAPPY`	The compression format to use (uncompressed, snappy, gzip, lz4 or zstd).