Unexpected results are returned for
SELECT...GROUP BY queries that include columns assigned the following data types:
In a typical database, each field – the intersection of row and column – contains an individual value.
SETQ data types are designed to contain an array of comma-separated values within each field.
- data does not need to be normalized into separate tables, and
- import/ingest actions are faster because there are less rows to import.
SETQ data return unexpected results:
SELECT...DISTINCTreturns the number of fields, not the number of unique values
SELECT...GROUP BYreturns the array of values in each field