I’m using SQL Trino trying to count the unique words (ignore any numbers) in a string column.
The column values look like this:
MEDIA_SOCIAL,2336;IDEOLOGY,1442;KIDNAP,601;MED…
I have tried this:
count(distinct v2themes) as themes
which gives me TrinoQueryError(type=INSUFFICIENT_RESOURCES, name=EXCEEDED_GLOBAL_MEMORY_LIMIT…
2