Changes

Jump to navigation Jump to search
Add an example
Line 96: Line 96:  
  │    15 rows      │
 
  │    15 rows      │
 
  └──────────────────┘
 
  └──────────────────┘
 +
 +
==== Search for a string in a list ====
 +
Eg. search in the list <code>allergen_tags</code> values containing <code>fr:</code>. You have to convert the array into a string using the <code>array_to_string</code>.
 +
SELECT count(code) as nb, ANY_VALUE(code), allergens_tags
 +
  FROM  'food.parquet'
 +
where regexp_matches(array_to_string(allergens_tags, ','), 'fr:')
 +
group by allergens_tags
 +
order by nb desc
    
==== How many images where uploaded in 2024? ====
 
==== How many images where uploaded in 2024? ====

Navigation menu