Eden utilise witches.town. Vous pouvez læ suivre et interagir si vous possédez un compte quelque part dans le "fediverse".
Weird presto sql things
MAX(x) is slower than
REDUCE(0.0, array_agg(x), (x,y) -> if(y > x, y, x), x ->x))
If is just a modified version of CASE WHEN, but with only one clause.
All subquery IN statements (Select *from table where column in (Select column from table)) are just inner joins.
Like I love presto, but wtf guys.
Ended up rewriting a chunk of window statements with a single lambda expression yesterday. It's way way faster and I really think the base code either has buttloads of error checks or is just slow af
@edensaesthetic this sounds like good data witchery :3c