Examples of cascading.pipe.HashJoin

cascading.pipe.HashJoin
The HashJoin pipe allows for two or more tuple streams to join into a single stream via a {@link Joiner} whenall but one tuple stream is considered small enough to fit into memory.
When planned onto MapReduce, this is effectively a non-blocking "asymmetrical join" or "replicated join", where the left-most side will not block (accumulate into memory) in order to complete the join, but the right-most sides will. See below...
No aggregations can be performed with a HashJoin pipe as there is no guarantee all value will be associated with a given grouping key. In fact, an Aggregator would see the same grouping many times with a partial set of values.
For every incoming {@link Pipe} instance, a {@link Fields} instance must be specified that denotes the field namesor positions that should be joined with the other given Pipe instances. If the incoming Pipe instances declare one or more field with the same name, the declaredFields must be given to name the outgoing Tuple stream fields to overcome field name collisions.
By default HashJoin performs an inner join via the {@link cascading.pipe.joiner.InnerJoin}{@link cascading.pipe.joiner.Joiner} class.
Self joins can be achieved by using a constructor that takes a single Pipe and a numSelfJoins value. A value of 1 for numSelfJoins will join the Pipe with itself once. Note that a self join will block until all data is accumulated thus the stream must be reasonably small.
Note "outer" joins on the left most side will not behave as expected. All observed keys on the right most sides will be emitted with {@code null} for the left most stream, thus when running distributed, duplicate values willemerge from every Map task split on the MapReduce platform.
HashJoin does not scale well to large data sizes and thus requires streams with more data on the left hand side to join with more sparse data on the right hand side. That is, always attempt to effect M x N joins where M is large and N is small, instead of where M is small and N is large. Right hand side streams will be accumulated, and spilled to disk if the collection reaches a specific threshold when using Hadoop.
If spills are happening, consider increasing the spill thresholds, see {@link cascading.tuple.collect.SpillableTupleMap}.

If one of the right hand side streams starts larger than memory but is filtered (likely by a {@link cascading.operation.Filter} implementation) down to the point it fits into memory, it may be useful to usea {@link Checkpoint} Pipe to persist the stream and force a new FlowStep (MapReduce job) to read the data fromdisk, instead of applying the filter redundantly. This will minimize the amount of data "replicated" across the network.
See the {@link cascading.tuple.collect.TupleCollectionFactory} and {@link cascading.tuple.collect.TupleMapFactory} for a meansto use alternative spillable types. @see cascading.pipe.joiner.InnerJoin @see cascading.pipe.joiner.OuterJoin @see cascading.pipe.joiner.LeftJoin @see cascading.pipe.joiner.RightJoin @see cascading.pipe.joiner.MixedJoin @see cascading.tuple.Fields @see cascading.tuple.collect.SpillableTupleMap

    Pipe pipeUpper = new Each( new Pipe( "upper" ), new Fields( "line" ), splitter );


    Pipe pipeLhs = new Each( new Pipe( "lhs" ), new Fields( "line" ), splitter );
    Pipe pipeRhs = new Each( new Pipe( "rhs" ), new Fields( "line" ), splitter );


    Pipe upperLower = new HashJoin( pipeLower, new Fields( "num" ), pipeUpper, new Fields( "num" ), new Fields( "numUpperLower", "charUpperLower", "num2UpperLower", "char2UpperLower" ) );


    upperLower = new Each( upperLower, new Identity() );


    Pipe lhsUpperLower = new HashJoin( pipeLhs, new Fields( "num" ), upperLower, new Fields( "numUpperLower" ), new Fields( "numLhs", "charLhs", "numUpperLower", "charUpperLower", "num2UpperLower", "char2UpperLower" ) );


    lhsUpperLower = new Each( lhsUpperLower, new Identity() );


    Pipe grouped = new CoGroup( "cogrouping", pipeRhs, new Fields( "num" ), lhsUpperLower, new Fields( "numLhs" ) );

