Group by on High Cardinal dimension - Projection Tuning- Vertica

 I have a scenario where the group by is done on high cardinal dimension value field which has nearly 30Billion distinct values and the data type of this field is varchar. This query for a long time and I need to tune this query by creating projections in vertica. Could anyone provide me some ideas on it.

Comments

Leave a Comment

BoldItalicStrikethroughOrdered listUnordered list
Emoji
Image
Align leftAlign centerAlign rightToggle HTML viewToggle full pageToggle lights
Drop image/file