'Querying the same amount of labels in Presto
I have a field in a table named types and this field can have one or more type value, like this:(they are string inside [] and all between ""
["type1","type2"]
["type1"]
["type3","type4","type11"]
This table has 100 distinct type of types values.
What I need: I want to query this table in a way that I can ensure that I will have the same count of each type value, let's say:
100type1, 100type2,... 100type100
In the above example, I have 2 types1..
Sources
This article follows the attribution requirements of Stack Overflow and is licensed under CC BY-SA 3.0.
Source: Stack Overflow
| Solution | Source |
|---|
