࡞ͬͨ$-*πʔϧͷཁ݅
w #JH2VFSZʹ͋ΔσʔλΛ4ʹΞοϓϩʔυ͢Δ
w #JH2VFSZʹ42-ൃߦͯ݁͠Ռऔಘ
w ݁ՌΛϑΝΠϧʹग़ྗ
w ϑΝΠϧΛ4ͷಛఆόέοτʹΞοϓϩʔυ
Slide 5
Slide 5 text
1ZUIPOͰQBOEBT͏ͱ͜Μͳ؆୯ʹ
Slide 6
Slide 6 text
8IZ(P
w -FU`T(Pͱ͍͏ઓུΛςοΫϏδϣϯͰܝ͓͛ͯΓɺ
ձࣾͱͯ͠(Pͷར༻Λਪਐ͍ͯ͠Δ
w Ұൠతͳ(Pͷར
w ϫϯόΠφϦϙϯͷັྗ
w ҰൠతʹΫϩεϓϥοτϑΥʔϜରԠ
Slide 7
Slide 7 text
͏ύοέʔδ
w DMPVEHPPHMFDPNHPCJHRVFSZΛ͑#2ૢ࡞༰қ
w ϑΝΠϧૢ࡞$47ॻ͖ࠐΈඪ४ύοέʔδͰ
Slide 8
Slide 8 text
ࠓճͷςʔϚͱͳΔ͏Ұͭͷ݅
w ύλʔϯͷҟͳΔσʔλΛѻ͏ඞཁ͕͋Δ
w ΧϥϜ͕ͦΕͧΕҟͳΔ ઃܭʜ
w σʔλϚʔτͱͯ͠#JH2VFSZͷϏϡʔʹϩδοΫ࣮
w ݩʑखಈͰσʔλऔಘ͍ͯͨ͠ͷͰϏϡʔʹϩδοΫΛ͍࣋ͨͤͯͨ
w ෳࡶͳ42-ෆཁͰɺϏϡʔͷσʔλΛͯ࣋ͬͯ͘͢Ε0,
TFMFDUͰ0,
w 42-ͷ݁ՌΛ4USVDUʹ٧ΊࠐΉ͔Μͩ
Slide 9
Slide 9 text
࣮ύλʔϯ
Slide 10
Slide 10 text
<>CJHRVFSZ7BMVFΛ͏
w ͭͷߦͷ֤ྻͷΛॱ൪ʹ֨ೲ͢ΔͨΊͷεϥΠε
w ֤ɺ#JH2VFSZͷσʔλܕʹԠͯ͡దͳ(PͷجຊܕʢJOUɺGMPBUɺTUSJOHͳ
Ͳʣʹม͞ΕΔɻ
εϥΠεͷi൪ͷཁૉʹ
ߦͷi൪ͷྻΛૠೖ
ΫΤϦ݁ՌΛߦ୯ҐͰऔಘ͢Δ
ϙΠϯλܕ
https://pkg.go.dev/cloud.google.com/go/bigquery#Value
https://pkg.go.dev/cloud.google.com/go/bigquery#RowIterator
ͲͪΒ͕͍͍ͷ͔ॻ͖ͳ͕Β໎ͬͨ
w ίʔυͷՄಡੑ4USVDU͏ύλʔϯ͕ѹతʹߴ͍
w ͨͩ͠ύλʔϯఆٛͯ͠ࠓޙ૿͍͑ͯ͘͜ͱߟ͑ΔͱͦΕͰ͍͍ͷ͔
w ൚༻తͳπʔϧͱͯ͠࡞ΔͳΒ<>CJHRVFSZ7BMVFͰܕม͢Δܗ͕
ศརͦ͏
w 42-ΛҾͰ͢ͱTʹΞοϓϩʔυͯ͘͠ΕΔπʔϧతͳΠϝʔδ
w ѻͬͯΔσʔλͷਖ਼͠͞ίʔυ্͔ΒΘ͔Βͳ͍͕ɺͦͷ#JH2VFSZͷ
Ϗϡʔʹ͋Δ͔Βͳ͍ͷͰ
w $-*πʔϧͱͯͬͪ͜͠ͷ࡞Γͷ΄͏͕͍͚ͯΔΑͶ
Slide 13
Slide 13 text
ͲͪΒ͕͍͍ͷ͔ॻ͖ͳ͕Β໎ͬͨ
w ੩తܕ͚ݴޠͷಛੑ׆͔͢ͳΒ4USVDU͏ͷ͕CFUUFS
͔
w 4USVDUΛ͍ෳͷϝιουΛ࡞Δͱ͔Ͱ͋ΕԸܙ͋
Δ͕ɺࠓճDTWग़ྗͷΈ͕ٻΊΒΕΔ͔ΒΦʔόʔ͔
Slide 14
Slide 14 text
ࠓͷͱ͜Ζͷࣗͷ݁
w ࠓճͷέʔεͰ4USVDUΘͳ͍அΛͨ͠
w σʔλૢ࡞͕ܾ·͍ͬͯΔɺ͔ͭ$-*πʔϧͱͯ͠ͷ֦ு
ੑ͕ͳ͘ͳΔ͕ܾΊख
w อकੑՄಡੑ4USVDU͏ύλʔϯͷ΄͏͕ߴ͍ͱײ
͍ͯ͡ΔͷͰຖ·͞Εͦ͏Ͱ͋Δ