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

Doubt on Group by PIPE

< Just a Question >

I have a large table around 47 million rows on which I am doing  a group by on set of columns.. due to nature of data and count(*) group by , I expect less reduce in rows...as final output....may be to half....

< explain says as Group by PIPE, as I have sorted the columns>

My doubt 

As per documentation...
a) does  group by pipe..never do spill to disk ? 
b) Do the output computed  only in memory ?

In this case , result dataset if large and may not fin to memory.

 

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.