Tweet
Tweet

Slide 1

Slide 1 text

"84Ͱ*DFCFSHΛ࢖ͬͯ σʔλ΢ΣΞϋ΢εΛߏஙͯ͠ΈΔ ּݪ޺ +"846(౦๺!ळా

Slide 2

Slide 2 text

ࣗݾ঺հ @kasacchiful @kasacchiful ּݪ޺ wΫϥεϝιουגࣜձࣾσʔλࣄۀຊ෦ w৽ׁݝ৽ׁࢢࡏॅ w޷͖ͳ"84αʔϏε4ɺ-BNCEBɺ4UFQ'VODUJPOT w+"846(৽ׁࢧ෦ʗ1ZUIPOػցֶशษڧձJO৽ׁʗ+B445৽ׁ ʗ48"/**ʗ$MPVE fl BSF.FFUVQ/JJHBUBʗFUD w"84$PNNVOJUZ#VJMEFS+BQBO"84"MM $FSUJ fi DBUJPOT&OHJOFFS

Slide 3

Slide 3 text

+"846(৽ׁ։࠵ܗࣜ ຊฤษڧձ wෆఆظ։࠵ʗʙ࣌ؒఔ౓ʗΦϑϥΠϯ wࣄલʹςʔϚܾΊͯ։࠵ ϓνΩϟονΞοϓձ wຖि໦༵໷࣌ʗ࣌ؒఔ౓ʗΦϯϥΠϯ wͦͷ৔ͰؾʹͳΔهࣄݟͨΓɺ͓೰Έ૬ஊड͚ͨΓ

Slide 4

Slide 4 text

໨࣍ wσʔλϑΥʔϚοτͷ੔ཧ w"QBDIF*DFCFSHͱ͸ w*DFCFSHͰߏங͢Δ%8) w·ͱΊ

Slide 5

Slide 5 text

σʔλϑΥʔϚοτͷ੔ཧ

Slide 6

Slide 6 text

Α͋͘Δߏ੒

Slide 7

Slide 7 text

Α͋͘Δߏ੒ (MVFͰ&5-ॲཧ 1BSRVFUϑΝΠϧΛ 4ʹอଘ "UIFOBͰ ෼ੳΫΤϦ࣮ߦ

Slide 8

Slide 8 text

σʔλϨΠΫͰΑ͘࢖ΘΕΔϑΝΠϧϑΥʔϚοτ $47 +40/ wਓ͕ؒૢ࡞͠΍͍͢ɺΞϓϦέʔγϣϯؒ࿈ܞ͠΍͍͢ "730 ߦࢦ޲ϑΥʔϚοτ wσʔλͷߴ଎ॲཧ͕Մೳɺ0-"1ॲཧʹར༻Մೳ 1BSRVFU ྻࢦ޲ϑΥʔϚοτ ˕ਪ঑ w෼ੳ༻్ʹ࢖͍΍͍͢

Slide 9

Slide 9 text

໰୊఺ $47 +40/ wਓ͕ؒૢ࡞͠΍͍͢ɺΞϓϦέʔγϣϯؒ࿈ܞ͠΍͍͢ "730 ߦࢦ޲ϑΥʔϚοτ wσʔλͷߴ଎ॲཧ͕Մೳɺ0-"1ॲཧʹར༻Մೳ 1BSRVFU ྻࢦ޲ϑΥʔϚοτ ˕ਪ঑ w෼ੳ༻్ʹ࢖͍΍͍͢ ಘҙ େྔσʔλͷςʔϒϧ୯ҐͷಡΈॻ͖ ύʔςΟγϣϯϨϕϧͷಡΈॻ͖ ෆಘҙ ϨίʔυϨϕϧͷಡΈॻ͖

Slide 10

Slide 10 text

ͦͷଞͷ໰୊ εϞʔϧϑΝΠϧʹΑΔύϑΥʔϚϯεྼԽ wϑΝΠϧ*0͕૿͑ͯಡΈࠐΈ଎౓௿Լ w4"1*ίʔϧ਺૿ՃʹΑΔར༻ྉ૿Ճ σʔλͷฤूɾ࡟আ͕೉͍͠ wݸਓ৘ใͷ෦෼Λޙ͔Β࡟আͨͯ͘͠΋ʜ w෼ੳ࣌ͷτϥϯβΫγϣϯΛ୲อ͍͚ͨ͠Ͳ೉͍͠

Slide 11

Slide 11 text

ͦͷଞͷ໰୊ ಉ࣌ΞΫηε࣌ͷ੔߹ੑ୲อ͕೉͍͠ wෳ਺ͷτϥϯβΫγϣϯॲཧΛ໰୊ͳ͘ߦ͏ʹ͸ෆ޲͖ σʔλߋ৽͕ೖΔͱɺաڈͷঢ়ଶΛ෮ݩ͠ʹ͍͘ wσʔλαΠΤϯε࣌ͷ࣮ݧ࠶ݱΛ͍ͨ͠ wݱࡏͱաڈͷσʔλΛൺֱ͍ͨ͠ wόοΫΞοϓϦετΞͩͱɺେֻ͔Γ͗͢Δ

Slide 12

Slide 12 text

৽ͨͳσʔλϑΥʔϚοτͰ ղܾ

Slide 13

Slide 13 text

σʔλϑΥʔϚοτ "QBDIF)VEJ "QBDIF*DFCFSH %FMUB-BLF

Slide 14

Slide 14 text

σʔλϑΥʔϚοτ "QBDIF)VEJ "QBDIF*DFCFSH %FMUB-BLF ࠓճ͸IcebergΛѻ͏

Slide 15

Slide 15 text

Apache Icebergͱ͸

Slide 16

Slide 16 text

"QBDIF*DFCFSH ΦʔϓϯιʔεͷσʔλςʔϒϧϑΥʔϚοτ wڊେͳ෼ੳςʔϒϧͷͨΊͷߴੑೳͳϑΥʔϚοτ wσʔλϨΠΫʹू·͍ͬͯΔσʔληοτͷૢ࡞Λ؆ૉԽ Մೳ wτϥϯβΫγϣϯॲཧՄೳ w(MVFW΍"UIFOB&OHJOFWͰ*DFCFSHWʹରԠ ݱࡏ

Slide 17

Slide 17 text

ओͳಛ௃ "$*%ಛੑ w*OTFSU%FMFUF6QEBUFͷτϥϯβΫγϣϯॲཧରԠ 4DIFNB&WPMVUJPO wεΩʔϚมߋʹରԠɺ్தͰύʔςΟγϣϯมߋ΋Մೳ )JEEFO1BSUJUJPO wϢʔβ͕ҙࣝ͢Δ͜ͱͳ͘ύʔςΟγϣϯ؅ཧͰ͖Δ wΫΤϦ͕ςʔϒϧͷ෺ཧϨΠΞ΢τʹґଘ͠ͳ͘ͳͬͨ 4OBQTIPU5JNFUSBWFM wτϥϯβΫγϣϯຖʹεφοϓγϣοτΛ࣋ͭ wεφοϓγϣοτόʔγϣϯ΍͋Δ࣌఺ͷঢ়ଶͷςʔϒϧΛΫΤϦͰ؆୯ʹࢀরՄೳ

Slide 18

Slide 18 text

*DFCFSHͷߏ੒ IUUQTJDFCFSHBQBDIFPSHTQFD "84Ͱ͸(MVF%BUB $BUBMPHͰ؅ཧ σʔλϑΝΠϧ͸ 1BSRVFU ϝλσʔλ͸+40/΍ "730ͳͲͰߏ੒

Slide 19

Slide 19 text

*DFCFSHͷߏ੒ IUUQTBXTBNB[PODPNKQCMPHTCJHEBUBNPOJUPSJOHBQBDIFJDFCFSHNFUBEBUBMBZFSVTJOHBXTMBNCEBBXTHMVFBOEBXTDMPVEXBUDI "84Ͱ͸(MVF%BUB $BUBMPHͰ؅ཧ σʔλϑΝΠϧ͸ 1BSRVFU ϝλσʔλ͸+40/΍ "730ͳͲͰߏ੒

Slide 20

Slide 20 text

*DFCFSHͷߏ੒ *DFCFSHςʔϒϧ͸ɺ EBUBͱNFUBEBUBͰߏ੒

Slide 21

Slide 21 text

*DFCFSHͷߏ੒ NFUBEBUB͸ +40/ͱBWSPϑΝΠϧͰ؅ཧ

Slide 22

Slide 22 text

*DFCFSHͷߏ੒ EBUB͸ 1BSRVFUϑΝΠϧͰ֨ೲ

Slide 23

Slide 23 text

&YQSFTTJWF42- w*OTFSU%FMFUF6QEBUF w.FSHFͳͲɺॊೈͳ42- ΫΤϦʹରԠ w%FMFUF͸࡟আϑΝΠϧͰϑ ϥά؅ཧ w6QEBUF͸*OTFSU%FMFUFͷ ৼΔ෣͍

Slide 24

Slide 24 text

&YQSFTTJWF42- w"UIFOBͰΫΤϦ ࣮ߦ͢Δͷ͕؆୯

Slide 25

Slide 25 text

εΩʔϚఆٛ w"UIFOBͰఆٛ͢Δͷ͕؆ ୯ w"MUFSจ΋࢖͑Δ

Slide 26

Slide 26 text

$3&"5&5"#-& CREATE TABLE `sample_partition_100_db`.`partition100_date_iceberg` ( id string, uuid string, target_date date ) PARTITIONED BY (day(target_date)) LOCATION 's3://sample-partition-100-db/partition100_date_iceberg' TBLPROPERTIES ( 'table_type'='ICEBERG' ); `UBCMF@UZQF``*$&3(` Λࢦఆ

Slide 27

Slide 27 text

εφοϓγϣοτλΠϜτϥϕϧ wτϥϯβΫγϣϯຖʹε φοϓγϣοτΛ࣋ͭ wεφοϓγϣοτόʔδϣ ϯΛࢦఆͯ͠ɺաڈ࣌఺ͷ σʔλΛࢀরՄೳ

Slide 28

Slide 28 text

εφοϓγϣοτλΠϜτϥϕϧ wτϥϯβΫγϣϯຖʹε φοϓγϣοτΛ࣋ͭ wεφοϓγϣοτόʔδϣ ϯΛࢦఆͯ͠ɺաڈ࣌఺ͷ σʔλΛࢀরՄೳ

Slide 29

Slide 29 text

εφοϓγϣοτλΠϜτϥϕϧ wτϥϯβΫγϣϯຖʹε φοϓγϣοτΛ࣋ͭ wλΠϜελϯϓΛࢦఆ͠ ͯɺաڈ࣌఺ͷσʔλΛࢀ রՄೳ

Slide 30

Slide 30 text

0QUJNJ[F7BDVVN wෆཁͳϑΝΠϧ࡟আ౳Λ࣮ࢪ͠ ͯ࠷దԽ w0QUJNJ[F w࠷దͳϑΝΠϧϨΠΞ΢τʹ ॻ͖׵͑Δ w7BDVVN wεφοϓγϣοτ༗ޮظݶ੾ ΕٴͼΦʔϓϯϑΝΠϧͷ࡟ আ ϝλσʔλ࠷దԽ

Slide 31

Slide 31 text

IcebergͰߏங͢ΔDWH

Slide 32

Slide 32 text

Α͋͘Δߏ੒ (MVFͰ&5-ॲཧ 1BSRVFUϑΝΠϧΛ 4ʹอଘ "UIFOBͰ ෼ੳΫΤϦ࣮ߦ

Slide 33

Slide 33 text

ྫ͑͹͜Μͳײ͡Ͱ*DFCFSHςʔϒϧʹ࿈ܞ (MVFͰશྔऔಘPS ࠩ෼औಘ $47ग़ྗͱԾఆ "UIFOBͰ ෼ੳΫΤϦ࣮ߦ (MVFͰ*DFCFSH ςʔϒϧʹߋ৽

Slide 34

Slide 34 text

(MVFδϣϒͰ.&3(& ## ..<省略>.. ## Read Csv from Catalog df = glueContext.create_dynamic_frame.from_catalog( database="sample_partition_100_db", table_name="partition100_date_csv") ## Transform Type df = ApplyMapping.apply( frame=df, mappings=[ ("id", "string", "id", "string"), ("uuid", "string", "uuid", "string"), ("target_date", "string", "target_date", "date") ]).toDF() ## Store tmp table df.createOrReplaceTempView("tmp_partition100_date_csv") ## Merge spark.sql(''' MERGE INTO glue_catalog.sample_partition_100_db.partition100_date_i ceberg t USING tmp_partition100_date_csv s ON (t.id = s.id) WHEN MATCHED THEN UPDATE SET t.uuid = s.uuid, t.target_date = s.target_date WHEN NOT MATCHED THEN INSERT * ''' ) job.commit()

Slide 35

Slide 35 text

࣮ࡍͷࣄྫ

Slide 36

Slide 36 text

࣮ࡍͷࣄྫ ೔࣍Ͱσʔλऔಘ ʢશྔPSࠩ෼ʣ

Slide 37

Slide 37 text

࣮ࡍͷࣄྫ *DFCFSHςʔϒϧʹ Ϛʔδ -BNCEBͷ৔߹ "UIFOBܦ༝Ͱ

Slide 38

Slide 38 text

τϥϯβΫγϣϯຖʹ࿈ܞ wมߋσʔλΩϟϓνϟ $%$ Λར༻ wมߋ෼Λૹͬͯ*DFCFSHม׵ Ԡ༻

Slide 39

Slide 39 text

·ͱΊ

Slide 40

Slide 40 text

·ͱΊ ·ͱΊ w"QBDIF*DFCFSH͸ڊେͳ෼ੳςʔϒϧͷͨΊͷߴੑೳͳ ϑΥʔϚοτ wσʔληοτͷૢ࡞Λ؆ૉԽͰ͖Δ wදܗࣜͷσʔλͰ͋Ε͹ɺ*DFCFSHςʔϒϧͰอଘ͢Δ͜ ͱ΋ݕ౼͓ͯ͘͠ͱྑ͍