123
edits
Changes
Jump to navigation
Jump to search
Line 4:
Line 4: − + − FROM read_parquet('food.parquet') + − WHERE product_name+ − ILIKE '%beurre%';+ + + + + + + +
no edit summary
''Ex: display product name (for main language) of all products of with category '''en:butters'''.
''Ex: display product name (for main language) of all products of with category '''en:butters'''.
SELECT code, product_name
SELECT
code,
unnest(
list_filter (product_name, x -> x.lang = = 'main')
) ['text']
FROM
'food.parquet'
WHERE
list_contains (categories_tags, 'en:milks')
LIMIT
10;';
┌───────────────┬──────────────────────────────────────────────────────────────┐
┌───────────────┬──────────────────────────────────────────────────────────────┐
│ code │ product_name │
│ code │ product_name │