Please take this survey to help us learn more about how you use third party tools. Your input is greatly appreciated!

Query events clarification

Hi

 

I see this message in Query events, trying to understand what does this mean.

 

"NO GROUPBY PUSHDOWN The optimizer couldn't push GroupBy past Join

 

Aggregate columns not materialized; can't do pushdown."

 

though suggested action say no user action is needed, Wondering what is this message for, how do we interpret it.

 

Thanks much

Leave a Comment

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

Can't find what you're looking for? Search the Vertica Documentation, Knowledge Base, or Blog for more information.