{"id":296,"date":"2024-09-19T02:45:14","date_gmt":"2024-09-19T02:45:14","guid":{"rendered":"https:\/\/www.nnt-consulting.com\/tech\/blog\/?p=296"},"modified":"2024-11-29T01:40:59","modified_gmt":"2024-11-29T01:40:59","slug":"gcp-bigquery-clustering","status":"publish","type":"post","link":"https:\/\/www.nnt-consulting.com\/tech\/blog\/gcp-bigquery-clustering\/","title":{"rendered":"GCP BigQuery Clustering \uc0b4\ud3b4\ubcf4\uae30"},"content":{"rendered":"<div class=\"wp-block-image\">\n<figure class=\"aligncenter size-medium\"><img loading=\"lazy\" decoding=\"async\" width=\"300\" height=\"300\" src=\"https:\/\/www.nnt-consulting.com\/tech\/blog\/wp-content\/uploads\/2024\/07\/bigquery-300x300.png\" alt=\"\" class=\"wp-image-66\" srcset=\"https:\/\/www.nnt-consulting.com\/tech\/blog\/wp-content\/uploads\/2024\/07\/bigquery-300x300.png 300w, https:\/\/www.nnt-consulting.com\/tech\/blog\/wp-content\/uploads\/2024\/07\/bigquery-150x150.png 150w, https:\/\/www.nnt-consulting.com\/tech\/blog\/wp-content\/uploads\/2024\/07\/bigquery-500x500.png 500w, https:\/\/www.nnt-consulting.com\/tech\/blog\/wp-content\/uploads\/2024\/07\/bigquery.png 512w\" sizes=\"auto, (max-width: 300px) 100vw, 300px\" \/><figcaption class=\"wp-element-caption\">GCP BigQuery \bClustering \uc0b4\ud3b4\ubcf4\uae30<\/figcaption><\/figure>\n<\/div>\n\n\n<p><\/p>\n\n\n\n<div id=\"ez-toc-container\" class=\"ez-toc-v2_0_83 counter-hierarchy ez-toc-counter ez-toc-grey ez-toc-container-direction\">\n<div class=\"ez-toc-title-container\">\n<p class=\"ez-toc-title\" style=\"cursor:inherit\">Table of Contents<\/p>\n<span class=\"ez-toc-title-toggle\"><a href=\"#\" class=\"ez-toc-pull-right ez-toc-btn ez-toc-btn-xs ez-toc-btn-default ez-toc-toggle\" aria-label=\"\ubaa9\ucc28 \ud1a0\uae00\"><span class=\"ez-toc-js-icon-con\"><span class=\"\"><span class=\"eztoc-hide\" style=\"display:none;\">Toggle<\/span><span class=\"ez-toc-icon-toggle-span\"><svg style=\"fill: #999;color:#999\" xmlns=\"http:\/\/www.w3.org\/2000\/svg\" class=\"list-377408\" width=\"20px\" height=\"20px\" viewBox=\"0 0 24 24\" fill=\"none\"><path d=\"M6 6H4v2h2V6zm14 0H8v2h12V6zM4 11h2v2H4v-2zm16 0H8v2h12v-2zM4 16h2v2H4v-2zm16 0H8v2h12v-2z\" fill=\"currentColor\"><\/path><\/svg><svg style=\"fill: #999;color:#999\" class=\"arrow-unsorted-368013\" xmlns=\"http:\/\/www.w3.org\/2000\/svg\" width=\"10px\" height=\"10px\" viewBox=\"0 0 24 24\" version=\"1.2\" baseProfile=\"tiny\"><path d=\"M18.2 9.3l-6.2-6.3-6.2 6.3c-.2.2-.3.4-.3.7s.1.5.3.7c.2.2.4.3.7.3h11c.3 0 .5-.1.7-.3.2-.2.3-.5.3-.7s-.1-.5-.3-.7zM5.8 14.7l6.2 6.3 6.2-6.3c.2-.2.3-.5.3-.7s-.1-.5-.3-.7c-.2-.2-.4-.3-.7-.3h-11c-.3 0-.5.1-.7.3-.2.2-.3.5-.3.7s.1.5.3.7z\"\/><\/svg><\/span><\/span><\/span><\/a><\/span><\/div>\n<nav><ul class='ez-toc-list ez-toc-list-level-1 ' ><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-1\" href=\"https:\/\/www.nnt-consulting.com\/tech\/blog\/gcp-bigquery-clustering\/#%EB%93%A4%EC%96%B4%EA%B0%80%EB%A9%B0\" >\ub4e4\uc5b4\uac00\uba70<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-2\" href=\"https:\/\/www.nnt-consulting.com\/tech\/blog\/gcp-bigquery-clustering\/#%ED%81%B4%EB%9F%AC%EC%8A%A4%ED%84%B0%EB%A7%81Clustering%EC%9D%B4%EB%9E%80\" >\ud074\ub7ec\uc2a4\ud130\ub9c1(Clustering)\uc774\ub780?<\/a><ul class='ez-toc-list-level-3' ><li class='ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-3\" href=\"https:\/\/www.nnt-consulting.com\/tech\/blog\/gcp-bigquery-clustering\/#BigQuery_Clustering%EC%9D%98_%EA%B8%B0%EB%B3%B8_%EA%B0%9C%EB%85%90\" >BigQuery Clustering\uc758 \uae30\ubcf8 \uac1c\ub150<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-4\" href=\"https:\/\/www.nnt-consulting.com\/tech\/blog\/gcp-bigquery-clustering\/#%ED%81%B4%EB%9F%AC%EC%8A%A4%ED%84%B0%EB%A7%81%EB%90%9C_%ED%85%8C%EC%9D%B4%EB%B8%94%EA%B3%BC_%ED%91%9C%EC%A4%80_%ED%85%8C%EC%9D%B4%EB%B8%94_%EB%B9%84%EA%B5%90\" >\ud074\ub7ec\uc2a4\ud130\ub9c1\ub41c \ud14c\uc774\ube14\uacfc \ud45c\uc900 \ud14c\uc774\ube14 \ube44\uad50<\/a><ul class='ez-toc-list-level-4' ><li class='ez-toc-heading-level-4'><a class=\"ez-toc-link ez-toc-heading-5\" href=\"https:\/\/www.nnt-consulting.com\/tech\/blog\/gcp-bigquery-clustering\/#%ED%91%9C%EC%A4%80_%ED%85%8C%EC%9D%B4%EB%B8%94\" >\ud45c\uc900 \ud14c\uc774\ube14<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-4'><a class=\"ez-toc-link ez-toc-heading-6\" href=\"https:\/\/www.nnt-consulting.com\/tech\/blog\/gcp-bigquery-clustering\/#%ED%81%B4%EB%9F%AC%EC%8A%A4%ED%84%B0%EB%A7%81%EB%90%9C_%ED%85%8C%EC%9D%B4%EB%B8%94Clustered_Table\" >\ud074\ub7ec\uc2a4\ud130\ub9c1\ub41c \ud14c\uc774\ube14(Clustered Table)<\/a><\/li><\/ul><\/li><li class='ez-toc-page-1 ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-7\" href=\"https:\/\/www.nnt-consulting.com\/tech\/blog\/gcp-bigquery-clustering\/#Clustered_Table%EC%9D%B4_%ED%95%84%EC%9A%94%ED%95%9C_%EA%B2%BD%EC%9A%B0\" >Clustered Table\uc774 \ud544\uc694\ud55c \uacbd\uc6b0<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-8\" href=\"https:\/\/www.nnt-consulting.com\/tech\/blog\/gcp-bigquery-clustering\/#Clustered_Table%EA%B3%BC_Partitioned_Table%EC%9D%84_%EA%B2%B0%ED%95%A9%ED%95%98%EA%B8%B0\" >Clustered Table\uacfc Partitioned Table\uc744 \uacb0\ud569\ud558\uae30<\/a><\/li><\/ul><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-9\" href=\"https:\/\/www.nnt-consulting.com\/tech\/blog\/gcp-bigquery-clustering\/#%EA%B2%B0%EB%A1%A0\" >\uacb0\ub860<\/a><\/li><\/ul><\/nav><\/div>\n<h2 class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"%EB%93%A4%EC%96%B4%EA%B0%80%EB%A9%B0\"><\/span>\ub4e4\uc5b4\uac00\uba70<span class=\"ez-toc-section-end\"><\/span><\/h2>\n\n\n\n<p>\ub370\uc774\ud130\uc758 \uc591\uc774 \uae30\ud558\uae09\uc218\uc801\uc73c\ub85c \uc99d\uac00\ud568\uc5d0 \ub530\ub77c, \ub370\uc774\ud130 \ubd84\uc11d\uc758 \uc131\ub2a5\uc744 \uadf9\ub300\ud654\ud558\ub294 \uac83\uc740 \ubaa8\ub4e0 \uae30\uc5c5\uc5d0\uac8c \uc911\uc694\ud55c \uacfc\uc81c\uac00 \ub418\uc5c8\uc2b5\ub2c8\ub2e4. <a href=\"https:\/\/www.nnt-consulting.com\/tech\/blog\/gcp-bigquery-partitioning\/\">\uc55e\uc120 \uae00<\/a>\uc5d0\uc11c\ub294 BigQuery\uc5d0\uc11c \ud30c\ud2f0\uc154\ub2dd(Partitioning)\uc744 \ud1b5\ud574 \ucffc\ub9ac \uc131\ub2a5\uacfc \ube44\uc6a9\uc744 \ucd5c\uc801\ud654\ud558\ub294 \ubc29\ubc95\uc744 \uc18c\uac1c\ud588\uc2b5\ub2c8\ub2e4. \uadf8\ub7ec\ub098 \ud30c\ud2f0\uc154\ub2dd\ub9cc\uc73c\ub85c\ub294 \ucda9\ubd84\ud558\uc9c0 \uc54a\uc740 \uacbd\uc6b0\ub3c4 \ub9ce\uc2b5\ub2c8\ub2e4. \ud2b9\ud788, \ubcf5\uc7a1\ud55c \ucffc\ub9ac\uc5d0\uc11c \uc5ec\ub7ec \uc5f4\uc744 \uae30\uc900\uc73c\ub85c \ud544\ud130\ub9c1\ud574\uc57c \ud558\uac70\ub098, \ub370\uc774\ud130\uc758 \ubb3c\ub9ac\uc801 \uc815\ub82c\uc744 \ud1b5\ud574 \ub354\uc6b1 \ube60\ub978 \ubd84\uc11d\uc774 \ud544\uc694\ud55c \uacbd\uc6b0\uac00 \uc788\uc2b5\ub2c8\ub2e4.<\/p>\n\n\n\n<p>\uc774\ub54c \ud65c\uc6a9\ud560 \uc218 \uc788\ub294 \ubc29\ubc95\uc774 \ubc14\ub85c <a href=\"https:\/\/cloud.google.com\/bigquery\/docs\/clustered-tables?hl=ko\" target=\"_blank\" rel=\"noopener\">\ud074\ub7ec\uc2a4\ud130\ub9c1(Clustering)<\/a>\uc785\ub2c8\ub2e4. \ud074\ub7ec\uc2a4\ud130\ub9c1\uc740 \ud2b9\uc815 \uc5f4\uc744 \uae30\uc900\uc73c\ub85c \ub370\uc774\ud130\ub97c \ubb3c\ub9ac\uc801\uc73c\ub85c \uc815\ub82c\ud558\uc5ec \ucffc\ub9ac \uc131\ub2a5\uc744 \ud06c\uac8c \ud5a5\uc0c1\uc2dc\ud0a4\ub294 \ubc29\ubc95\uc785\ub2c8\ub2e4. \uc774\ubc88 \uae00\uc5d0\uc11c\ub294 \ud074\ub7ec\uc2a4\ud130\ub9c1\uc758 \uac1c\ub150\uacfc \uc774\ub97c \ud6a8\uacfc\uc801\uc73c\ub85c \ud65c\uc6a9\ud558\ub294 \ubc29\ubc95\uc5d0 \ub300\ud574 \uc790\uc138\ud788 \uc0b4\ud3b4\ubcf4\uaca0\uc2b5\ub2c8\ub2e4.<\/p>\n\n\n\n<p><\/p>\n\n\n\n<h2 class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"%ED%81%B4%EB%9F%AC%EC%8A%A4%ED%84%B0%EB%A7%81Clustering%EC%9D%B4%EB%9E%80\"><\/span>\ud074\ub7ec\uc2a4\ud130\ub9c1(Clustering)\uc774\ub780?<span class=\"ez-toc-section-end\"><\/span><\/h2>\n\n\n\n<h3 class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"BigQuery_Clustering%EC%9D%98_%EA%B8%B0%EB%B3%B8_%EA%B0%9C%EB%85%90\"><\/span>BigQuery Clustering\uc758 \uae30\ubcf8 \uac1c\ub150<span class=\"ez-toc-section-end\"><\/span><\/h3>\n\n\n\n<p>\ud074\ub7ec\uc2a4\ud130\ub9c1\uc740 \ub370\uc774\ud130\ub97c \ud2b9\uc815 \uc5f4 \ub610\ub294 \uc5f4\uc758 \uc9d1\ud569\uc744 \uae30\uc900\uc73c\ub85c \ubb3c\ub9ac\uc801\uc73c\ub85c \uc815\ub82c\ud558\uc5ec \ucffc\ub9ac \uc131\ub2a5\uc744 \ucd5c\uc801\ud654\ud558\ub294 \ubc29\ubc95\uc785\ub2c8\ub2e4. \ud074\ub7ec\uc2a4\ud130\ub9c1\ub41c \ud14c\uc774\ube14\uc740 \ucffc\ub9ac \uc2e4\ud589 \uc2dc, \ud544\ud130 \uc870\uac74\uacfc \uc77c\uce58\ud558\ub294 \ub370\uc774\ud130\ub9cc \ube60\ub974\uac8c \uac80\uc0c9\ud560 \uc218 \uc788\ub3c4\ub85d \ubb3c\ub9ac\uc801\uc73c\ub85c \uc815\ub82c\ub41c \ub370\uc774\ud130\ub97c \uc2a4\uce94\ud569\ub2c8\ub2e4. \uc774\ub85c \uc778\ud574, \uc804\uccb4 \ud14c\uc774\ube14\uc744 \uc2a4\uce94\ud558\ub294 \uc2dc\uac04\uc774 \uc904\uc5b4\ub4e4\uace0 \ube44\uc6a9\uc774 \uc808\uac10\ub429\ub2c8\ub2e4. <\/p>\n\n\n\n<p>\uc608\ub97c \ub4e4\uc5b4, \uace0\uac1d \uc8fc\ubb38 \ub370\uc774\ud130\uc5d0\uc11c \uc8fc\ubb38 \ub0a0\uc9dc\uc640 \uace0\uac1d ID\ub97c \uae30\uc900\uc73c\ub85c \ud074\ub7ec\uc2a4\ud130\ub9c1\ud558\uba74, \uace0\uac1d\ubcc4\ub85c \uc8fc\ubb38 \ub370\uc774\ud130\ub97c \uc870\ud68c\ud558\uac70\ub098 \ud2b9\uc815 \ub0a0\uc9dc\uc758 \ub370\uc774\ud130\ub97c \ube60\ub974\uac8c \ucc3e\uc744 \uc218 \uc788\uc2b5\ub2c8\ub2e4. \ud074\ub7ec\uc2a4\ud130\ub9c1\uc740 \ub370\uc774\ud130\ub97c \uc815\ub82c\ub41c \uc0c1\ud0dc\ub85c \uc720\uc9c0\ud558\uc5ec \ucffc\ub9ac\uc758 I\/O \uc791\uc5c5\uc744 \ucd5c\uc18c\ud654\ud558\uace0, \ud2b9\ud788 \ub300\uaddc\ubaa8 \ub370\uc774\ud130\uc14b\uc5d0\uc11c \ub6f0\uc5b4\ub09c \uc131\ub2a5\uc744 \ubc1c\ud718\ud569\ub2c8\ub2e4. <\/p>\n\n\n\n<p>\ud074\ub7ec\uc2a4\ud130\ub9c1\uc740 \ud30c\ud2f0\uc154\ub2dd\uacfc \ub2ec\ub9ac \uc5ec\ub7ec \uc5f4\uc744 \uae30\uc900\uc73c\ub85c \uc815\ub82c\ud560 \uc218 \uc788\uae30 \ub54c\ubb38\uc5d0, \ubcf5\uc7a1\ud55c \ucffc\ub9ac\uc5d0\uc11c \ub354\uc6b1 \uc720\uc6a9\ud569\ub2c8\ub2e4. \ud558\uc9c0\ub9cc \ud074\ub7ec\uc2a4\ud130\ub9c1\uc774 \ud56d\uc0c1 \ud544\uc694\ud55c \uac83\uc740 \uc544\ub2c8\uba70, \uc0ac\uc6a9\ud558\ub824\ub294 \ub370\uc774\ud130\uc14b\uacfc \ucffc\ub9ac \ud328\ud134\uc744 \uc798 \uc774\ud574\ud55c \ud6c4 \uc801\uc6a9\ud558\ub294 \uac83\uc774 \uc911\uc694\ud569\ub2c8\ub2e4.<\/p>\n\n\n\n<h3 class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"%ED%81%B4%EB%9F%AC%EC%8A%A4%ED%84%B0%EB%A7%81%EB%90%9C_%ED%85%8C%EC%9D%B4%EB%B8%94%EA%B3%BC_%ED%91%9C%EC%A4%80_%ED%85%8C%EC%9D%B4%EB%B8%94_%EB%B9%84%EA%B5%90\"><\/span>\ud074\ub7ec\uc2a4\ud130\ub9c1\ub41c \ud14c\uc774\ube14\uacfc \ud45c\uc900 \ud14c\uc774\ube14 \ube44\uad50<span class=\"ez-toc-section-end\"><\/span><\/h3>\n\n\n\n<p>\ud074\ub7ec\uc2a4\ud130\ub9c1\uc774 \uc801\uc6a9\ub41c \ud14c\uc774\ube14\uacfc \uc801\uc6a9\ub418\uc9c0 \uc54a\uc740 \ud45c\uc900 \ud14c\uc774\ube14\uc740 \ucffc\ub9ac \uc131\ub2a5\uc5d0\uc11c \ud070 \ucc28\uc774\ub97c \ubcf4\uc785\ub2c8\ub2e4. \uc774\ub97c \uc774\ud574\ud558\uae30 \uc704\ud574 \ub450 \ud14c\uc774\ube14\uc744 \ube44\uad50\ud574 \ubcf4\uaca0\uc2b5\ub2c8\ub2e4.<\/p>\n\n\n\n<h4 class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"%ED%91%9C%EC%A4%80_%ED%85%8C%EC%9D%B4%EB%B8%94\"><\/span>\ud45c\uc900 \ud14c\uc774\ube14<span class=\"ez-toc-section-end\"><\/span><\/h4>\n\n\n\n<p>\uc608\ub97c \ub4e4\uc5b4, \uc544\ub798\uc640 \uac19\uc740 \ucffc\ub9ac\ub97c \uc0b4\ud3b4\ubd05\uc2dc\ub2e4.<\/p>\n\n\n\n<pre title=\"\ud074\ub7ec\uc2a4\ud130\ub9c1 \uc5c6\ub294 \ud45c\uc900 \ud14c\uc774\ube14 \uc0dd\uc131 \ucffc\ub9ac\" class=\"wp-block-code\"><code lang=\"sql\" class=\"language-sql line-numbers\">CREATE OR REPLACE TABLE `TEST_DATASET_US.test_table_standard` AS (\n  SELECT\n    *\n  FROM\n    `bigquery-public-data.google_trends.top_terms`\n  WHERE\n    week BETWEEN \"2015-09-15\" AND \"2024-09-15\"\n);<\/code><\/pre>\n\n\n\n<p>\uc704 \ucffc\ub9ac\ub294 \uad6c\uae00\uc774 \uc81c\uacf5\ud558\ub294 \ube45\ucffc\ub9ac \ud37c\ube14\ub9ad \ub370\uc774\ud130\uc5d0 \uc788\ub294 \uad6c\uae00 \ud2b8\ub80c\ub4dc \ub370\uc774\ud130\uc138\ud2b8\uc5d0\uc11c <code>top_terms<\/code> \ud14c\uc774\ube14\uc744 \uac00\uc838\uc640 \ud074\ub7ec\uc2a4\ud130\ub9c1 \ub418\uc9c0 \uc54a\uc740 \ud45c\uc900 \ud14c\uc774\ube14\ub85c \uc800\uc7a5\ud558\ub294 \ucffc\ub9ac\uc785\ub2c8\ub2e4.<\/p>\n\n\n\n<p>\ud574\ub2f9 \ud14c\uc774\ube14\uc5d0\uc11c week = &#8220;2024-06-30&#8221;, term = &#8220;F1&#8221; \uc778 \ud589\uc744 \uc870\ud68c\ud55c\ub2e4\uace0 \uc0dd\uac01\ud574 \ubd05\uc2dc\ub2e4.<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code lang=\"sql\" class=\"language-sql line-numbers\">SELECT\n  *\nFROM\n  `TEST_DATASET_US.test_table_not_partitioned`\nWHERE\n  week = \"2024-06-23\"\n  AND term = \"F1\"<\/code><\/pre>\n\n\n\n<p>\ud14c\uc774\ube14 \uc2a4\ud1a0\ub9ac\uc9c0 \uc804\uccb4 \uc6a9\ub7c9\uacfc \ucffc\ub9ac\uc5d0 \uc758\ud574 \ucc98\ub9ac\ub41c \ubc14\uc774\ud2b8\ub97c \ube44\uad50\ud558\uba74, \ud574\ub2f9 \ucffc\ub9ac\uac00 \uc804\uccb4 \ud14c\uc774\ube14\uc744 \uc2a4\uce94\ud588\ub2e4\ub294 \uac83\uc744 \uc54c \uc218 \uc788\uc2b5\ub2c8\ub2e4.<\/p>\n\n\n\n<p>\uc774\ucc98\ub7fc \ud074\ub7ec\uc2a4\ud130\ub9c1\uc774 \ub418\uc9c0 \uc54a\uc740 \ud45c\uc900 \ud14c\uc774\ube14\uc5d0\uc11c\uc758 \ucffc\ub9ac\uc758 \uacbd\uc6b0, \uc804\uccb4 \ud14c\uc774\ube14\uc744 \ubaa8\ub450 \uc2a4\uce94\ud55c \ud6c4, \ud544\uc694\ud55c \ud589\ub9cc\uc744 \ubc18\ud658\ud558\ub294 \uac83\uc744 \uc54c \uc218 \uc788\uc2b5\ub2c8\ub2e4.<\/p>\n\n\n\n<h4 class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"%ED%81%B4%EB%9F%AC%EC%8A%A4%ED%84%B0%EB%A7%81%EB%90%9C_%ED%85%8C%EC%9D%B4%EB%B8%94Clustered_Table\"><\/span>\ud074\ub7ec\uc2a4\ud130\ub9c1\ub41c \ud14c\uc774\ube14(Clustered Table)<span class=\"ez-toc-section-end\"><\/span><\/h4>\n\n\n\n<p>\uc774\ubc88\uc5d0\ub294 week, term, dma_id \uc5f4\uc744 \uae30\uc900\uc73c\ub85c \ud074\ub7ec\uc2a4\ud130\ub9c1\ub41c \ud14c\uc774\ube14\uc744 \ub9cc\ub4e4\uc5b4 \ubd05\uc2dc\ub2e4.<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code lang=\"sql\" class=\"language-sql line-numbers\">CREATE OR REPLACE TABLE `TEST_DATASET_US.test_table_clustered`\nCLUSTER BY \n  week,\n  term,\n  dma_id\nAS (\n  SELECT\n    *\n  FROM\n    `bigquery-public-data.google_trends.top_terms`\n  WHERE\n    week BETWEEN \"2015-09-15\" AND \"2024-09-15\"\n);<\/code><\/pre>\n\n\n\n<p>week \uc5f4\uc758 \uacbd\uc6b0 DATE \ud0c0\uc785\uc774\uba70, term \uc5f4\uc758 \uacbd\uc6b0 STRING, dma_id \uc5f4\uc758 \uacbd\uc6b0 INTEGER \ud0c0\uc785\uc774\uae30 \ub54c\ubb38\uc5d0 \ubc14\ub85c \ud074\ub7ec\uc2a4\ud130\ub9c1 \uae30\uc900\uc5d0 \ud3ec\ud568\ud560 \uc218 \uc788\uc2b5\ub2c8\ub2e4.<\/p>\n\n\n\n<p>\ub9cc\ub4e4\uc5b4\uc9c4 \ud14c\uc774\ube14\uc758 \uacbd\uc6b0, \uae30\uc874 \ud45c\uc900 \ud14c\uc774\ube14\uacfc \ube44\uad50\ud588\uc744 \ub54c \ud14c\uc774\ube14\uc774 \ucc28\uc9c0\ud558\ub294 \uc2a4\ud1a0\ub9ac\uc9c0 \uc6a9\ub7c9\uc740 \ub2e4\ub974\uc9c0 \uc54a\uc2b5\ub2c8\ub2e4. \ud558\uc9c0\ub9cc week, term, dam_id \uc5f4\uc744 \uae30\uc900\uc73c\ub85c \ud074\ub7ec\uc2a4\ud130\ub9c1 \ub418\uc5b4\uc788\uae30 \ub54c\ubb38\uc5d0, \ud074\ub7ec\uc2a4\ud130\ub9c1\ub41c \uc5f4\uc744 \uae30\ubc18\uc73c\ub85c \ud544\ud130 \uc870\uac74\uc744 \uc0ac\uc6a9\ud560 \ub54c BigQuery\ub294 \ub370\uc774\ud130\ub97c \uc815\ub82c\ub41c \uc21c\uc11c\ub300\ub85c \ube60\ub974\uac8c \ucc3e\uc744 \uc218 \uc788\uc5b4 \uc804\uccb4 \ud14c\uc774\ube14\uc744 \uc2a4\uce94\ud558\uc9c0 \uc54a\uc544\ub3c4 \ub429\ub2c8\ub2e4.<\/p>\n\n\n\n<p>\ud14c\uc774\ube14\uc744 \uc2a4\uce94\ud558\uae30 \uc774\uc804\uc5d0 \uc608\uce21\ub418\ub294 \ucffc\ub9ac \ucc98\ub9ac \ubc14\uc774\ud2b8\ub7c9\uc740 \ub3d9\uc77c\ud558\uc9c0\ub9cc, \uc2e4\uc81c \ucffc\ub9ac \uc2dc\uc5d0\ub294 \ub354 \uc801\uc740 \ucc98\ub9ac \ubc14\uc774\ud2b8\ub97c \uc0ac\uc6a9\ud558\uac8c \ub429\ub2c8\ub2e4.<\/p>\n\n\n\n<p>\uacb0\uacfc\uc801\uc73c\ub85c, \ud074\ub7ec\uc2a4\ud130\ub9c1\ub41c \ud14c\uc774\ube14\uc740 \ud2b9\uc815 \uc5f4\uc5d0 \ub300\ud55c \ud544\ud130\ub9c1\uc774 \uc790\uc8fc \ubc1c\uc0dd\ud558\ub294 \uacbd\uc6b0, \ud2b9\ud788 \ub370\uc774\ud130\uc14b\uc774 \ud074 \ub54c \ub354\uc6b1 \uc720\ub9ac\ud569\ub2c8\ub2e4. \uc774\ub97c \ud1b5\ud574 \ucffc\ub9ac \uc131\ub2a5\uc774 \ud06c\uac8c \ud5a5\uc0c1\ub418\uba70, \ubd88\ud544\uc694\ud55c I\/O \uc791\uc5c5\uc774 \uc904\uc5b4\ub4e4\uc5b4 \ube44\uc6a9 \uc808\uac10 \ud6a8\uacfc\ub3c4 \uae30\ub300\ud560 \uc218 \uc788\uc2b5\ub2c8\ub2e4.<\/p>\n\n\n\n<h3 class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"Clustered_Table%EC%9D%B4_%ED%95%84%EC%9A%94%ED%95%9C_%EA%B2%BD%EC%9A%B0\"><\/span>Clustered Table\uc774 \ud544\uc694\ud55c \uacbd\uc6b0<span class=\"ez-toc-section-end\"><\/span><\/h3>\n\n\n\n<p>\ud074\ub7ec\uc2a4\ud130\ub9c1\uc740 \ubaa8\ub4e0 \ub370\uc774\ud130\uc14b\uc5d0\uc11c \ubc18\ub4dc\uc2dc \ud544\uc694\ud55c \uac83\uc740 \uc544\ub2c8\uc9c0\ub9cc, \ud2b9\uc815 \uc0c1\ud669\uc5d0\uc11c\ub294 \ub9e4\uc6b0 \uc720\uc6a9\ud55c \uc131\ub2a5 \ucd5c\uc801\ud654 \ub3c4\uad6c\uac00 \ub420 \uc218 \uc788\uc2b5\ub2c8\ub2e4. \ub2e4\uc74c\uacfc \uac19\uc740 \uacbd\uc6b0\uc5d0 \ud074\ub7ec\uc2a4\ud130\ub9c1\uc744 \uace0\ub824\ud558\ub294 \uac83\uc774 \uc88b\uc2b5\ub2c8\ub2e4.<\/p>\n\n\n\n<ol class=\"wp-block-list\">\n<li><strong>\uc790\uc8fc \ud544\ud130\ub9c1\ub418\ub294 \uc5ec\ub7ec \uc5f4\uc774 \uc788\ub294 \uacbd\uc6b0<\/strong>\n<ul class=\"wp-block-list\">\n<li>\ud074\ub7ec\uc2a4\ud130\ub9c1\uc740 \ud55c \ubc88\uc5d0 \uc5ec\ub7ec \uc5f4\uc744 \uae30\uc900\uc73c\ub85c \ub370\uc774\ud130\ub97c \ubb3c\ub9ac\uc801\uc73c\ub85c \uc815\ub82c\ud560 \uc218 \uc788\uc2b5\ub2c8\ub2e4. \ud2b9\uc815 \uc5f4\uc774\ub098 \uc5f4\uc758 \uc870\ud569\uc744 \uae30\uc900\uc73c\ub85c \ub370\uc774\ud130\ub97c \uc790\uc8fc \ud544\ud130\ub9c1\ud558\ub294 \uacbd\uc6b0, \ud074\ub7ec\uc2a4\ud130\ub9c1\ub41c \ud14c\uc774\ube14\uc744 \uc0ac\uc6a9\ud558\uba74 \ub370\uc774\ud130 \uc870\ud68c \uc18d\ub3c4\ub97c \ud06c\uac8c \ud5a5\uc0c1\uc2dc\ud0ac \uc218 \uc788\uc2b5\ub2c8\ub2e4. \uc608\ub97c \ub4e4\uc5b4, \uace0\uac1d ID\uc640 \uc8fc\ubb38 \ub0a0\uc9dc\ub97c \uae30\uc900\uc73c\ub85c \ub370\uc774\ud130\ub97c \uc790\uc8fc \uc870\ud68c\ud558\ub294 \uacbd\uc6b0, <code>customer_id<\/code>\uc640 <code>order_date<\/code> \uc5f4\uc744 \uae30\uc900\uc73c\ub85c \ud074\ub7ec\uc2a4\ud130\ub9c1\ud558\uba74 \ud6e8\uc52c \ub354 \ud6a8\uc728\uc801\uc778 \ucffc\ub9ac\uac00 \uac00\ub2a5\ud569\ub2c8\ub2e4.<\/li>\n<\/ul>\n<\/li>\n<\/ol>\n\n\n\n<ol start=\"2\" class=\"wp-block-list\">\n<li><strong>\ubc94\uc704 \uac80\uc0c9\uc774 \uc790\uc8fc \uc774\ub8e8\uc5b4\uc9c0\ub294 \uacbd\uc6b0<\/strong>\n<ul class=\"wp-block-list\">\n<li>\ud074\ub7ec\uc2a4\ud130\ub9c1\uc740 \uc815\ub82c\ub41c \ub370\uc774\ud130\uc5d0 \ub300\ud574 \ubc94\uc704 \uac80\uc0c9\uc744 \uc218\ud589\ud560 \ub54c \ud070 \uc774\uc810\uc744 \uc81c\uacf5\ud569\ub2c8\ub2e4. \uc608\ub97c \ub4e4\uc5b4, \uc8fc\uae30\uc801\uc73c\ub85c \ud2b9\uc815 \ub0a0\uc9dc \ubc94\uc704\uc758 \ub370\uc774\ud130\ub97c \uc870\ud68c\ud558\uac70\ub098, ID \ubc94\uc704\ub97c \uae30\uc900\uc73c\ub85c \ub370\uc774\ud130\ub97c \ubd84\uc11d\ud560 \ub54c \ud074\ub7ec\uc2a4\ud130\ub9c1\ub41c \ud14c\uc774\ube14\uc740 \ud544\uc694\ud558\uc9c0 \uc54a\uc740 \ub370\uc774\ud130\uc758 \uc2a4\uce94\uc744 \uc904\uc5ec \uc131\ub2a5\uc744 \uadf9\ub300\ud654\ud560 \uc218 \uc788\uc2b5\ub2c8\ub2e4. \ud2b9\ud788 \uc2dc\uac04 \uae30\ubc18 \ub370\uc774\ud130, \ud2b8\ub79c\uc7ad\uc158 \uae30\ub85d, \ub85c\uadf8 \ub370\uc774\ud130\uc5d0\uc11c \uc720\uc6a9\ud558\uac8c \uc801\uc6a9\ub429\ub2c8\ub2e4.<\/li>\n<\/ul>\n<\/li>\n<\/ol>\n\n\n\n<ol start=\"3\" class=\"wp-block-list\">\n<li><strong>\ub370\uc774\ud130\uc758 \ud06c\uae30\uac00 \ub9e4\uc6b0 \ud070 \uacbd\uc6b0<\/strong>\n<ul class=\"wp-block-list\">\n<li>\ub300\uaddc\ubaa8 \ub370\uc774\ud130\uc14b\uc5d0\uc11c \uc804\uccb4 \ub370\uc774\ud130\ub97c \uc2a4\uce94\ud558\ub294 \uac83\uc740 \ub9ce\uc740 \ube44\uc6a9\uacfc \uc2dc\uac04\uc774 \uc18c\uc694\ub429\ub2c8\ub2e4. \ud074\ub7ec\uc2a4\ud130\ub9c1\uc740 \ub370\uc774\ud130\uac00 \ubb3c\ub9ac\uc801\uc73c\ub85c \uc815\ub82c\ub418\uc5b4 \uc788\uae30 \ub54c\ubb38\uc5d0 \ud544\uc694\ud55c \ub370\uc774\ud130\ub9cc \ube60\ub974\uac8c \ucc3e\uc744 \uc218 \uc788\uc5b4, \ub300\uc6a9\ub7c9 \ub370\uc774\ud130\uc14b\uc5d0\uc11c \uc131\ub2a5\uc744 \uadf9\ub300\ud654\ud560 \uc218 \uc788\uc2b5\ub2c8\ub2e4. \uc774\ub7ec\ud55c \uc774\uc720\ub85c, \ub300\uaddc\ubaa8 \ub85c\uadf8 \ub370\uc774\ud130\ub098 \uc6f9 \ud2b8\ub798\ud53d \ubd84\uc11d \ub370\uc774\ud130\uc640 \uac19\uc740 \ub300\uc6a9\ub7c9 \ub370\uc774\ud130\uc14b\uc5d0\uc11c \ud074\ub7ec\uc2a4\ud130\ub9c1\uc774 \uc720\uc6a9\ud569\ub2c8\ub2e4.<\/li>\n<\/ul>\n<\/li>\n<\/ol>\n\n\n\n<ol start=\"4\" class=\"wp-block-list\">\n<li><strong>\ub2e4\uc591\ud55c \ud544\ud130 \uc870\uac74\uc73c\ub85c \ub370\uc774\ud130 \ubd84\uc11d\uc774 \ud544\uc694\ud55c \uacbd\uc6b0<\/strong>\n<ul class=\"wp-block-list\">\n<li>\ud558\ub098\uc758 \ud14c\uc774\ube14\uc5d0\uc11c \uc5ec\ub7ec \uc5f4\uc744 \uc870\ud569\ud55c \ub2e4\uc591\ud55c \ud544\ud130 \uc870\uac74\uc744 \uc790\uc8fc \uc0ac\uc6a9\ud558\ub294 \uacbd\uc6b0, \ud074\ub7ec\uc2a4\ud130\ub9c1\uc774 \uc801\ud569\ud569\ub2c8\ub2e4. \ud074\ub7ec\uc2a4\ud130\ub9c1\uc740 \ud30c\ud2f0\uc154\ub2dd\uacfc \ub2ec\ub9ac \uc5ec\ub7ec \uc5f4\uc5d0 \ub300\ud574 \ucffc\ub9ac\ub97c \ucd5c\uc801\ud654\ud560 \uc218 \uc788\uc73c\ubbc0\ub85c, \ub2e4\uc591\ud55c \ud544\ud130 \uc870\uac74\uc744 \uc0ac\uc6a9\ud558\ub294 \ubcf5\uc7a1\ud55c \ucffc\ub9ac\uc5d0\uc11c \uc131\ub2a5\uc744 \ud5a5\uc0c1\uc2dc\ud0ac \uc218 \uc788\uc2b5\ub2c8\ub2e4. \uc608\ub97c \ub4e4\uc5b4, \uace0\uac1d ID, \uc8fc\ubb38 \ub0a0\uc9dc, \uc8fc\ubb38 \uc0c1\ud0dc\uc640 \uac19\uc740 \uc5ec\ub7ec \uae30\uc900\uc744 \ub3d9\uc2dc\uc5d0 \ud544\ud130\ub9c1\ud574\uc57c \ud558\ub294 \uc0c1\ud669\uc5d0\uc11c \ud074\ub7ec\uc2a4\ud130\ub9c1\uc740 \ub9e4\uc6b0 \ud6a8\uc728\uc801\uc785\ub2c8\ub2e4.<\/li>\n<\/ul>\n<\/li>\n<\/ol>\n\n\n\n<ol start=\"5\" class=\"wp-block-list\">\n<li><strong>\ud2b9\uc815 \ub370\uc774\ud130 \ud544\ud130\ub9c1 \ub610\ub294 \uc9d1\uacc4\uac00 \uc790\uc8fc \uc774\ub8e8\uc5b4\uc9c0\ub294 \uacbd\uc6b0<\/strong>\n<ul class=\"wp-block-list\">\n<li>\ud074\ub7ec\uc2a4\ud130\ub9c1\uc740 \ub370\uc774\ud130\ub97c \ud6a8\uc728\uc801\uc73c\ub85c \uc815\ub82c\ud574\ub450\uae30 \ub54c\ubb38\uc5d0, \ud2b9\uc815 \uc5f4\uc5d0 \ub300\ud55c \ud544\ud130\ub9c1\uacfc \uc9d1\uacc4 \ucffc\ub9ac\uac00 \uc790\uc8fc \ubc1c\uc0dd\ud558\ub294 \uc0c1\ud669\uc5d0\uc11c \uc720\ub9ac\ud569\ub2c8\ub2e4. \uc608\ub97c \ub4e4\uc5b4, \ud2b9\uc815 \uc9c0\uc5ed\uc758 \ub9e4\ucd9c \ub370\uc774\ud130\ub97c \uc790\uc8fc \ubd84\uc11d\ud558\ub294 \uacbd\uc6b0, \uc9c0\uc5ed\ubcc4\ub85c \ud074\ub7ec\uc2a4\ud130\ub9c1\ub41c \ud14c\uc774\ube14\uc744 \uc0ac\uc6a9\ud558\uba74 \ubd84\uc11d \uc18d\ub3c4\uac00 \ud06c\uac8c \uac1c\uc120\ub429\ub2c8\ub2e4.<\/li>\n<\/ul>\n<\/li>\n<\/ol>\n\n\n\n<p>Clustered Table\uc774 \ud544\uc694\ud558\uc9c0 \uc54a\uc740 \uacbd\uc6b0<\/p>\n\n\n\n<p>\ubaa8\ub4e0 \uacbd\uc6b0\uc5d0 \ud074\ub7ec\uc2a4\ud130\ub9c1\uc774 \ucd5c\uc801\uc758 \uc120\ud0dd\uc740 \uc544\ub2d9\ub2c8\ub2e4. \ub370\uc774\ud130\uc14b\uc758 \uaddc\ubaa8\ub098 \ucffc\ub9ac \ud328\ud134\uc5d0 \ub530\ub77c \ud074\ub7ec\uc2a4\ud130\ub9c1\uc758 \uc774\uc810\uc774 \ud06c\uc9c0 \uc54a\uc740 \uacbd\uc6b0\ub3c4 \uc788\uc2b5\ub2c8\ub2e4.<\/p>\n\n\n\n<ol class=\"wp-block-list\">\n<li><strong>\uc791\uc740 \ub370\uc774\ud130\uc14b<\/strong>\n<ul class=\"wp-block-list\">\n<li>\ub370\uc774\ud130\uc14b\uc774 \uc791\uc740 \uacbd\uc6b0\uc5d0\ub294 \ud074\ub7ec\uc2a4\ud130\ub9c1\uc758 \uc131\ub2a5 \uac1c\uc120 \ud6a8\uacfc\uac00 \ubbf8\ubbf8\ud560 \uc218 \uc788\uc2b5\ub2c8\ub2e4. \uc791\uc740 \ud14c\uc774\ube14\uc5d0\uc11c \ucffc\ub9ac\ub97c \uc2e4\ud589\ud558\ub294 \uacbd\uc6b0, \uc804\uccb4 \ud14c\uc774\ube14\uc744 \uc2a4\uce94\ud574\ub3c4 \ube44\uc6a9\uc774\ub098 \uc2dc\uac04\uc774 \ud06c\uac8c \uc99d\uac00\ud558\uc9c0 \uc54a\uc73c\ubbc0\ub85c \ud074\ub7ec\uc2a4\ud130\ub9c1\uc774 \ud070 \ucc28\uc774\ub97c \ub9cc\ub4e4\uc9c0 \ubabb\ud560 \uc218 \uc788\uc2b5\ub2c8\ub2e4.<\/li>\n<\/ul>\n<\/li>\n\n\n\n<li><strong>\uc804\uccb4 \ub370\uc774\ud130\ub97c \uc790\uc8fc \uc870\ud68c\ud558\ub294 \uacbd\uc6b0<\/strong>\n<ul class=\"wp-block-list\">\n<li>\ud074\ub7ec\uc2a4\ud130\ub9c1\uc740 \ud2b9\uc815 \uc5f4\uc744 \uae30\uc900\uc73c\ub85c \ub370\uc774\ud130\ub97c \uc815\ub82c\ud558\uc5ec \uc77c\ubd80 \ub370\uc774\ud130\ub9cc \uc870\ud68c\ud560 \ub54c \uc774\uc810\uc744 \uc81c\uacf5\ud569\ub2c8\ub2e4. \ud558\uc9c0\ub9cc \uc804\uccb4 \ub370\uc774\ud130\ub97c \uc790\uc8fc \uc870\ud68c\ud558\ub294 \uacbd\uc6b0\uc5d0\ub294 \ud074\ub7ec\uc2a4\ud130\ub9c1\uc758 \ud6a8\uacfc\uac00 \uc81c\ud55c\uc801\uc785\ub2c8\ub2e4. \uc774 \uacbd\uc6b0\uc5d0\ub294 \ub370\uc774\ud130 \uc804\uccb4\ub97c \uc2a4\uce94\ud574\uc57c \ud558\ubbc0\ub85c, \ud074\ub7ec\uc2a4\ud130\ub9c1\uc73c\ub85c \uc778\ud55c \uc131\ub2a5 \ud5a5\uc0c1\uc740 \ud06c\uc9c0 \uc54a\uc744 \uc218 \uc788\uc2b5\ub2c8\ub2e4.<\/li>\n<\/ul>\n<\/li>\n\n\n\n<li><strong>\ud074\ub7ec\uc2a4\ud130\ub9c1 \uae30\uc900\uc774 \uc790\uc8fc \ubc14\ub00c\ub294 \uacbd\uc6b0<\/strong>\n<ul class=\"wp-block-list\">\n<li>\ud074\ub7ec\uc2a4\ud130\ub9c1\ub41c \uc5f4\uc774 \uc790\uc8fc \ubc14\ub00c\ub294 \uacbd\uc6b0, \ud074\ub7ec\uc2a4\ud130\ub9c1\uc758 \uc720\uc9c0 \uad00\ub9ac\uac00 \ubcf5\uc7a1\ud574\uc9c8 \uc218 \uc788\uc2b5\ub2c8\ub2e4. \ud074\ub7ec\uc2a4\ud130\ub9c1\uc740 \ub370\uc774\ud130\ub97c \ubb3c\ub9ac\uc801\uc73c\ub85c \uc815\ub82c\ud558\uae30 \ub54c\ubb38\uc5d0, \uc5f4\uc774 \uc790\uc8fc \ubcc0\uacbd\ub418\uba74 \ub2e4\uc2dc \uc815\ub82c\ud558\ub294 \ub370 \uc2dc\uac04\uc774 \uac78\ub9ac\uba70, \uc131\ub2a5\uc774 \uc624\ud788\ub824 \uc800\ud558\ub420 \uc218 \uc788\uc2b5\ub2c8\ub2e4.<\/li>\n<\/ul>\n<\/li>\n<\/ol>\n\n\n\n<p>\uc774\ucc98\ub7fc, \ud074\ub7ec\uc2a4\ud130\ub9c1\uc740 \ud2b9\uc815 \uc870\uac74\uc5d0\uc11c \ub9e4\uc6b0 \uc720\uc6a9\ud55c \uc131\ub2a5 \ucd5c\uc801\ud654 \ub3c4\uad6c\uc774\uc9c0\ub9cc, \ubaa8\ub4e0 \uc0c1\ud669\uc5d0\uc11c \ubc18\ub4dc\uc2dc \ud544\uc694\ud55c \uac83\uc740 \uc544\ub2d9\ub2c8\ub2e4. \ub370\uc774\ud130\uc758 \ud2b9\uc131\uacfc \ucffc\ub9ac \ud328\ud134\uc744 \ucda9\ubd84\ud788 \uace0\ub824\ud558\uc5ec \ud074\ub7ec\uc2a4\ud130\ub9c1\uc744 \uc801\uc808\ud788 \uc0ac\uc6a9\ud558\ub294 \uac83\uc774 \uc911\uc694\ud569\ub2c8\ub2e4.<\/p>\n\n\n\n<h3 class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"Clustered_Table%EA%B3%BC_Partitioned_Table%EC%9D%84_%EA%B2%B0%ED%95%A9%ED%95%98%EA%B8%B0\"><\/span>Clustered Table\uacfc Partitioned Table\uc744 \uacb0\ud569\ud558\uae30<span class=\"ez-toc-section-end\"><\/span><\/h3>\n\n\n\n<p>\ud074\ub7ec\uc2a4\ud130\ub9c1\uacfc \ud30c\ud2f0\uc154\ub2dd\uc740 \uac01\uac01\uc758 \uae30\ub2a5\ub9cc\uc73c\ub85c\ub3c4 BigQuery\uc5d0\uc11c \ucffc\ub9ac \uc131\ub2a5\uc744 \ucd5c\uc801\ud654\ud560 \uc218 \uc788\uc9c0\ub9cc, \ub450 \uac00\uc9c0\ub97c \ud568\uaed8 \uc0ac\uc6a9\ud558\uba74 \ub354\uc6b1 \uac15\ub825\ud55c \uc131\ub2a5 \uac1c\uc120\uc744 \uc774\ub04c\uc5b4\ub0bc \uc218 \uc788\uc2b5\ub2c8\ub2e4. \ud30c\ud2f0\uc154\ub2dd\uc740 \ub370\uc774\ud130\ub97c \ud070 \ubc94\uc704\ub85c \ub098\ub204\uc5b4 \ubd88\ud544\uc694\ud55c \ub370\uc774\ud130 \uc2a4\uce94\uc744 \uc904\uc5ec\uc8fc\uace0, \ud074\ub7ec\uc2a4\ud130\ub9c1\uc740 \ud30c\ud2f0\uc158 \ub0b4\uc5d0\uc11c \ub370\uc774\ud130\ub97c \uc815\ub82c\ud574 \uc138\ubd80\uc801\uc778 \uac80\uc0c9 \uc131\ub2a5\uc744 \ucd5c\uc801\ud654\ud569\ub2c8\ub2e4.<\/p>\n\n\n\n<p>\ub450 \uae30\ubc95\uc744 \uacb0\ud569\ud558\uba74 \ub2e4\uc74c\uacfc \uac19\uc740 \uc7a5\uc810\uc774 \uc788\uc2b5\ub2c8\ub2e4.<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li><strong>\ucffc\ub9ac \uc131\ub2a5 \uac1c\uc120<\/strong>: \ub370\uc774\ud130\uc758 \ud070 \ubc94\uc704\ub294 \ud30c\ud2f0\uc154\ub2dd\uc73c\ub85c \uad00\ub9ac\ud558\uace0, \ud544\uc694\ud55c \uc138\ubd80 \ub370\uc774\ud130\ub294 \ud074\ub7ec\uc2a4\ud130\ub9c1\uc73c\ub85c \ube60\ub974\uac8c \uac80\uc0c9\ud558\uc5ec \uc131\ub2a5\uc744 \uadf9\ub300\ud654\ud560 \uc218 \uc788\uc2b5\ub2c8\ub2e4.<\/li>\n\n\n\n<li><strong>\ube44\uc6a9 \uc808\uac10<\/strong>: \ucffc\ub9ac \uc2dc \uc2a4\uce94\ud574\uc57c \ud558\ub294 \ub370\uc774\ud130 \uc591\uc744 \ucd5c\uc18c\ud654\ud558\uc5ec \ucffc\ub9ac \ube44\uc6a9\uc744 \ud6a8\uc728\uc801\uc73c\ub85c \uad00\ub9ac\ud560 \uc218 \uc788\uc2b5\ub2c8\ub2e4.<\/li>\n\n\n\n<li><strong>\ud6a8\uc728\uc801\uc778 \ub370\uc774\ud130 \uad00\ub9ac<\/strong>: \uc2dc\uac04\uc774 \uc911\uc694\ud55c \ub370\uc774\ud130\ub098 \uc5ec\ub7ec \ud544\ud130 \uc870\uac74\uc774 \uc790\uc8fc \uc0ac\uc6a9\ub418\ub294 \ub300\uaddc\ubaa8 \ub370\uc774\ud130\uc14b\uc5d0\uc11c, \ub370\uc774\ud130\ub97c \ub354 \uccb4\uacc4\uc801\uc774\uace0 \ud6a8\uc728\uc801\uc73c\ub85c \uad00\ub9ac\ud560 \uc218 \uc788\uc2b5\ub2c8\ub2e4.<\/li>\n<\/ul>\n\n\n\n<pre class=\"wp-block-code\"><code lang=\"sql\" class=\"language-sql line-numbers\">CREATE OR REPLACE TABLE `TEST_DATASET_US.test_table_partitioned_clustered`\nPARTITION BY\n  week\nCLUSTER BY \n  term,\n  dma_id\nAS (\n  SELECT\n    *\n  FROM\n    `bigquery-public-data.google_trends.top_terms`\n  WHERE\n    week BETWEEN \"2015-09-15\" AND \"2024-09-15\"\n);<\/code><\/pre>\n\n\n\n<p>\uc774 \ud14c\uc774\ube14\uc740 week \uc5f4\ub85c \ud30c\ud2f0\uc154\ub2dd\ub418\uc5b4 \uc788\uc5b4 \uc2dc\uac04 \uae30\ubc18\uc758 \ucffc\ub9ac \uc2dc \ud2b9\uc815 \uae30\uac04\uc758 \ub370\uc774\ud130\ub9cc \ube60\ub974\uac8c \uc870\ud68c\ud560 \uc218 \uc788\uc2b5\ub2c8\ub2e4. \uc608\ub97c \ub4e4\uc5b4, \ud2b9\uc815 \uc8fc \ub610\ub294 \uc6d4\ubcc4 \ub370\uc774\ud130\ub97c \uc870\ud68c\ud560 \ub54c \ud574\ub2f9 \uae30\uac04\uc758 \ud30c\ud2f0\uc158\ub9cc \uc2a4\uce94\ud558\uac8c \ub418\uc5b4 \uc131\ub2a5\uc774 \ud5a5\uc0c1\ub429\ub2c8\ub2e4.<\/p>\n\n\n\n<p>\ub610\ud55c, term\uacfc dma_id \uc5f4\ub85c \ud074\ub7ec\uc2a4\ud130\ub9c1\ud558\uc5ec, \ud30c\ud2f0\uc158 \ub0b4\uc5d0\uc11c \uc774 \ub450 \uc5f4\uc744 \uae30\uc900\uc73c\ub85c \ub370\uc774\ud130\ub97c \ubb3c\ub9ac\uc801\uc73c\ub85c \uc815\ub82c\ud569\ub2c8\ub2e4. \uc774\ub97c \ud1b5\ud574 term\uacfc dma_id\uc5d0 \ub300\ud55c \ud544\ud130\ub9c1\uc774 \uc790\uc8fc \uc774\ub8e8\uc5b4\uc9c8 \uacbd\uc6b0, \uac80\uc0c9 \uc131\ub2a5\uc744 \ud06c\uac8c \uac1c\uc120\ud560 \uc218 \uc788\uc2b5\ub2c8\ub2e4. \uc989, \ud30c\ud2f0\uc154\ub2dd\uc73c\ub85c \ub300\uaddc\ubaa8 \ub370\uc774\ud130\ub97c \ud6a8\uc728\uc801\uc73c\ub85c \uad00\ub9ac\ud558\uace0, \ud074\ub7ec\uc2a4\ud130\ub9c1\uc73c\ub85c \ud2b9\uc815 \ud544\ud130 \uc870\uac74\uc744 \ub354\uc6b1 \ube60\ub974\uac8c \ucc98\ub9ac\ud560 \uc218 \uc788\ub294 \uad6c\uc870\uc785\ub2c8\ub2e4.<\/p>\n\n\n\n<h2 class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"%EA%B2%B0%EB%A1%A0\"><\/span>\uacb0\ub860<span class=\"ez-toc-section-end\"><\/span><\/h2>\n\n\n\n<p>\ud074\ub7ec\uc2a4\ud130\ub9c1\uacfc \ud30c\ud2f0\uc154\ub2dd\uc744 \ud568\uaed8 \uc801\uc6a9\ud55c \ud14c\uc774\ube14\uc740 \ucffc\ub9ac \uc131\ub2a5\uacfc \ube44\uc6a9 \uc808\uac10 \uce21\uba74\uc5d0\uc11c \ub9e4\uc6b0 \uac15\ub825\ud55c \uc870\ud569\uc785\ub2c8\ub2e4. \ud30c\ud2f0\uc154\ub2dd\uc744 \ud1b5\ud574 \ub300\uaddc\ubaa8 \ub370\uc774\ud130\ub97c \uc2dc\uac04 \ub610\ub294 \ubc94\uc8fc\ubcc4\ub85c \ud6a8\uc728\uc801\uc73c\ub85c \uad00\ub9ac\ud558\uace0, \ud074\ub7ec\uc2a4\ud130\ub9c1\uc744 \ud1b5\ud574 \ud544\ud130\ub9c1\uc774 \uc790\uc8fc \uc774\ub8e8\uc5b4\uc9c0\ub294 \uc5f4\uc5d0 \ub300\ud574 \ucd5c\uc801\ud654\ub41c \uc131\ub2a5\uc744 \uc81c\uacf5\ud569\ub2c8\ub2e4.<\/p>\n\n\n\n<p>\uc774\ub97c \ud1b5\ud574 \ucffc\ub9ac \uc2dc \uc2a4\uce94\ud574\uc57c \ud560 \ub370\uc774\ud130\uc758 \uc591\uc744 \uc904\uc774\uace0, \ucc98\ub9ac \uc18d\ub3c4\ub97c \ub192\uc5ec \ubcf4\ub2e4 \ud6a8\uc728\uc801\uc778 \ub370\uc774\ud130 \ubd84\uc11d\uc774 \uac00\ub2a5\ud574\uc9d1\ub2c8\ub2e4. \ud2b9\ud788, \uc2dc\uac04\uc5d0 \ub530\ub77c \uc313\uc774\ub294 \ub300\uaddc\ubaa8 \ub370\uc774\ud130\uc14b\uacfc \ubcf5\uc7a1\ud55c \ud544\ud130 \uc870\uac74\uc744 \uc790\uc8fc \uc0ac\uc6a9\ud558\ub294 \uc0c1\ud669\uc5d0\uc11c, \uc774 \ub450 \uae30\uc220\uc744 \uacb0\ud569\ud558\uba74 \uc131\ub2a5 \ud5a5\uc0c1\uacfc \ube44\uc6a9 \uc808\uac10\uc744 \ub3d9\uc2dc\uc5d0 \ub2ec\uc131\ud560 \uc218 \uc788\uc2b5\ub2c8\ub2e4.<\/p>\n\n\n\n<p>\ub530\ub77c\uc11c, BigQuery\uc5d0\uc11c \ub300\uaddc\ubaa8 \ub370\uc774\ud130\ub97c \ub2e4\ub8e8\ub294 \uacbd\uc6b0 \ud074\ub7ec\uc2a4\ud130\ub9c1\uacfc \ud30c\ud2f0\uc154\ub2dd\uc744 \uc801\uc808\ud788 \uacb0\ud569\ud558\uc5ec \uc0ac\uc6a9\ud558\uba74, \ube60\ub974\uace0 \ud6a8\uc728\uc801\uc778 \ub370\uc774\ud130 \ubd84\uc11d\uc744 \uc218\ud589\ud560 \uc218 \uc788\uc2b5\ub2c8\ub2e4.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>\ub4e4\uc5b4\uac00\uba70 \ub370\uc774\ud130\uc758 \uc591\uc774 \uae30\ud558\uae09\uc218\uc801\uc73c\ub85c \uc99d\uac00\ud568\uc5d0 \ub530\ub77c, \ub370\uc774\ud130 \ubd84\uc11d\uc758 \uc131\ub2a5\uc744 \uadf9\ub300\ud654\ud558\ub294 \uac83\uc740 \ubaa8\ub4e0 \uae30\uc5c5\uc5d0\uac8c \uc911\uc694\ud55c \uacfc\uc81c\uac00 \ub418\uc5c8\uc2b5\ub2c8\ub2e4. \uc55e\uc120 \uae00\uc5d0\uc11c\ub294 BigQuery\uc5d0\uc11c \ud30c\ud2f0\uc154\ub2dd(Partitioning)\uc744 \ud1b5\ud574 \ucffc\ub9ac \uc131\ub2a5\uacfc \ube44\uc6a9\uc744 \ucd5c\uc801\ud654\ud558\ub294 \ubc29\ubc95\uc744 \uc18c\uac1c\ud588\uc2b5\ub2c8\ub2e4. \uadf8\ub7ec\ub098 \ud30c\ud2f0\uc154\ub2dd\ub9cc\uc73c\ub85c\ub294 \ucda9\ubd84\ud558\uc9c0 \uc54a\uc740 \uacbd\uc6b0\ub3c4 \ub9ce\uc2b5\ub2c8\ub2e4. \ud2b9\ud788, \ubcf5\uc7a1\ud55c \ucffc\ub9ac\uc5d0\uc11c \uc5ec\ub7ec \uc5f4\uc744 \uae30\uc900\uc73c\ub85c \ud544\ud130\ub9c1\ud574\uc57c \ud558\uac70\ub098, \ub370\uc774\ud130\uc758 \ubb3c\ub9ac\uc801 \uc815\ub82c\uc744 \ud1b5\ud574 \ub354\uc6b1 \ube60\ub978 \ubd84\uc11d\uc774 \ud544\uc694\ud55c \uacbd\uc6b0\uac00 [&hellip;]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[1],"tags":[5,36,37,12,18,22],"class_list":["post-296","post","type-post","status-publish","format-standard","hentry","category-1","tag-bigquery","tag-bigquery-clustering","tag-clustered-table","tag-gcp","tag-gcp-bigquery","tag-query-optimize","col-md-12"],"_links":{"self":[{"href":"https:\/\/www.nnt-consulting.com\/tech\/blog\/wp-json\/wp\/v2\/posts\/296","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.nnt-consulting.com\/tech\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.nnt-consulting.com\/tech\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.nnt-consulting.com\/tech\/blog\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.nnt-consulting.com\/tech\/blog\/wp-json\/wp\/v2\/comments?post=296"}],"version-history":[{"count":12,"href":"https:\/\/www.nnt-consulting.com\/tech\/blog\/wp-json\/wp\/v2\/posts\/296\/revisions"}],"predecessor-version":[{"id":374,"href":"https:\/\/www.nnt-consulting.com\/tech\/blog\/wp-json\/wp\/v2\/posts\/296\/revisions\/374"}],"wp:attachment":[{"href":"https:\/\/www.nnt-consulting.com\/tech\/blog\/wp-json\/wp\/v2\/media?parent=296"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.nnt-consulting.com\/tech\/blog\/wp-json\/wp\/v2\/categories?post=296"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.nnt-consulting.com\/tech\/blog\/wp-json\/wp\/v2\/tags?post=296"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}