Hamamatsu.js #8のLT資料です
"NB[PO%ZOBNP%#Ͱݕࡧ͢Δ!KBDPZVUPSJVT)BNBNBUTVKT
View Slide
খ༔ే !KBDPZVUPSJVT‣ ΤΞʔζגࣜձࣾ‣ +"846()BNBNBUTVSC‣ 3VCZ3VCZPO3BJMT+BWBTDSJQU"84࠷ۙࣗ࡞ΩʔϘʔυͱΧϨʔ࡞ΓʹϋϚ͍ͬͯΔ
+4ύΠϓ໓ଟʹΘͳ͍͔ΒେৎͩΖଟ
"NB[PO%ZOBNP%#‣ ϑϧϚωʔδυͳ/P42-σʔλϕʔε‣ ߴՄ༻ੑ ͭͷ";ͷϨϓϦέʔγϣϯ‣ ΩʔόϦϡʔετΞ‣ εΩʔϚϨε‣ ΩϟύγςΟϢχοτ‣ ಡΈॻ͖ੑೳΛܾఆ͢Δύϥϝʔλ‣ lΦϯσϚϯυzͱ͍͏Φϓγϣϯ͋Δɻ"NQMJGZΛ௨ͯ͠%ZOBNP%#ͷςʔϒϧΛ࡞ͬͨ߹ɺσϑΥϧτͰͪ͜ΒͷΦϓγϣϯ͕༗ޮʹͳΔ
%ZOBNP%#ͷݕࡧ‣ RVFSZ‣ TDBOςʔϒϧશମΛεΩϟϯͯ݅͠ʹ߹க͢ΔͷΛฦ͢ύʔςΟγϣϯΩʔιʔτΩʔΛࢦఆͯ݅͠ʹ߹க͢ΔͷΛநग़͢Δॊೈͳݕࡧ͕ՄೳͳҰํɺ%#ͷෛՙ͕ߴ͘ύϑΥʔϚϯεྑ͘ͳ͍
Γ͔ͨͬͨ͜ͱ‣ %ZOBNP%#Ͱݕࡧ‣ ύʔςΟγϣϯΩʔιʔτΩʔΛ͏
͍ͬͯͳ͍͜ͱ‣ ΩϟύγςΟϢχοτͷࢼࢉ‣ ྉۚ
EPDLFSDPNQPTFZNM
‣ %ZOBNP%#"ENJO‣ IUUQMPDBMIPTU‣ EBUBCBTFFOEQPJOU‣ IUUQMPDBMIPTU%ZOBNP%#ΛϩʔΧϧͰىಈ
ॅॴ$% ಓݝ$% ࢢ۠ொଜ$% ொҬ$% ༣ศ൪߸ ࣄۀॴϑϥά ഇࢭϑϥά ಓݝ ಓݝΧφ ࢢ۠ொଜ ࢢ۠ொଜΧφ ੩Ԭݝ γζΦΧέϯ দࢢத۠ϋϚϚπγφΧΫ ੩Ԭݝ γζΦΧέϯ দࢢத۠ϋϚϚπγφΧΫொҬ ொҬΧφ ொҬิ ژ௨Γ໊ ࣈஸ ࣈஸΧφ ิ ࣄۀॴ໊ࣄۀॴ໊Χφࣄۀॴॅॴ ৽ॅॴ$%ொ ΧδϚνיߐ ΧϞΤ দࢢอ݈ॴϋϚϚπγϗέϯδϤיߐ̎ஸ̍̍̎ॅॴKQIUUQKVTZPKQ
1,Ͱݕࡧ͢Δॅॴ$% ॅॴ ॅॴΧφ ੩Ԭݝদࢢத۠יߐொ γζΦΧέϯϋϚϚπγφΧΫΧϞΤνϣ੩Ԭݝদࢢத۠יߐொத෦ిྗɹʢגʣɹদӦۀॴיߐொ̎̎̍γζΦΧέϯϋϚϚπγφΧΫΧϞΤνϣνϢϒσϯϦϤΫɹʢΧϒʣɹϋϚϚπΤΠΪϤγϤ
ύʔςΟγϣϯΩʔࢦఆʹΑΔݕࡧ݁Ռ
1,4,Ͱݕࡧ͢Δ
https://docs.aws.amazon.com/ja_jp/amazondynamodb/latest/developerguide/LegacyConditionalParameters.KeyConditions.html“ςʔϒϧʹର͢ΔΫΤϦͷ߹ɺςʔϒϧͷϓϥΠϚϦΩʔଐੑͷΈͷ݅Λ࣋ͭ͜ͱ͕Ͱ͖·͢ɻEQ ݅ͱͯ͠ύʔςΟγϣϯΩʔͷ໊લͱΛఏڙ͢Δඞཁ͕͋Γ·͢ɻΦϓγϣϯͰɺιʔτΩʔΛࢀর͢Δ 2 ൪ͷ݅ΛࢦఆͰ͖·͢ɻ”RVFSZͷ੍ݶ
https://docs.aws.amazon.com/ja_jp/amazondynamodb/latest/developerguide/LegacyConditionalParameters.KeyConditions.htmlKeyConditions ͷ߹ɺ࣍ͷൺֱԋࢉࢠͷΈ͕αϙʔτ͞Ε͍ͯ·͢ɻEQ | LE | LT | GE | GT | BEGINS_WITH | BETWEENRVFSZͷ੍ݶ
IUUQTEPDTBXTBNB[[email protected][POEZOBNPECMBUFTUEFWFMPQFSHVJEF)PX*U8PSLT1BSUJUJPOTIUNM
ࢁསݝ੩ԬݝѪݝʜ੩ԬࢢѮ۠੩Ԭࢢਗ਼ਫ۠ʜদࢢத۠দࢢ۠ʜொࠠொʜיߐݩொʜFYTFMFDUCPYͰυϦϧμϯ͢ΔΑ͏ͳ6*
(4*‣ ςʔϒϧ࡞࣌ʹࢦఆ͢Δ1,4,ͱผʹఆٛͰ͖ΔΠϯσοΫε‣ Ұͭͷςʔϒϧʹ͖ͭɺ࠷େͭͷ(4*͕ొՄೳ‣ (4*͝ͱʹΩϟύγςΟϢχοτͷઃఆ͕ඞཁ‣ (4*ςʔϒϧͷࣹӨɻϨίʔυͷొޙʹ(4*ݕࡧΛ͔͚͙ͯ͢ʹө͞Ε͍ͯͳ͍߹͕͋ΔάϩʔόϧηΧϯμϦΠϯσοΫε
ॅॴ$%ಓݝ$%ࢢ۠ொଜ$%ொҬ$% ༣ศ൪߸ࣄۀॴϑϥάഇࢭϑϥά ಓݝಓݝΧφࢢ۠ொଜࢢ۠ொଜΧφொҬ ொҬΧφ ੩ԬݝγζΦΧέϯদࢢத۠ϋϚϚπγφΧΫיߐ ΧϞΤDBUFHPSZ WBMVFDJUZ দࢢத۠DBUFHPSZ WBMVFQSFGFDUVSF ੩ԬݝDBUFHPSZ WBMVFUPXO יߐ
ॅॴ$% DBUFHPSZ [email protected] ಓݝ ࢢ۠ொଜ ொҬ QSFGFDUVSF ੩Ԭݝ ੩Ԭݝ DJUZ ੩Ԭݝদࢢத۠ দࢢத۠ UPXO ੩Ԭݝদࢢத۠יߐ יߐ1, 4,ॅॴ$%ಓݝ$%ࢢ۠ொଜ$%ொҬ$% ༣ศ൪߸ࣄۀॴϑϥάഇࢭϑϥά ಓݝಓݝΧφࢢ۠ொଜࢢ۠ொଜΧφொҬ ொҬΧφ ੩ԬݝγζΦΧέϯদࢢத۠ϋϚϚπγφΧΫיߐ ΧϞΤ
ॅॴ$% DBUFHPSZ [email protected] ಓݝ ࢢ۠ொଜ ொҬ QSFGFDUVSF ੩Ԭݝ ੩Ԭݝ DJUZ ੩Ԭݝদࢢத۠ দࢢத۠ UPXO ੩Ԭݝদࢢத۠יߐ יߐ1, 4,1, 4,ॅॴ$% DBUFHPSZ [email protected] ಓݝ ࢢ۠ொଜ ொҬ QSFGFDUVSF ੩Ԭݝ ੩Ԭݝ DJUZ ੩Ԭݝদࢢத۠ দࢢத۠ UPXO ੩Ԭݝদࢢத۠יߐ יߐ(4*
(4*ύʔςΟγϣϯΩʔࢦఆʹΑΔݕࡧ݁Ռ
(4*ύʔςΟγϣϯΩʔιʔτΩʔࢦఆʹΑΔલํҰகݕࡧ݁Ռ
(4*ύʔςΟγϣϯΩʔιʔτΩʔࢦఆʹΑΔݕࡧ݁Ռ
%ZOBNP%#σʔλϞσϦϯάދͷרIUUQNBSDZIBUFOBCMPHDPNFOUSZͷ΅Γʔ͞ΜͷΫϥυΠϯϑϥ1PEDBTUʰ5SBDLরҪ͞Μͷ4FSWFSMFTTΞʔΩςΫτࢦೆͱɺ1BUSFPOొͷ͓ΒͤʱͷϝϞIUUQTDMPVEJOGSBBVEJPUSBDLEGFD%ZOBNP%#Λ༻ͨ͠ઃܭͱΞʔΩςΫνϟͷઃܭʹؔ͢ΔϕετϓϥΫςΟεIUUQTEPDTBXTBNB[[email protected][POEZOBNPECMBUFTUEFWFMPQFSHVJEFCFTUQSBDUJDFTIUNM
"84&YQFSU0OMJOF+"846(দ"84ษڧձIUUQTKBXTVHIBNBNBUTVEPPSLFFQFSKQFWFOUT+"846(দ"84ษڧձIUUQTKBXTVHIBNBNBUTVEPPSLFFQFSKQFWFOUT+"84%":4IUUQTKBXTEBZTKBXTVHKQ