<transcript><audio_115>this value a from this primary key and I will go I'll get the record ID right that's what the index is going to have the record ID and I'll go find the record A4 which is the fourth version of the record a but it's a physical record that I'm going to get I'm going to get a</transcript><transcript><audio_116>physical record ID and I can locate A4 so far everything is good no problem right now you can see if the primary key is getting updated if I delete and insert it then I don't have to worry about a bunch of this the secondary indices however if I say get something</transcript><transcript><audio_117>which has to get to this record a the record ID is going to point to A4 and that's okay except I could have multiple secondary indices on the record a you know it has five columns I could have built a secondary index on each of those five</transcript><transcript><audio_118>columns now each of these secondary indexes is is going to point to that first record for old the newest version in this version chain again so far everything is good nothing nothing bad</transcript><transcript><audio_119>has happened so far now you start to get into some uh issues which is if I have to go and update this value and create a new version A5 what's going to happen I'll have to</transcript> this value a from this primary key and I will go I'll get the record ID right that's what the index is going to have the record ID and I'll go find the record A4 which is the fourth version of the record a but it's a physical record that I'm going to get I'm going to get a physical record ID and I can locate A4 so far everything is good no problem right now you can see if the primary key is getting updated if I delete and insert it then I don't have to worry about a bunch of this the secondary indices however if I say get something which has to get to this record a the record ID is going to point to A4 and that's okay except I could have multiple secondary indices on the record a you know it has five columns I could have built a secondary index on each of those five columns now each of these secondary indexes is is going to point to that first record for old the newest version in this version chain again so far everything is good nothing nothing bad has happened so far now you start to get into some uh issues which is if I have to go and update this value and create a new version A5 what's going to happen I'll have to
{"source": "grass-yt-cc-by.-mY8ALcJVTk|shard_1_1|create_multimodal_data.extract_yt_and_generate_transcripts.62|shard_1|create_multimodal_data.generate_captions.62|shard_1|create_multimodal_data.generate_captions.62", "params": {"id": "-mY8ALcJVTk", "channel_id": "UCHnBsf2rH-K7pn09rb3qvkA", "duration": 5000, "view_count": 4483, "age_limit": 0, "like_count": 50, "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_1/-mY8ALcJVTk.tar.gz"}}