The Vertica Forum recently got a makeover! Let us know what you think by filling out this short, anonymous survey.

SIP Runtime Filter

Hi ,
I like to verify with the community how SIP Filter is working
 , my understanding is that the JOIN column of the FACT to the DIM is converted into IN list filter  and push down as below attach . see #3 in the attach picture , did the FACT.PK IN part is  converted to HASH(FACT.PK) IN ? 
image
Thanks 

 


Comments

  • Hi Eli,

    That is approximately correct.  There are lots of details; we don't give out implementation specifics because we're always trying to tune and improve the implementation.  So anything more specific is likely to become inaccurate from one release to the next.  But SIP is discussed in some more detail on the eighth page (page #1797, it's out of a larger volume) of our recent VLDB paper:

    http://vldb.org/pvldb/vol5/p1790_andrewlamb_vldb2012.pdf

    Adam

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.