Changes
Jump to navigation
Jump to search
← Older edit
Newer edit →
Reusing Open Food Facts Data
(view source)
Revision as of 09:01, 26 November 2024
9 bytes removed
,
26 November
m
→DuckDB to query the database
Line 198:
Line 198:
==== DuckDB to query the database ====
==== DuckDB to query the database ====
Here again, this great tool allows to request remote parquet files with the command line.
Here again, this great tool allows to request remote parquet files with the command line.
−
$ duckdb :memory: "SELECT * from 'https://huggingface.co/datasets/openfoodfacts/product-database/resolve/main/food
<nowiki/>
.parquet' LIMIT 10;"
+
$ duckdb :memory: "SELECT * from 'https://huggingface.co/datasets/openfoodfacts/product-database/resolve/main/food.parquet' LIMIT 10;"
The request can be a bit long (~15 seconds).
The request can be a bit long (~15 seconds).
Raphael0202
Bureaucrats
,
Interface administrators
,
Suppressors
,
Administrators
123
edits
Navigation menu
Personal tools
Log in
Namespaces
Page
Discussion
Variants
Views
Read
View source
View history
More
Search
Navigation
Log in
Open Food Facts galaxy
📍Where am I?
🍊Open Food Facts website
Open Food Facts wiki
Main page
Recent changes
Random page
🧴 Open Beauty Facts wiki
Main page
Deep dive per topic
All topics
Whole wiki
Help about MediaWiki
Icons in the wiki
Tools
Special pages
Printable version
Admins
Edit sidebar
Styling
Replace text
Special Pages