<transcript><audio_56>the uh r the table scan of r is going to emit or produce a single tuple that's going to flow back up to the join operator so kind of this keeps going until again all of the tuples in r</transcript><transcript><audio_57>are produced and then that first for loop um we passed back some kind of null null marker to let that for loop know to exit so the the first for loop exits our hash table is built and then we're gonna do</transcript><transcript><audio_58>the same thing here on this uh right side we're gonna call the next uh function for uh the the selection and then the selection is going to call the next function for the the base table scan again we want to emit up a single tuple</transcript><transcript><audio_59>uh to each of these parent operators here now of course in the the case of the the selection scan here we're only returning tuples that match so for example let's say s produces several tuples that that don't satisfy</transcript><transcript><audio_60>the predicate they're they're not greater than 100 then that uh operator at step four isn't going to return anything so it's only going to return it's only going to emit a tuple</transcript> the uh r the table scan of r is going to emit or produce a single tuple that's going to flow back up to the join operator so kind of this keeps going until again all of the tuples in r are produced and then that first for loop um we passed back some kind of null null marker to let that for loop know to exit so the the first for loop exits our hash table is built and then we're gonna do the same thing here on this uh right side we're gonna call the next uh function for uh the the selection and then the selection is going to call the next function for the the base table scan again we want to emit up a single tuple uh to each of these parent operators here now of course in the the case of the the selection scan here we're only returning tuples that match so for example let's say s produces several tuples that that don't satisfy the predicate they're they're not greater than 100 then that uh operator at step four isn't going to return anything so it's only going to return it's only going to emit a tuple
{"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"}}