Changes

Jump to navigation Jump to search
208 bytes added ,  15:14, 11 December 2024
Add section "creating a new parquet file for my country"
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> ====

Navigation menu