View Full Code Here

    Pipe pipeUpper = new Each( new Pipe( "upper" ), new Fields( "line" ), splitter );


    Pipe pipeLhs = new Each( new Pipe( "lhs" ), new Fields( "line" ), splitter );
    Pipe pipeRhs = new Each( new Pipe( "rhs" ), new Fields( "line" ), splitter );


    Pipe upperLower = new HashJoin( pipeLower, new Fields( "num" ), pipeUpper, new Fields( "num" ), new Fields( "numUpperLower1", "charUpperLower1", "numUpperLower2", "charUpperLower2" ) );


    upperLower = new Each( upperLower, new Identity() );


    Pipe lhsRhs = new HashJoin( pipeLhs, new Fields( "num" ), pipeRhs, new Fields( "num" ), new Fields( "numLhsRhs1", "charLhsRhs1", "numLhsRhs2", "charLhsRhs2" ) );


    lhsRhs = new Each( lhsRhs, new Identity() );


    Pipe grouped = new CoGroup( "cogrouping", upperLower, new Fields( "numUpperLower1" ), lhsRhs, new Fields( "numLhsRhs1" ) );

View Full Code Here

    Pipe pipeUpper = new Each( new Pipe( "upper" ), new Fields( "line" ), splitter );


    Fields num = new Fields( "num" );
    num.setComparator( "num", new AllComparator() );


    Pipe splice = new HashJoin( pipeLower, num, pipeUpper, new Fields( "num" ), Fields.size( 4 ) );


    Map<Object, Object> properties = getProperties();


    Flow flow = getPlatform().getFlowConnector( properties ).connect( sources, sink, splice );

View Full Code Here

    Function splitter = new RegexSplitter( new Fields( "num", "char" ), " " );


    Pipe pipeLower = new Each( new Pipe( "lower" ), new Fields( "line" ), splitter );
    Pipe pipeUpper = new Each( new Pipe( "upper" ), new Fields( "line" ), splitter );


    Pipe splice = new HashJoin( pipeLower, Fields.NONE, pipeUpper, Fields.NONE, Fields.size( 4 ) );


    Map<Object, Object> properties = getProperties();


    Flow flow = getPlatform().getFlowConnector( properties ).connect( sources, sink, splice );

View Full Code Here

    Pipe pipe = new GroupBy( pipeLower, new Fields( "numA" ) );


    pipe = new Every( pipe, Fields.ALL, new TestIdentityBuffer( new Fields( "numA" ), 5, false ), Fields.RESULTS );


    Pipe lhsPipe = new Each( pipe, new Identity() );
    lhsPipe = new HashJoin( "lhs", lhsPipe, new Fields( "numA" ), pipeUpper, new Fields( "numB" ) );


    Pipe rhsPipe = new Each( pipe, new Identity() );
    rhsPipe = new HashJoin( "rhs", rhsPipe, new Fields( "numA" ), pipeJoined, new Fields( "numC" ) );


    Flow flow = getPlatform().getFlowConnector().connect( sources, sinks, lhsPipe, rhsPipe );


    if( getPlatform().isMapReduce() )
      assertEquals( "wrong number of steps", 3, flow.getFlowSteps().size() );

View Full Code Here


    Pipe lhs = new Pipe( "lhs" );
    Pipe rhs = new Pipe( "rhs" );


//    Pipe joined = new CoGroup( messages, new Fields( "id" ), people, new Fields( "id2" ) );
    Pipe joined = new HashJoin( lhs, new Fields( "id" ), rhs, new Fields( "id2" ) );


    Pipe pruned = new Each( joined, new Fields( "id2" ), new Identity(), Fields.RESULTS );
//    pruned = new Checkpoint( pruned );
    Pipe merged = new Merge( pruned, rhs );
    Pipe grouped = new GroupBy( merged, new Fields( "id2" ) );

View Full Code Here

    Pipe pipeOffset = new Each( new Pipe( "offset" ), new Fields( "line" ), new RegexSplitter( new Fields( "num2", "char2" ), " " ) );


    Pipe splice = new Merge( "merge", pipeLower, pipeUpper );


    if( streamed )
      splice = new HashJoin( splice, new Fields( "num1" ), pipeOffset, new Fields( "num2" ) );
    else
      splice = new HashJoin( pipeOffset, new Fields( "num2" ), splice, new Fields( "num1" ) );


    Flow flow = getPlatform().getFlowConnector().connect( sources, sink, splice );


//    flow.writeDOT( name + ".dot" );

