We're Moving!

The Vertica Forum is moving to a new OpenText Analytics Database (Vertica) Community.

Join us there to post discussion topics, learn about

product releases, share tips, access the blog, and much more.

Create My New Community Account Now


event_category event_category — Vertica Forum

event_category event_category

sreeblrsreeblr - Select Field - Employee
in General Discussion

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

whats is NO GROUPBY PUSHDOWN  and how to fix

i ran this query
select distinct event_category, event_type, count(*) from query_events group by 1, 2 order by 3 desc  
and got this output . any issues and how to fix

EXECUTION      SEQUENCE CACHE REFILLED    20796
OPTIMIZATION NO GROUPBY PUSHDOWN      8062
OPTIMIZATION TRANSITIVE PREDICATE            3772
OPTIMIZATION GROUPBY PUSHDOWN 3770
OPTIMIZATION PREDICATE OUTSIDE HISTOGRAM        3419 .

Leave a Comment

BoldItalicStrikethroughOrdered listUnordered list
Format
SpoilerCodeQuote
Heading 2Heading 1
Emoji
:):D:(;):/:o:s:p:'(:|B):#:*<3o:)>:)
Url
Image
Align leftAlign centerAlign rightToggle HTML viewToggle full pageToggle lights
Drop image/file
Home • General DiscussionComment As ...