{"id":4307,"date":"2025-12-31T16:02:41","date_gmt":"2025-12-31T08:02:41","guid":{"rendered":"https:\/\/aws-oncloudai.com\/?p=4307"},"modified":"2025-12-31T16:02:41","modified_gmt":"2025-12-31T08:02:41","slug":"a-comprehensive-analysis-of-aws-athena-pricing-a-practical-strategy-to-save-up-to-90-on-query-costs","status":"publish","type":"post","link":"https:\/\/aws-oncloudai.com\/ko\/aws-athena-\uac00\uaca9-\ucc45\uc815\uc5d0-\ub300\ud55c-\uc885\ud569-\ubd84\uc11d-\ubc0f-\ucffc\ub9ac-\ube44\uc6a9\uc744-\ucd5c\ub300-90\/","title":{"rendered":"AWS Athena \uac00\uaca9 \ucc45\uc815\uc5d0 \ub300\ud55c \uc885\ud569 \ubd84\uc11d: \ucffc\ub9ac \ube44\uc6a9\uc744 \ucd5c\ub300 90%\uae4c\uc9c0 \uc808\uac10\ud560 \uc218 \uc788\ub294 \uc2e4\uc6a9\uc801\uc778 \uc804\ub7b5"},"content":{"rendered":"<p data-start=\"135\" data-end=\"337\">\ud604\ub300\uc758 \ub370\uc774\ud130 \uc911\uc2ec \uae30\uc5c5\uc5d0\uc11c Amazon S3\uc5d0 \uc800\uc7a5\ub41c \ub300\uaddc\ubaa8 \ub370\uc774\ud130\ub97c \uc2e0\uc18d\ud558\uac8c \ubd84\uc11d\ud558\ub294 \uac83\uc740 \ub9e4\uc6b0 \uc911\uc694\ud569\ub2c8\ub2e4. AWS Athena\ub294 \uc0ac\uc6a9\uc790\uac00 \uae30\ubcf8 \uc778\ud504\ub77c\ub97c \uad00\ub9ac\ud560 \ud544\uc694 \uc5c6\uc774 \ud45c\uc900 SQL\uc744 \uc0ac\uc6a9\ud558\uc5ec S3 \ub370\uc774\ud130\ub97c \uc9c1\uc811 \ubd84\uc11d\ud560 \uc218 \uc788\ub3c4\ub85d \uc9c0\uc6d0\ud558\ub294 \uc11c\ubc84\ub9ac\uc2a4 \ub300\ud654\ud615 \ucffc\ub9ac \uc11c\ube44\uc2a4\uc785\ub2c8\ub2e4. \uadf8\ub7ec\ub098 \uae30\uc5c5\uc5d0\uac8c\ub294 Athena\uc758 \ube44\uc6a9\uc744 \uad00\ub9ac\ud558\uace0 \ucffc\ub9ac \ud6a8\uc728\uc131\uc744 \ucd5c\uc801\ud654\ud558\ub294 \uac83\uc774 \ubb34\uc5c7\ubcf4\ub2e4 \uc911\uc694\ud569\ub2c8\ub2e4. \uc774 \uae00\uc5d0\uc11c\ub294 \uc0ac\uc6a9\uc790\uac00 \ube44\uc6a9\uc744 \uc808\uac10\ud558\uba74\uc11c \ub370\uc774\ud130 \ubd84\uc11d \uae30\ub2a5\uc744 \ud5a5\uc0c1\uc2dc\ud0ac \uc218 \uc788\ub3c4\ub85d Athena\uc758 \uac00\uaca9 \ubaa8\ub378, \ube44\uc6a9 \ubc1c\uc0dd \uc694\uc778 \ubc0f \ucd5c\uc801\ud654 \uc804\ub7b5\uc744 \uc790\uc138\ud788 \uc124\uba85\ud569\ub2c8\ub2e4.<\/p>\n<h4 data-start=\"344\" data-end=\"362\">AWS Athena\ub780 \ubb34\uc5c7\uc778\uac00\uc694?<\/h4>\n<p data-start=\"364\" data-end=\"534\">AWS Athena\ub294... <strong data-start=\"379\" data-end=\"394\">\uc11c\ubc84\ub9ac\uc2a4 \ub300\ud654\ud615 \ucffc\ub9ac \uc11c\ube44\uc2a4<\/strong>Athena\ub97c \uc0ac\uc6a9\ud558\uba74 Amazon S3\uc5d0\uc11c SQL \ucffc\ub9ac\ub97c \uc9c1\uc811 \uc2e4\ud589\ud560 \uc218 \uc788\uc2b5\ub2c8\ub2e4. \uc0ac\uc6a9\uc790\ub294 \uc11c\ubc84\ub098 \ud074\ub7ec\uc2a4\ud130\ub97c \uad00\ub9ac\ud560 \ud544\uc694 \uc5c6\uc774 \uc815\ud615 \ubc0f \ubc18\uc815\ud615 \ub370\uc774\ud130\ub97c \uc190\uc27d\uac8c \ubd84\uc11d\ud560 \uc218 \uc788\uc2b5\ub2c8\ub2e4. Athena\ub294 \ud45c\uc900 SQL\uc744 \uc9c0\uc6d0\ud558\uba70 \uba54\ud0c0\ub370\uc774\ud130 \uad00\ub9ac \ubc0f \ub370\uc774\ud130 \uac70\ubc84\ub10c\uc2a4\ub97c \uc704\ud574 AWS Glue \ub370\uc774\ud130 \uce74\ud0c8\ub85c\uadf8\uc640 \ud1b5\ud569\ub429\ub2c8\ub2e4. Athena\ub294 \ucffc\ub9ac\uc5d0\uc11c \uc2a4\uce94\ud55c \ub370\uc774\ud130 \uc591\uc744 \uae30\uc900\uc73c\ub85c \uc694\uae08\uc774 \ubd80\uacfc\ub418\ubbc0\ub85c \ucffc\ub9ac \ud6a8\uc728\uc131\uc774 \ube44\uc6a9\uc5d0 \uc9c1\uc811\uc801\uc778 \uc601\ud5a5\uc744 \ubbf8\uce69\ub2c8\ub2e4.<\/p>\n<h4 data-start=\"541\" data-end=\"559\"><\/h4>\n<h4 data-start=\"541\" data-end=\"559\">AWS Athena \uac00\uaca9 \ucc45\uc815 \uae30\uc900<\/h4>\n<p data-start=\"561\" data-end=\"666\">\uc544\ud14c\ub098\uc758 \uac00\uaca9 \uc815\ucc45\uc740 \ub9e4\uc6b0 \uac04\ub2e8\ud569\ub2c8\ub2e4.<strong data-start=\"576\" data-end=\"593\">\ucffc\ub9ac\ub2f9 \uc2a4\uce94\ub41c \ub370\uc774\ud130 \uc591\uc5d0 \ub530\ub77c \uc694\uae08\uc774 \ubd80\uacfc\ub429\ub2c8\ub2e4.<\/strong>\ud45c\uc900 \uc694\uae08\uc740 \uc2a4\uce94\ub41c \ub370\uc774\ud130 1TB\ub2f9 5\ub2ec\ub7ec\uc785\ub2c8\ub2e4(\ucd5c\uc18c \uc694\uae08\uc740 10MB \uae30\uc900). \ucffc\ub9ac \uc2dc \uc2a4\uce94\ub418\ub294 \ub370\uc774\ud130 \uc591\uc774 \ub9ce\uc744\uc218\ub85d \ube44\uc6a9\uc774 \ub192\uc544\uc9d1\ub2c8\ub2e4. \ub530\ub77c\uc11c \ub370\uc774\ud130 \uc2a4\uce94\ub7c9\uc744 \uc904\uc774\ub3c4\ub85d \ucffc\ub9ac\ub97c \ucd5c\uc801\ud654\ud558\ub294 \uac83\uc774 \ube44\uc6a9 \uc808\uac10\uc758 \ud575\uc2ec\uc785\ub2c8\ub2e4.<\/p>\n<p data-start=\"668\" data-end=\"680\">\ucd94\uac00\ub85c \uace0\ub824\ud574\uc57c \ud560 \ube44\uc6a9\uc740 \ub2e4\uc74c\uacfc \uac19\uc2b5\ub2c8\ub2e4.<\/p>\n<ul data-start=\"682\" data-end=\"927\">\n<li data-start=\"682\" data-end=\"753\">\n<p data-start=\"684\" data-end=\"753\"><strong data-start=\"684\" data-end=\"701\">\uc544\ub9c8\uc874 S3 \uc2a4\ud1a0\ub9ac\uc9c0 \uc218\uc218\ub8cc<\/strong>\uae30\ubcf8 \uc800\uc7a5 \uc6a9\ub7c9\uc740 GB\ub2f9 \uc6d4 0.023\ub2ec\ub7ec\uc785\ub2c8\ub2e4. GET \uc694\uccad, PUT \uc694\uccad \ubc0f \ub370\uc774\ud130 \uc804\uc1a1\uc740 S3 \ud45c\uc900 \uc694\uae08\uc73c\ub85c \uccad\uad6c\ub429\ub2c8\ub2e4.<\/p>\n<\/li>\n<li data-start=\"754\" data-end=\"819\">\n<p data-start=\"756\" data-end=\"819\"><strong data-start=\"756\" data-end=\"774\">AWS Glue \ub370\uc774\ud130 \uce74\ud0c8\ub85c\uadf8 \uc218\uc218\ub8cc<\/strong>\ucd5c\ucd08 100\ub9cc \uac1c \uac1d\uccb4\ub294 \ubb34\ub8cc\uc774\uba70, \uc774\ud6c4 10\ub9cc \uac1c \uac1d\uccb4\ub9c8\ub2e4 \uc6d4 1\ub2ec\ub7ec\uc529 \ubd80\uacfc\ub429\ub2c8\ub2e4. \uc774 \ube44\uc6a9\uc740 \ud14c\uc774\ube14 \ubc0f \uba54\ud0c0\ub370\uc774\ud130 \uad00\ub9ac\uc5d0 \uc0ac\uc6a9\ub429\ub2c8\ub2e4.<\/p>\n<\/li>\n<li data-start=\"820\" data-end=\"883\">\n<p data-start=\"822\" data-end=\"883\"><strong data-start=\"822\" data-end=\"832\">\uacf5\ub3d9 \uc9c8\uc758 \ube44\uc6a9<\/strong>Lambda\ub97c \ud1b5\ud574 \uc678\ubd80 \ub9ac\uc18c\uc2a4(\uc608: RDS, Redshift)\ub97c \ucffc\ub9ac\ud558\uba74 Lambda \ucef4\ud4e8\ud305 \ube44\uc6a9\uc774 \ubc1c\uc0dd\ud569\ub2c8\ub2e4.<\/p>\n<\/li>\n<li data-start=\"884\" data-end=\"927\">\n<p data-start=\"886\" data-end=\"927\"><strong data-start=\"886\" data-end=\"894\">\uc0ac\uc804 \uc124\uc815 \uc6a9\ub7c9<\/strong>\ub300\uaddc\ubaa8 \uc0ac\uc6a9\uc790\uc758 \uacbd\uc6b0, \ud14c\ub77c\ubc14\uc774\ud2b8\ub2f9 \ube44\uc6a9\uc744 \ub354\uc6b1 \uc808\uac10\ud560 \uc218 \uc788\ub3c4\ub85d \ub9de\ucda4\ud615 \uac00\uaca9\uc744 \uc81c\uacf5\ud560 \uc218 \uc788\uc2b5\ub2c8\ub2e4.<\/p>\n<\/li>\n<\/ul>\n<p>&nbsp;<\/p>\n<h4 data-start=\"934\" data-end=\"948\">\uc544\ud14c\ub098 \ube44\uc6a9 \uc608\uc2dc<\/h4>\n<p data-start=\"950\" data-end=\"977\">\uc5b4\ub5a4 \ud68c\uc0ac\uac00 \uc555\ucd95\ub418\uc9c0 \uc54a\uc740 CSV \ud615\uc2dd\uc758 \ub9e4\ucd9c \ub370\uc774\ud130\uac00 3TB \uc788\ub2e4\uace0 \uac00\uc815\ud574 \ubcf4\uaca0\uc2b5\ub2c8\ub2e4.<\/p>\n<div class=\"TyagGW_tableContainer\">\n<div class=\"group TyagGW_tableWrapper flex w-fit flex-col-reverse\" tabindex=\"-1\">\n<table class=\"w-fit min-w-(--thread-content-width)\" data-start=\"979\" data-end=\"1132\">\n<thead data-start=\"979\" data-end=\"1000\">\n<tr data-start=\"979\" data-end=\"1000\">\n<th style=\"text-align: center;\" data-start=\"979\" data-end=\"986\" data-col-size=\"sm\">\ub370\uc774\ud130 \ud615\uc2dd<\/th>\n<th style=\"text-align: center;\" data-start=\"986\" data-end=\"992\" data-col-size=\"sm\">\uc2a4\uce94 \ubcfc\ub968<\/th>\n<th style=\"text-align: center;\" data-start=\"992\" data-end=\"1000\" data-col-size=\"sm\">\uc870\ud68c \ube44\uc6a9<\/th>\n<\/tr>\n<\/thead>\n<tbody data-start=\"1034\" data-end=\"1132\">\n<tr data-start=\"1034\" data-end=\"1062\">\n<td style=\"text-align: center;\" data-start=\"1034\" data-end=\"1043\" data-col-size=\"sm\">CSV \uc6d0\uc2dc<\/td>\n<td style=\"text-align: center;\" data-col-size=\"sm\" data-start=\"1043\" data-end=\"1052\">3TB<\/td>\n<td style=\"text-align: center;\" data-col-size=\"sm\" data-start=\"1052\" data-end=\"1062\">15\ub2ec\ub7ec<\/td>\n<\/tr>\n<tr data-start=\"1063\" data-end=\"1091\">\n<td style=\"text-align: center;\" data-start=\"1063\" data-end=\"1073\" data-col-size=\"sm\">GZIP \uc555\ucd95<\/td>\n<td style=\"text-align: center;\" data-col-size=\"sm\" data-start=\"1073\" data-end=\"1081\">1TB<\/td>\n<td style=\"text-align: center;\" data-col-size=\"sm\" data-start=\"1081\" data-end=\"1091\">5\ub2ec\ub7ec<\/td>\n<\/tr>\n<tr data-start=\"1092\" data-end=\"1132\">\n<td style=\"text-align: center;\" data-start=\"1092\" data-end=\"1111\" data-col-size=\"sm\">Parquet \uceec\ub7fc\ud615 \ud45c\ud604\uc2dd + \uceec\ub7fc \uc120\ud0dd\ub9cc \ud574\ub2f9<\/td>\n<td style=\"text-align: center;\" data-col-size=\"sm\" data-start=\"1111\" data-end=\"1121\">0.33 \ud14c\ub77c\ubc14\uc774\ud2b8<\/td>\n<td style=\"text-align: center;\" data-col-size=\"sm\" data-start=\"1121\" data-end=\"1132\">1.67\ub2ec\ub7ec<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/div>\n<\/div>\n<p data-start=\"1134\" data-end=\"1174\">\uc801\uc808\ud55c \ub370\uc774\ud130 \ud615\uc2dd\uacfc \uc5f4\uc744 \uc120\ud0dd\ud558\uba74 \ud544\uc694\ud55c \ub370\uc774\ud130\ub9cc \uc2a4\uce94\ud560 \uc218 \uc788\uc2b5\ub2c8\ub2e4. <strong data-start=\"1159\" data-end=\"1173\">\uc57d 89%\uc758 \ube44\uc6a9 \uc808\uac10<\/strong>.<\/p>\n<h4 data-start=\"1181\" data-end=\"1204\">Athena \ucffc\ub9ac \ube44\uc6a9\uc744 \uc904\uc774\ub294 5\uac00\uc9c0 \uc804\ub7b5<\/h4>\n<h5 data-start=\"1206\" data-end=\"1234\">1. \uceec\ub7fc\ud615 \uc800\uc7a5 \ud615\uc2dd(Parquet\/ORC)\uc744 \uc0ac\uc6a9\ud558\uc2ed\uc2dc\uc624.<\/h5>\n<p data-start=\"1235\" data-end=\"1331\">\uceec\ub7fc\ud615 \ud3ec\ub9f7\ud305\uc740 \ucffc\ub9ac\uc5d0 \ud544\uc694\ud55c \uceec\ub7fc\ub9cc \uc77d\uc5b4\ub4e4\uc774\ubbc0\ub85c \uc2a4\uce94\ud558\ub294 \ub370\uc774\ud130 \uc591\uc744 \ud06c\uac8c \uc904\uc5ec\uc90d\ub2c8\ub2e4. \uc608\ub97c \ub4e4\uc5b4 CSV \ud30c\uc77c\uc744 Parquet\uc73c\ub85c \ubcc0\ud658\ud558\uace0 \ud575\uc2ec \ud544\ub4dc\ub9cc \ucffc\ub9ac\ud558\uba74 \uc2a4\uce94 \ud06c\uae30\ub97c 3TB\uc5d0\uc11c 0.33TB\ub85c, \ube44\uc6a9\uc740 15\ub2ec\ub7ec\uc5d0\uc11c 1.67\ub2ec\ub7ec\ub85c \uc904\uc77c \uc218 \uc788\uc2b5\ub2c8\ub2e4.<\/p>\n<p data-start=\"1333\" data-end=\"1344\"><strong data-start=\"1333\" data-end=\"1344\">SQL \uc608\uc2dc:<\/strong><\/p>\n<div class=\"contain-inline-size rounded-2xl corner-superellipse\/1.1 relative bg-token-sidebar-surface-primary\">\n<div class=\"sticky top-[calc(--spacing(9)+var(--header-height))] @w-xl\/main:top-9\">\n<div class=\"absolute end-0 bottom-0 flex h-9 items-center pe-2\">\n<div class=\"bg-token-bg-elevated-secondary text-token-text-secondary flex items-center gap-4 rounded-sm px-2 font-sans text-xs\"><\/div>\n<\/div>\n<\/div>\n<div class=\"overflow-y-auto p-4\" dir=\"ltr\"><code class=\"whitespace-pre! language-sql\"><span class=\"hljs-keyword\">\ud14c\uc774\ube14 \uc0dd\uc131<\/span> \ud310\ub9e4_\ud30c\ucf00\ud2b8<br \/>\n<span class=\"hljs-keyword\">\uc640 \ud568\uaed8<\/span> (<br \/>\n\uccb4\uc7ac <span class=\"hljs-operator\">=<\/span> <span class=\"hljs-string\">&#039;\ucabd\ub9e4 \uc138\uacf5&#039;<\/span>,<br \/>\n\uc678\ubd80 \uc704\uce58 <span class=\"hljs-operator\">=<\/span> <span class=\"hljs-string\">&#039;s3your-bucket\/sales_parquet\/&#039;<\/span><br \/>\n) <span class=\"hljs-keyword\">\ucc98\ub7fc<\/span><br \/>\n<span class=\"hljs-keyword\">\uc120\ud0dd\ud558\ub2e4<\/span> <span class=\"hljs-operator\">*<\/span> <span class=\"hljs-keyword\">\uc5d0\uc11c<\/span> \ud310\ub9e4 CSV;<br \/>\n<\/code><\/div>\n<\/div>\n<h5 data-start=\"1504\" data-end=\"1518\">2. \ub370\uc774\ud130\ub97c \ubd84\ud560\ud569\ub2c8\ub2e4.<\/h5>\n<p data-start=\"1519\" data-end=\"1610\">\ub0a0\uc9dc \ubc0f \uc9c0\uc5ed\uacfc \uac19\uc740 \uc18d\uc131\uc744 \uae30\uc900\uc73c\ub85c \ub370\uc774\ud130\ub97c \ubd84\ud560\ud558\uba74 Athena\uac00 \uad00\ub828 \ud30c\ud2f0\uc158\ub9cc \uc2a4\uce94\ud558\ub3c4\ub85d \uc81c\ud55c\ud560 \uc218 \uc788\uc2b5\ub2c8\ub2e4.<br data-start=\"1555\" data-end=\"1558\" \/>\uc608\ub97c \ub4e4\uc5b4, \uc6d4\ubcc4\ub85c \ubd84\ud560\ub41c 1TB \ub370\uc774\ud130 \uc138\ud2b8\uc5d0\uc11c 1\uc6d4 \ub370\uc774\ud130\ub9cc \uc870\ud68c\ud558\ub294 \uacbd\uc6b0 \uc57d 83GB\ub97c \uc2a4\uce94\ud558\uba70 \ube44\uc6a9\uc740 \uc57d 0.42\ub2ec\ub7ec\uc785\ub2c8\ub2e4.<\/p>\n<p data-start=\"1612\" data-end=\"1623\"><strong data-start=\"1612\" data-end=\"1623\">SQL \uc608\uc2dc:<\/strong><\/p>\n<div class=\"contain-inline-size rounded-2xl corner-superellipse\/1.1 relative bg-token-sidebar-surface-primary\">\n<div class=\"sticky top-[calc(--spacing(9)+var(--header-height))] @w-xl\/main:top-9\">\n<div class=\"absolute end-0 bottom-0 flex h-9 items-center pe-2\">\n<div class=\"bg-token-bg-elevated-secondary text-token-text-secondary flex items-center gap-4 rounded-sm px-2 font-sans text-xs\"><\/div>\n<\/div>\n<\/div>\n<div class=\"overflow-y-auto p-4\" dir=\"ltr\"><code class=\"whitespace-pre! language-sql\"><span class=\"hljs-keyword\">\ub9cc\ub4e4\ub2e4<\/span> <span class=\"hljs-keyword\">\uc678\ubd80<\/span> <span class=\"hljs-keyword\">\ud14c\uc774\ube14<\/span> \ud310\ub9e4 \ubd84\ud560\ub428(<br \/>\n\ud310\ub9e4 \uae08\uc561 <span class=\"hljs-keyword\">\ub354\ube14<\/span><br \/>\n)<br \/>\n\ubd84\ud560\ub428 <span class=\"hljs-keyword\">\uc5d0 \uc758\ud574<\/span> (<span class=\"hljs-keyword\">\ub144\ub3c4<\/span> \ub048, <span class=\"hljs-keyword\">\uc6d4<\/span> \ub048)<br \/>\n\uc800\uc7a5\ub428 <span class=\"hljs-keyword\">\ucc98\ub7fc<\/span> \ucabd\ub9e4 \uc138\uacf5<br \/>\n\uc704\uce58 <span class=\"hljs-string\">&#039;s3your-bucket\/sales_partitioned\/&#039;<\/span>;<br \/>\n<\/code><\/div>\n<\/div>\n<h5 data-start=\"1816\" data-end=\"1829\">3. \ub370\uc774\ud130 \ud30c\uc77c \uc555\ucd95<\/h5>\n<p data-start=\"1830\" data-end=\"1911\">GZIP\uc774\ub098 Snappy\uc640 \uac19\uc740 \uc555\ucd95 \ud615\uc2dd\uc744 \uc0ac\uc6a9\ud558\uba74 \ud30c\uc77c \ud06c\uae30\ub97c \ud06c\uac8c \uc904\uc77c \uc218 \uc788\uc2b5\ub2c8\ub2e4. GZIP\uc740 \uc57d 3:1\uc758 \uc555\ucd95\ub960\uc744 \uc81c\uacf5\ud558\uba70, Snappy\ub294 \ub354 \ube60\ub978 \ucffc\ub9ac \uc18d\ub3c4\ub97c \uc81c\uacf5\ud569\ub2c8\ub2e4. \uc555\ucd95\uc744 \ud1b5\ud574 \ucffc\ub9ac \uc2dc \uc2a4\uce94\ud574\uc57c \ud558\ub294 \ub370\uc774\ud130 \uc591\uc774 \uc904\uc5b4\ub4e4\uc5b4 \ube44\uc6a9\uc774 \uc808\uac10\ub429\ub2c8\ub2e4.<\/p>\n<h5 data-start=\"1918\" data-end=\"1958\">4. EXPLAIN \ub610\ub294 EXPLAIN ANALYZE\ub97c \uc0ac\uc6a9\ud558\uc5ec \ucffc\ub9ac\ub97c \ucd5c\uc801\ud654\ud569\ub2c8\ub2e4.<\/h5>\n<p data-start=\"1959\" data-end=\"2061\">Athena\ub294 \ucffc\ub9ac \uc2e4\ud589 \uacc4\ud68d \ubd84\uc11d \uae30\ub2a5\uc744 \uc81c\uacf5\ud558\uc5ec \uc2a4\uce94\ub41c \ub370\uc774\ud130 \uc591\uacfc \uc2e4\ud589 \uacc4\ud68d\uc744 \ud45c\uc2dc\ud568\uc73c\ub85c\uc368 \ube44\ud6a8\uc728\uc801\uc778 \ucffc\ub9ac\ub97c \uc2dd\ubcc4\ud558\ub294 \ub370 \ub3c4\uc6c0\uc744 \uc90d\ub2c8\ub2e4. \uc608\ub97c \ub4e4\uc5b4, WHERE \uc808\uc5d0 \ud544\ud130 \uc870\uac74\uc744 \ucd94\uac00\ud558\uba74 \uc2a4\uce94 \ud06c\uae30\ub97c 500GB\uc5d0\uc11c 50GB\ub85c \uc904\uc5ec \ucffc\ub9ac\ub2f9 \uc57d 2.25\ub2ec\ub7ec\ub97c \uc808\uc57d\ud560 \uc218 \uc788\uc2b5\ub2c8\ub2e4.<\/p>\n<h5 data-start=\"2068\" data-end=\"2094\">5. Apache Iceberg \ud14c\uc774\ube14 \ud65c\uc6a9<\/h5>\n<p data-start=\"2095\" data-end=\"2163\">Iceberg \ud14c\uc774\ube14\uc740 ACID \ud2b8\ub79c\uc7ad\uc158, \uc228\uaca8\uc9c4 \ud30c\ud2f0\uc158 \ubc0f \uc5f4 \ud1b5\uacc4\ub97c \uc9c0\uc6d0\ud558\uc5ec \uc2a4\uce94\ud558\ub294 \ub370\uc774\ud130 \uc591\uc744 \uc904\uc774\uace0 \ucffc\ub9ac \uc131\ub2a5\uc744 \ud5a5\uc0c1\uc2dc\ud0ac \uc218 \uc788\uc2b5\ub2c8\ub2e4. \uc5f4 \uae30\ubc18 \uc2a4\ud1a0\ub9ac\uc9c0 \ubc0f \ud30c\ud2f0\uc154\ub2dd\uacfc \uacb0\ud569\ud558\uba74 \ucffc\ub9ac \ube44\uc6a9\uc744 \ub354\uc6b1 \uc808\uac10\ud560 \uc218 \uc788\uc2b5\ub2c8\ub2e4.<\/p>\n<p data-start=\"2165\" data-end=\"2176\"><strong data-start=\"2165\" data-end=\"2176\">SQL \uc608\uc2dc:<\/strong><\/p>\n<div class=\"contain-inline-size rounded-2xl corner-superellipse\/1.1 relative bg-token-sidebar-surface-primary\">\n<div class=\"sticky top-[calc(--spacing(9)+var(--header-height))] @w-xl\/main:top-9\">\n<div class=\"absolute end-0 bottom-0 flex h-9 items-center pe-2\">\n<div class=\"bg-token-bg-elevated-secondary text-token-text-secondary flex items-center gap-4 rounded-sm px-2 font-sans text-xs\"><\/div>\n<\/div>\n<\/div>\n<div class=\"overflow-y-auto p-4\" dir=\"ltr\"><code class=\"whitespace-pre! language-sql\"><span class=\"hljs-keyword\">\ud14c\uc774\ube14 \uc0dd\uc131<\/span> \ud310\ub9e4\ube59\uc0b0<br \/>\n<span class=\"hljs-keyword\">\uc640 \ud568\uaed8<\/span> (<br \/>\n\ud14c\uc774\ube14 \uc720\ud615 <span class=\"hljs-operator\">=<\/span> <span class=\"hljs-string\">&#039;\ube59\uc0b0&#039;<\/span>,<br \/>\n\uccb4\uc7ac <span class=\"hljs-operator\">=<\/span> <span class=\"hljs-string\">&#039;\ucabd\ub9e4 \uc138\uacf5&#039;<\/span>,<br \/>\n\uc704\uce58 <span class=\"hljs-operator\">=<\/span> <span class=\"hljs-string\">&#039;s3your-bucket\/sales_iceberg\/&#039;<\/span><br \/>\n) <span class=\"hljs-keyword\">\ucc98\ub7fc<\/span><br \/>\n<span class=\"hljs-keyword\">\uc120\ud0dd\ud558\ub2e4<\/span> <span class=\"hljs-operator\">*<\/span> <span class=\"hljs-keyword\">\uc5d0\uc11c<\/span> \ud310\ub9e4 CSV;<br \/>\n<\/code><\/div>\n<\/div>\n<p>&nbsp;<\/p>\n<h4 data-start=\"2353\" data-end=\"2375\">\uc0ac\ub840 \uc5f0\uad6c: \uc18c\ub9e4\uc5c5\uccb4, \uac80\uc0c9 \ube44\uc6a9 80% \uc808\uac10<\/h4>\n<p data-start=\"2377\" data-end=\"2421\">\uc911\uacac \uc18c\ub9e4\uc5c5\uccb4\ub294 10TB\uc758 \ub9e4\ucd9c \ub370\uc774\ud130\ub97c \ubcf4\uc720\ud558\uace0 \uc788\uc73c\uba70, \ub370\uc774\ud130 \uc870\ud68c \ud55c \uac74\ub2f9 \ucd5c\ub300 50\ub2ec\ub7ec\uc758 \ube44\uc6a9\uc774 \ubc1c\uc0dd\ud569\ub2c8\ub2e4. \ub2e4\uc74c \uc804\ub7b5\uc744 \uc2e4\ud589\ud558\uba74 \uc774\ub7ec\ud55c \ube44\uc6a9\uc744 \uc808\uac10\ud560 \uc218 \uc788\uc2b5\ub2c8\ub2e4.<\/p>\n<ul data-start=\"2423\" data-end=\"2480\">\n<li data-start=\"2423\" data-end=\"2442\">\n<p data-start=\"2425\" data-end=\"2442\">Parquet \uceec\ub7fc\ud615 \uc2a4\ud1a0\ub9ac\uc9c0\ub85c \ubcc0\ud658<\/p>\n<\/li>\n<li data-start=\"2443\" data-end=\"2452\">\n<p data-start=\"2445\" data-end=\"2452\">\ub0a0\uc9dc\ubcc4 \ubd84\ud560<\/p>\n<\/li>\n<li data-start=\"2453\" data-end=\"2480\">\n<p data-start=\"2455\" data-end=\"2480\">EXPLAIN ANALYZE\ub97c \uc0ac\uc6a9\ud558\uc5ec \ucffc\ub9ac\ub97c \ucd5c\uc801\ud654\ud558\uc138\uc694<\/p>\n<\/li>\n<\/ul>\n<p data-start=\"2482\" data-end=\"2546\">\uc2a4\uce94 \uc6a9\ub7c9\uc774 2TB\ub85c \uc904\uc5b4\ub4e4\uace0 \ucffc\ub9ac\ub2f9 \ube44\uc6a9\uc774 10\ub2ec\ub7ec\ub85c \uac10\uc18c\ud558\uc5ec \uc57d 801 TP3T\uc758 \ube44\uc6a9 \uc808\uac10 \ud6a8\uacfc\ub97c \uc5bb\uc5c8\uc2b5\ub2c8\ub2e4. AWS \ube44\uc6a9 \uad00\ub9ac \ub3c4\uad6c\ub97c \uc0ac\uc6a9\ud55c \ubaa8\ub2c8\ud130\ub9c1\uc744 \ud1b5\ud574 \ucffc\ub9ac \ube44\uc6a9\uc744 \ud6a8\uacfc\uc801\uc73c\ub85c \uad00\ub9ac\ud560 \uc218 \uc788\uc2b5\ub2c8\ub2e4.<\/p>\n<h4 data-start=\"2553\" data-end=\"2562\">\uc790\uc8fc \ubb3b\ub294 \uc9c8\ubb38<\/h4>\n<h5 data-start=\"2564\" data-end=\"2588\"><strong data-start=\"2564\" data-end=\"2586\">Q1: Athena \ucffc\ub9ac \ud55c \uac74\ub2f9 \ube44\uc6a9\uc740 \uc5bc\ub9c8\uc778\uac00\uc694?<\/strong><\/h5>\n<ul data-start=\"2589\" data-end=\"2624\">\n<li data-start=\"2589\" data-end=\"2624\">\n<p data-start=\"2591\" data-end=\"2624\">\uc694\uae08\uc740 \uc2a4\uce94\ud55c \ub370\uc774\ud130 \uc591\uc5d0 \ub530\ub77c \ubd80\uacfc\ub418\uba70, TB\ub2f9 5\ub2ec\ub7ec\ubd80\ud130 \uc2dc\uc791\ud558\uace0 \ucd5c\uc18c \ucffc\ub9ac \ud06c\uae30\ub294 10MB\uc785\ub2c8\ub2e4.<\/p>\n<\/li>\n<\/ul>\n<h5 data-start=\"2626\" data-end=\"2644\"><strong data-start=\"2626\" data-end=\"2642\">Q2: \uc870\ud68c\uc5d0 \uc2e4\ud328\ud560 \uacbd\uc6b0 \uc694\uae08\uc774 \ubd80\uacfc\ub418\ub098\uc694?<\/strong><\/h5>\n<ul data-start=\"2645\" data-end=\"2672\">\n<li data-start=\"2645\" data-end=\"2672\">\n<p data-start=\"2647\" data-end=\"2672\">\uc544\ub2c8\uc694, Athena\ub294 DDL\uc774\ub098 \uc2e4\ud328\ud55c \ucffc\ub9ac\uc5d0 \ub300\ud574 \uc694\uae08\uc744 \ubd80\uacfc\ud558\uc9c0 \uc54a\uc2b5\ub2c8\ub2e4.<\/p>\n<\/li>\n<\/ul>\n<h5 data-start=\"2674\" data-end=\"2701\"><strong data-start=\"2674\" data-end=\"2699\">\uc9c8\ubb38 3: Athena\ub97c \ud65c\uc6a9\ud558\uc5ec \ube44\uc6a9 \uc808\uac10\uc744 \uadf9\ub300\ud654\ud558\ub294 \ubc29\ubc95\uc740 \ubb34\uc5c7\uc785\ub2c8\uae4c?<\/strong><\/h5>\n<ul data-start=\"2702\" data-end=\"2803\">\n<li data-start=\"2702\" data-end=\"2725\">\n<p data-start=\"2704\" data-end=\"2725\">\uceec\ub7fc\ud615 \ud615\uc2dd(Parquet\/ORC)\uc744 \uc0ac\uc6a9\ud558\uc138\uc694.<\/p>\n<\/li>\n<li data-start=\"2726\" data-end=\"2737\">\n<p data-start=\"2728\" data-end=\"2737\">\ub370\uc774\ud130\ub97c \ubd84\ud560\ud558\uc138\uc694<\/p>\n<\/li>\n<li data-start=\"2738\" data-end=\"2748\">\n<p data-start=\"2740\" data-end=\"2748\">\uc555\ucd95\ub41c \ub370\uc774\ud130 \ud30c\uc77c<\/p>\n<\/li>\n<li data-start=\"2749\" data-end=\"2784\">\n<p data-start=\"2751\" data-end=\"2784\">EXPLAIN\/EXPLAIN ANALYZE\ub97c \uc0ac\uc6a9\ud558\uc5ec \ucffc\ub9ac\ub97c \ucd5c\uc801\ud654\ud558\uc138\uc694<\/p>\n<\/li>\n<li data-start=\"2785\" data-end=\"2803\">\n<p data-start=\"2787\" data-end=\"2803\">\uc544\uc774\uc2a4\ubc84\uadf8 \ud14c\uc774\ube14 \uae30\ub2a5 \uc0ac\uc6a9\ud558\uae30<\/p>\n<\/li>\n<\/ul>\n<h4 data-start=\"2810\" data-end=\"2815\"><\/h4>\n<h4 data-start=\"2810\" data-end=\"2815\">\uc694\uc57d\ud558\ub2e4<\/h4>\n<p data-start=\"2817\" data-end=\"2949\">AWS Athena\ub294 \ud22c\uba85\ud55c \uc2a4\uce94\ub2f9 \ube44\uc6a9 \uccad\uad6c \ubaa8\ub378\uc744 \ud1b5\ud574 \ube44\uc6a9\uc744 \ud6a8\uc728\uc801\uc73c\ub85c \uad00\ub9ac\ud560 \uc218 \uc788\ub294 \uc720\uc5f0\ud55c \uc11c\ubc84\ub9ac\uc2a4 \ub370\uc774\ud130 \ubd84\uc11d \uae30\ub2a5\uc744 \uc81c\uacf5\ud569\ub2c8\ub2e4. \uceec\ub7fc\ud615 \uc2a4\ud1a0\ub9ac\uc9c0, \ub370\uc774\ud130 \ud30c\ud2f0\uc154\ub2dd, \uc555\ucd95, Iceberg \ub4f1\uc758 \ucd5c\uc801\ud654 \uc804\ub7b5\uc744 \ud65c\uc6a9\ud558\uba74 \uae30\uc5c5\uc740 \ucffc\ub9ac \ube44\uc6a9\uc744 \ucd5c\ub300 901 TP3T\uae4c\uc9c0 \uc808\uac10\ud560 \uc218 \uc788\uc2b5\ub2c8\ub2e4. \uc774\ub7ec\ud55c \uae30\ubc95\uc744 \uc219\ub2ec\ud558\uba74 \ucffc\ub9ac \ud6a8\uc728\uc131\uc744 \ud5a5\uc0c1\uc2dc\ud0a4\uace0 \uc608\uc0b0\uc744 \ud6a8\uacfc\uc801\uc73c\ub85c \uad00\ub9ac\ud558\uba70 \ub370\uc774\ud130 \ubd84\uc11d\uc758 \uac00\uce58\ub97c \uadf9\ub300\ud654\ud560 \uc218 \uc788\uc2b5\ub2c8\ub2e4.<\/p>","protected":false},"excerpt":{"rendered":"<p>\ud604\ub300\uc758 \ub370\uc774\ud130 \uc911\uc2ec \uae30\uc5c5\uc5d0\uc11c Amazon S3\uc5d0 \uc800\uc7a5\ub41c \ub300\uaddc\ubaa8 \ub370\uc774\ud130\ub97c \uc2e0\uc18d\ud558\uac8c \ubd84\uc11d\ud558\ub294 \uac83\uc740 \ub9e4\uc6b0 \uc911\uc694\ud569\ub2c8\ub2e4. AWS Athena\ub294 \uc0ac\uc6a9\uc790\uac00 \uae30\ubcf8 \uc778\ud504\ub77c\ub97c \uad00\ub9ac\ud560 \ud544\uc694 \uc5c6\uc774 \ud45c\uc900 SQL\uc744 \uc0ac\uc6a9\ud558\uc5ec S3 \ub370\uc774\ud130\ub97c \uc9c1\uc811 \ubd84\uc11d\ud560 \uc218 \uc788\ub3c4\ub85d \uc9c0\uc6d0\ud558\ub294 \uc11c\ubc84\ub9ac\uc2a4 \ub300\ud654\ud615 \ucffc\ub9ac \uc11c\ube44\uc2a4\uc785\ub2c8\ub2e4. \uadf8\ub7ec\ub098 \uae30\uc5c5\uc5d0\uac8c\ub294 Athena\uc758 \ube44\uc6a9\uc744 \uad00\ub9ac\ud558\uace0 \ucffc\ub9ac \ud6a8\uc728\uc131\uc744 \ucd5c\uc801\ud654\ud558\ub294 \uac83\uc774 \ubb34\uc5c7\ubcf4\ub2e4 \uc911\uc694\ud569\ub2c8\ub2e4. \uc774 \uae00\uc5d0\uc11c\ub294 \uc0ac\uc6a9\uc790\uac00 \ube44\uc6a9\uc744 \uc808\uac10\ud558\uba74\uc11c \ub370\uc774\ud130 \ubd84\uc11d \uae30\ub2a5\uc744 \ud5a5\uc0c1\uc2dc\ud0ac \uc218 \uc788\ub3c4\ub85d Athena\uc758 \uac00\uaca9 \ubaa8\ub378, \ube44\uc6a9 \ubc1c\uc0dd \uc694\uc778 \ubc0f \ucd5c\uc801\ud654 \uc804\ub7b5\uc744 \uc790\uc138\ud788 \uc124\uba85\ud569\ub2c8\ub2e4.<\/p>","protected":false},"author":1,"featured_media":4308,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[65],"tags":[],"class_list":["post-4307","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-technical-sharing"],"_links":{"self":[{"href":"https:\/\/aws-oncloudai.com\/ko\/wp-json\/wp\/v2\/posts\/4307","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/aws-oncloudai.com\/ko\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/aws-oncloudai.com\/ko\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/aws-oncloudai.com\/ko\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/aws-oncloudai.com\/ko\/wp-json\/wp\/v2\/comments?post=4307"}],"version-history":[{"count":2,"href":"https:\/\/aws-oncloudai.com\/ko\/wp-json\/wp\/v2\/posts\/4307\/revisions"}],"predecessor-version":[{"id":4311,"href":"https:\/\/aws-oncloudai.com\/ko\/wp-json\/wp\/v2\/posts\/4307\/revisions\/4311"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/aws-oncloudai.com\/ko\/wp-json\/wp\/v2\/media\/4308"}],"wp:attachment":[{"href":"https:\/\/aws-oncloudai.com\/ko\/wp-json\/wp\/v2\/media?parent=4307"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/aws-oncloudai.com\/ko\/wp-json\/wp\/v2\/categories?post=4307"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/aws-oncloudai.com\/ko\/wp-json\/wp\/v2\/tags?post=4307"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}