Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- INSERT INTO some_cube_analytics(count, filter1, filter2, filter3, filter4, filter5, filter6)
- SELECT
- count(*) as count,
- filter1,
- filter2,
- filter3,
- filter4,
- filter5,
- filter6
- FROM some_table
- GROUP BY
- ROLLUP(filter1, filter2),
- CUBE(filter3, filter4, filter5, filter6)
- ON CONFLICT ON CONSTRAINT some_cube_analytics_pk DO NOTHING;
Add Comment
Please, Sign In to add comment