View Full Code Here


    Pipe pipeLower = new Each( new Pipe( "lower" ), new Fields( "line" ), new RegexSplitter( new Fields( "num1", "char1" ), " " ) );
    Pipe pipeUpper = new Each( new Pipe( "upper" ), new Fields( "line" ), new RegexSplitter( new Fields( "num1", "char1" ), " " ) );
    Pipe pipeOffset = new Each( new Pipe( "offset" ), new Fields( "line" ), new RegexSplitter( new Fields( "num2", "char2" ), " " ) );


    Pipe splice = new HashJoin( pipeLower, new Fields( "num1" ), pipeOffset, new Fields( "num2" ) );


    splice = new Retain( splice, new Fields( "num1", "char1" ) );


    splice = new Merge( "merge", splice, pipeUpper );


    if( streamed )
      splice = new HashJoin( splice, new Fields( "num1" ), pipeOffset, new Fields( "num2" ) );
    else
      splice = new HashJoin( pipeOffset, new Fields( "num2" ), splice, new Fields( "num1" ) );


    Flow flow = getPlatform().getFlowConnector().connect( sources, sink, splice );


//    flow.writeDOT( name + ".dot" );

View Full Code Here


    Pipe pipeLower = new Each( new Pipe( "lower" ), new Fields( "line" ), new RegexSplitter( new Fields( "num1", "char1" ), " " ) );
    Pipe pipeUpper = new Each( new Pipe( "upper" ), new Fields( "line" ), new RegexSplitter( new Fields( "num1", "char1" ), " " ) );
    Pipe pipeOffset = new Each( new Pipe( "offset" ), new Fields( "line" ), new RegexSplitter( new Fields( "num2", "char2" ), " " ) );


    Pipe splice = new HashJoin( pipeLower, new Fields( "num1" ), pipeOffset, new Fields( "num2" ) );


    splice = new Retain( splice, new Fields( "num1", "char1" ) );


    splice = new Merge( "merge1", splice, pipeUpper );


    if( firstStreamed )
      splice = new HashJoin( splice, new Fields( "num1" ), pipeOffset, new Fields( "num2" ) );
    else
      splice = new HashJoin( pipeOffset, new Fields( "num2" ), splice, new Fields( "num1" ) );


    splice = new Retain( splice, new Fields( "num1", "char1" ) );


    if( interMerge )
      splice = new Merge( "merge2", splice, pipeUpper );


    if( secondStreamed )
      splice = new HashJoin( splice, new Fields( "num1" ), pipeOffset, new Fields( "num2" ) );
    else
      splice = new HashJoin( pipeOffset, new Fields( "num2" ), splice, new Fields( "num1" ) );


    Flow flow = getPlatform().getFlowConnector().connect( sources, sink, splice );


//    flow.writeDOT( name + ".dot" );

View Full Code Here


    Pipe left = new Each( new Pipe( "left" ), new Fields( "line" ), new RegexFilter( ".*46.*" ) );
    Pipe right = new Each( new Pipe( "right" ), new Fields( "line" ), new RegexFilter( ".*192.*" ) );


    Fields[] fields = Fields.fields( new Fields( "offset" ), new Fields( "offset" ) );
    Pipe merge = new HashJoin( "join", Pipe.pipes( left, right ), fields, Fields.size( 4 ), new InnerJoin() );


    merge = new Every( merge, new MaxValue() );


    Map sources = new HashMap();
    sources.put( "left", source1 );

View Full Code Here

0 1 2 3 4 5

TOP

Related Classes of cascading.pipe.HashJoin

cascading.flow.hadoop.BuildJobsHadoopPlatformTest

cascading.flow.iso.graph.HashJoinAroundHashJoinLeftMostGraph

cascading.flow.iso.graph.HashJoinMergeIntoHashJoinStreamedStreamedMergeGraph

cascading.flow.iso.graph.HashJoinSameSourceGraph

cascading.flow.iso.graph.HashJoinsIntoMerge

cascading.flow.iso.graph.JoinAroundJoinRightMostGraph

cascading.flow.iso.graph.JoinAroundJoinRightMostGraphSwapped

cascading.JoinFieldedPipesPlatformTest

cascading.lingual.optiq.CascadingAggregateRel

cascading.MergePipesPlatformTest

All source code are property of their respective owners. Java is a trademark of Sun Microsystems, Inc and owned by ORACLE Inc. Contact coftware#gmail.com.