https://www.growthbook.io/ logo
b

busy-horse-73824

10/31/2022, 6:55 PM
Something weird happening here, possibly a bug with the query being generated(?)
1
On the latter table, the top 4 lines seem to have duplication - should there only be one row for each variation + dimension combination?
generated query.sql
f

future-teacher-7046

10/31/2022, 6:57 PM
Yes, there should be only 1 row. My guess is there are 2 different dimension values that are both being serialized to an empty string. Like maybe both
null
and an empty string.
b

busy-horse-73824

10/31/2022, 6:58 PM
exp_19g61ol9wwjibq
- welcome to look at it
hmm yeah, the original data type is actually an array - I think it can be an empty array or null
f

future-teacher-7046

10/31/2022, 7:01 PM
I'll add a GitHub issue to fix that in the query by adding an
IFNULL
check (or similar). In the meantime, you can probably add the same to your dimension column to fix the error
b

busy-horse-73824

10/31/2022, 7:06 PM
nice, that fixed it 🙂 thank you