Line 4:
Line 4:
We assume that you've downloaded the <code>food.parquet</code> file locally, and that you've launched Duckdb CLI. (see [[Reusing Open Food Facts Data#Parquet file hosted on Hugging Face .28beta.29|Reusing Open Food Facts Data]])
We assume that you've downloaded the <code>food.parquet</code> file locally, and that you've launched Duckdb CLI. (see [[Reusing Open Food Facts Data#Parquet file hosted on Hugging Face .28beta.29|Reusing Open Food Facts Data]])
+
+
==== Creating a new parquet file for my country ====
+
COPY (
+
SELECT * FROM 'food.parquet'
+
WHERE 'en:canada' IN food.countries_tags
+
)
+
TO 'off-canada.parquet' (FORMAT 'parquet', COMPRESSION 'zstd');
==== Display product name (for main language) of all products of with category <code>en:butters</code> ====
==== Display product name (for main language) of all products of with category <code>en:butters</code> ====