SELECT ARRAY_DISTINCT ( ARRAY_FLATTEN(ARRAY_AGG(ARRAY tag for tag IN tags WHEN CONTAINS(LOWER(tag),“bird”)END),2 )) tags
FROM content
WHERE ANY tag IN tags SATISFIES ( ANY ae IN SUFFIXES(LOWER(tag)) SATISFIES ae
LIKE “bird%” END) END
AND type = “PUBLICIMAGE” limit 10;
As I am using the above query, I am getting an array called tags with 500 elements inside.I am expecting first 10 elements only of the array.How to query it?
expected result:
[
{
“tags”: [
“Sword-billed hummingbird”,
“Red-tailed tropicbird ( Phaethon rubricauda)”,
“Melodious blackbird”,
“Karyotype for a Female bird”,
“bluebird”,
“Noisy scrub-bird”,
“Crested bellbird”,
“Australian regent bowerbird”,
“Olive-bellied sunbird”,
“Rufous-tailed hummingbird ( Amazilia tzacatl)”
]
}]