<transcript><audio_48>the first for loop in there is going to be be calling uh the uh iterator of the child that's on the outer side of the join so the one that we're we're building the hash table for so for every tuple produced by</transcript><transcript><audio_49>the the left side of the join we're going to be building up this hash table and then once that's done and we've materialized our full hash table then we start calling the iterator for the right side of the join and that's going to start probing the hash table and of</transcript><transcript><audio_50>course if there is a probe match you know if the probe succeeds then we will emit the joint tuple then you know as we continue further and further down uh the the selection operator on the right side there is just filtering out all of the s</transcript><transcript><audio_51>tuples that don't match the predicate as s dot value is greater than 100 and then each of the the base uh the the leaf nodes in the uh query plan are just basic table scans so they're just saying for every single tuple in r we want to emit that tuple or every every single</transcript> the first for loop in there is going to be be calling uh the uh iterator of the child that's on the outer side of the join so the one that we're we're building the hash table for so for every tuple produced by the the left side of the join we're going to be building up this hash table and then once that's done and we've materialized our full hash table then we start calling the iterator for the right side of the join and that's going to start probing the hash table and of course if there is a probe match you know if the probe succeeds then we will emit the joint tuple then you know as we continue further and further down uh the the selection operator on the right side there is just filtering out all of the s tuples that don't match the predicate as s dot value is greater than 100 and then each of the the base uh the the leaf nodes in the uh query plan are just basic table scans so they're just saying for every single tuple in r we want to emit that tuple or every every single
{"source": "grass-yt-cc-by.0K0kI1H2KTE|shard_1004_48|create_multimodal_data.extract_yt_and_generate_transcripts.60|shard_1004|create_multimodal_data.generate_captions.50|shard_1004|create_multimodal_data.generate_captions.55", "params": {"id": "0K0kI1H2KTE", "channel_id": "UCHnBsf2rH-K7pn09rb3qvkA", "duration": 4701, "view_count": 4624, "age_limit": 0, "chapters": [{"start_time": 0.0, "title": "Introduction", "end_time": 108.0}, {"start_time": 108.0, "title": "Recap", "end_time": 278.0}, {"start_time": 278.0, "title": "Overview", "end_time": 435.0}, {"start_time": 435.0, "title": "Iterator", "end_time": 709.0}, {"start_time": 709.0, "title": "Runthrough", "end_time": 846.0}, {"start_time": 846.0, "title": "Iterator Approach", "end_time": 1104.0}, {"start_time": 1104.0, "title": "Materialization Approach", "end_time": 1581.0}, {"start_time": 1581.0, "title": "Vectorization Approach", "end_time": 2253.0}, {"start_time": 2253.0, "title": "Vectorization Model", "end_time": 2475.0}, {"start_time": 2475.0, "title": "Query Processing Models", "end_time": 2606.0}, {"start_time": 2606.0, "title": "Access Methods", "end_time": 2701.0}, {"start_time": 2701.0, "title": "Sequential Scan", "end_time": 2796.0}, {"start_time": 2796.0, "title": "Optimizations", "end_time": 2915.0}, {"start_time": 2915.0, "title": "Zone Maps", "end_time": 3180.0}, {"start_time": 3180.0, "title": "Late Materialization", "end_time": 3302.0}, {"start_time": 3302.0, "title": "Index Scan", "end_time": 3388.0}, {"start_time": 3388.0, "title": "Index Scan Example", "end_time": 3507.0}, {"start_time": 3507.0, "title": "Multiindex Scan Example", "end_time": 4701}], "like_count": 46, "channel_follower_count": 71100, "license": "Creative Commons Attribution license (reuse allowed)", "uploader_id": "@CMUDatabaseGroup", "yt_tar_file": "/leonardo_work/EUHPC_E03_068/audio/fixed_download/grass-yt-cc-by//shard_1004/0K0kI1H2KTE.tar.gz"}}