{"id":4756,"date":"2018-03-09T12:06:43","date_gmt":"2018-03-09T20:06:43","guid":{"rendered":"https:\/\/www.couchbase.com\/blog\/?p=4756"},"modified":"2025-06-13T17:32:48","modified_gmt":"2025-06-14T00:32:48","slug":"new-querying-features-couchbase-server","status":"publish","type":"post","link":"https:\/\/www.couchbase.com\/blog\/ko\/new-querying-features-couchbase-server\/","title":{"rendered":"\uce74\uc6b0\uce58\ubca0\uc774\uc2a4 \uc11c\ubc84 5.5\uc758 \uc0c8\ub85c\uc6b4 \ucffc\ub9ac \uae30\ub2a5"},"content":{"rendered":"<div class=\"paragraph\">\n<p>\uc0c8\ub85c\uc6b4 \ucffc\ub9ac \uae30\ub2a5\uc740 \ucd5c\uc2e0 \ub9b4\ub9ac\uc2a4\uc778 Couchbase Server 5.5\uc5d0\uc11c \ub450\ub4dc\ub7ec\uc9c0\uac8c \ub098\ud0c0\ub0a9\ub2c8\ub2e4. \ud655\uc778\ud574 \ubcf4\uc138\uc694. <a href=\"https:\/\/www.couchbase.com\/blog\/ko\/announcing-couchbase-server-5-5\/\">\ubc1c\ud45c<\/a> \uadf8\ub9ac\uace0 <a href=\"https:\/\/www.couchbase.com\/blog\/ko\/downloads\/\">\uc9c0\uae08 \ubc14\ub85c \ubb34\ub8cc\ub85c \ub2e4\uc6b4\ub85c\ub4dc\ud558\uc138\uc694.<\/a>.<\/p>\n<\/div>\n<div class=\"paragraph\">\n<p>\uc774 \uae00\uc5d0\uc11c\ub294 \uba87 \uac00\uc9c0 \uc0c8\ub85c\uc6b4 \uae30\ub2a5\uc744 \uc911\uc810\uc801\uc73c\ub85c \uc0b4\ud3b4\ubcf4\uace0 \uc774\ub97c \uc0ac\uc6a9\ud558\ub294 \ubc29\ubc95\uc744 \uc54c\ub824\ub4dc\ub9ac\uace0\uc790 \ud569\ub2c8\ub2e4:<\/p>\n<\/div>\n<div class=\"ulist\">\n<ul>\n<li>ANSI JOIN - Couchbase\uc758 N1QL\uc5d0\ub294 \uc774\ubbf8 JOIN\uc774 \uc788\uc9c0\ub9cc \uc774\uc81c JOIN\uc740 \ud45c\uc900\uc744 \ub354 \uc798 \uc900\uc218\ud558\uace0 \ub354 \uc720\uc5f0\ud569\ub2c8\ub2e4.<\/li>\n<li>\ud574\uc2dc \uc870\uc778 - \ud2b9\uc815 \uc720\ud615\uc758 \uc870\uc778\uc5d0\uc11c \ud574\uc2dc \uc870\uc778\uc744 \uc0ac\uc6a9\ud558\uba74 \uc131\ub2a5\uc744 \ud5a5\uc0c1\uc2dc\ud0ac \uc218 \uc788\uc2b5\ub2c8\ub2e4(\uc5d4\ud130\ud504\ub77c\uc774\uc988 \uc5d0\ub514\uc158\uc5d0\uc11c\ub9cc).<\/li>\n<li>\uc9d1\uacc4 \ud478\uc2dc\ub2e4\uc6b4 - GROUP BY\ub97c \uc778\ub371\uc11c\ub85c \ud478\uc2dc\ub2e4\uc6b4\ud558\uc5ec \uc9d1\uacc4 \uc131\ub2a5\uc744 \uac1c\uc120\ud560 \uc218 \uc788\uc2b5\ub2c8\ub2e4(\uc5d4\ud130\ud504\ub77c\uc774\uc988 \uc5d0\ub514\uc158\uc5d0\uc11c\ub9cc).<\/li>\n<\/ul>\n<\/div>\n<div class=\"paragraph\">\n<p><em>\uc774 \uae00\uc758 \ubaa8\ub4e0 \uc608\uc81c\ub294 Couchbase\uc640 \ud568\uaed8 \uc81c\uacf5\ub418\ub294 \"\uc5ec\ud589 \uc0d8\ud50c\" \ubc84\ud0b7\uc744 \uc0ac\uc6a9\ud569\ub2c8\ub2e4.<\/em><\/p>\n<\/div>\n<div class=\"sect1\">\n<h2 id=\"_ansi_joins\">ANSI \uc870\uc778<\/h2>\n<div class=\"sectionbody\">\n<div class=\"paragraph\">\n<p>Couchbase Server 5.5\uae4c\uc9c0\ub294 \uc870\uc778\uc774 \uac00\ub2a5\ud588\uc9c0\ub9cc \ub450 \uac00\uc9c0 \uc8fc\uc758 \uc0ac\ud56d\uc774 \uc788\uc5c8\uc2b5\ub2c8\ub2e4:<\/p>\n<\/div>\n<div class=\"olist arabic\">\n<ol class=\"arabic\">\n<li>\uc870\uc778\uc758 \ud55c\ucabd\uc740 \ubb38\uc11c \ud0a4\uc5ec\uc57c \ud569\ub2c8\ub2e4.<\/li>\n<li>\ubc18\ub4dc\uc2dc <code>\uc628\ud0a4\uc988<\/code> \uad6c\ubb38<\/li>\n<\/ol>\n<\/div>\n<div class=\"paragraph\">\n<p>Couchbase Server 5.5\uc5d0\uc11c\ub294 \ub354 \uc774\uc0c1 \ub2e4\uc74c\uc744 \uc0ac\uc6a9\ud560 \ud544\uc694\uac00 \uc5c6\uc2b5\ub2c8\ub2e4. <code>\uc628\ud0a4\uc988<\/code>\ub97c \uc0ac\uc6a9\ud558\uc5ec \uc870\uc778\uc744 \uc791\uc131\ud558\ub294 \uac83\uc774 \ud6e8\uc52c \ub354 \uc790\uc5f0\uc2a4\ub7fd\uace0 \ub2e4\ub978 SQL \ubc29\uc5b8\uacfc \uc77c\uce58\ud569\ub2c8\ub2e4.<\/p>\n<\/div>\n<div class=\"sect2\">\n<h3 id=\"_previous_join_syntax\">\uc774\uc804 JOIN \uad6c\ubb38<\/h3>\n<div class=\"paragraph\">\n<p>\uc608\ub97c \ub4e4\uc5b4 \uc774\uc804 \uad6c\ubb38\uc740 \ub2e4\uc74c\uacfc \uac19\uc2b5\ub2c8\ub2e4:<\/p>\n<\/div>\n<div class=\"listingblock\">\n<div class=\"content\">\n<pre class=\"highlight decode:true\"><code class=\"language-SQL\">SELECT r.destinationairport, r.sourceairport, r.distance, r.airlineid, a.name\r\nFROM `travel-sample` r\r\nJOIN `travel-sample` a ON KEYS r.airlineid\r\nWHERE r.type = 'route'\r\nAND r.sourceairport = 'CMH'\r\nORDER BY r.distance DESC\r\nLIMIT 10;<\/code><\/pre>\n<\/div>\n<\/div>\n<div class=\"paragraph\">\n<p>\uc774\ub807\uac8c \ud558\uba74 CMH \uacf5\ud56d\uc5d0\uc11c \ucd9c\ubc1c\ud558\ub294 10\uac1c \ub178\uc120\uc774 \ud574\ub2f9 \ud56d\uacf5\uc0ac \ubb38\uc11c\uc640 \uacb0\ud569\ub429\ub2c8\ub2e4. \uacb0\uacfc\ub294 \uc544\ub798\uc640 \uac19\uc2b5\ub2c8\ub2e4(\ud14c\uc774\ube14 \ubcf4\uae30\ub85c \ud45c\uc2dc\ud558\uace0 \uc788\uc9c0\ub9cc \uc5ec\uc804\ud788 JSON\uc785\ub2c8\ub2e4):<\/p>\n<\/div>\n<div class=\"paragraph\">\n<p><span class=\"image\"><img decoding=\"async\" src=\"https:\/\/www.couchbase.com\/blog\/wp-content\/uploads\/2018\/03\/10201-ansi-join-table-view.png\" alt=\"ANSI join results\" \/><\/span><\/p>\n<\/div>\n<\/div>\n<div class=\"sect2\">\n<h3 id=\"_new_join_syntax\">\uc0c8\ub85c\uc6b4 JOIN \uad6c\ubb38<\/h3>\n<div class=\"paragraph\">\n<p>\uadf8\ub9ac\uace0 \uc5ec\uae30\uc5d0 \ub3d9\uc77c\ud55c \uc791\uc5c5\uc744 \uc218\ud589\ud558\ub294 \uc0c8\ub85c\uc6b4 \uad6c\ubb38\uc774 \uc788\uc2b5\ub2c8\ub2e4:<\/p>\n<\/div>\n<div class=\"listingblock\">\n<div class=\"content\">\n<pre class=\"highlight decode:true\"><code class=\"language-SQL\">SELECT r.destinationairport, r.sourceairport, r.distance, r.airlineid, a.name\r\nFROM `travel-sample` r\r\nJOIN `travel-sample` a ON META(a).id = r.airlineid\r\nWHERE r.type = 'route'\r\nAND r.sourceairport = 'CMH'\r\nORDER BY r.distance DESC\r\nLIMIT 10;<\/code><\/pre>\n<\/div>\n<\/div>\n<div class=\"paragraph\">\n<p>\uc720\uc77c\ud55c \ucc28\uc774\uc810\uc740 <code>\ucf1c\uae30<\/code>. \ub300\uc2e0 <code>\uc628\ud0a4\uc988<\/code>\uc774\uc81c <code>\ucf1c\uae30  =<\/code>. \uc800\ucc98\ub7fc \uad00\uacc4\uc801 \ubc30\uacbd\uc744 \uac00\uc9c4 \uc0ac\ub78c\ub4e4\uc5d0\uac8c\ub294 \ub354 \uc790\uc5f0\uc2a4\ub7ec\uc6b4 \uc77c\uc785\ub2c8\ub2e4.<\/p>\n<\/div>\n<div class=\"paragraph\">\n<p>\ud558\uc9c0\ub9cc \uadf8\uac8c \ub2e4\uac00 \uc544\ub2d9\ub2c8\ub2e4. \uc774\uc81c \ub354 \uc774\uc0c1 \ubb38\uc11c \ud0a4\ub85c\ub9cc \uac00\uc785\ud560 \uc218 \uc5c6\uc2b5\ub2c8\ub2e4. \ub2e4\uc74c\uc740 <code>JOIN<\/code> \ub3c4\uc2dc \ud544\ub4dc\uc5d0\uc11c<\/p>\n<\/div>\n<div class=\"listingblock\">\n<div class=\"content\">\n<pre class=\"highlight decode:true\"><code class=\"language-SQL\">SELECT a.airportname, a.city AS airportCity, h.name AS hotelName, h.city AS hotelCity, h.address AS hotelAddress\r\nFROM `travel-sample` a\r\nINNER JOIN `travel-sample` h ON h.city = a.city\r\nWHERE a.type = 'airport'\r\nAND h.type = 'hotel'\r\nLIMIT 10;<\/code><\/pre>\n<\/div>\n<\/div>\n<div class=\"paragraph\">\n<p>\uc774 \ucffc\ub9ac\ub294 \ub3c4\uc2dc\ub97c \uae30\uc900\uc73c\ub85c \uacf5\ud56d\uacfc \uc77c\uce58\ud558\ub294 \ud638\ud154\uc744 \ud45c\uc2dc\ud569\ub2c8\ub2e4.<\/p>\n<\/div>\n<div class=\"paragraph\">\n<p><span class=\"image\"><img decoding=\"async\" src=\"https:\/\/www.couchbase.com\/blog\/wp-content\/uploads\/2018\/03\/10202-ansi-join-on-fields.png\" alt=\"ANSI join on fields\" \/><\/span><\/p>\n<\/div>\n<div class=\"paragraph\">\n<p>\uc774 \uc791\uc5c5\uc744 \uc218\ud589\ud558\ub824\uba74 \uc870\uc778\uc758 \uc548\ucabd\uc5d0 \uc788\ub294 \ud544\ub4dc\uc5d0 \uc778\ub371\uc2a4\uac00 \uc0dd\uc131\ub418\uc5b4 \uc788\uc5b4\uc57c \ud569\ub2c8\ub2e4. \"travel-sample\" \ubc84\ud0b7\uc5d0\ub294 \uc774\ubbf8 \ub3c4\uc2dc \ud544\ub4dc\uc5d0 \ub300\ud55c \ubbf8\ub9ac \uc815\uc758\ub41c \uc778\ub371\uc2a4\uac00 \ud3ec\ud568\ub418\uc5b4 \uc788\uc2b5\ub2c8\ub2e4. \ub2e4\ub978 \ud544\ub4dc\ub85c \uc774 \uc791\uc5c5\uc744 \uc2dc\ub3c4\ud558\uba74 \"ANSI \uc870\uc778 \uc6a9\uc5b4\uc5d0 \uc0ac\uc6a9\ud560 \uc218 \uc788\ub294 \uc778\ub371\uc2a4\uac00 \uc5c6\uc2b5\ub2c8\ub2e4...\"\uc640 \uac19\uc740 \uc624\ub958 \uba54\uc2dc\uc9c0\uac00 \ud45c\uc2dc\ub429\ub2c8\ub2e4.<\/p>\n<\/div>\n<div class=\"paragraph\">\n<p>ANSI JOIN\uc5d0 \ub300\ud55c \uc790\uc138\ud55c \ub0b4\uc6a9\uc740 \ub2e4\uc74c\uc744 \ucc38\uc870\ud558\uc138\uc694. <a href=\"https:\/\/docs.couchbase.com\/server\/current\/n1ql\/n1ql-language-reference\/join.html\">N1QL JOIN \ubb38\uc11c \uc804\ubb38<\/a>.<\/p>\n<\/div>\n<div class=\"paragraph\">\n<p><em>\ucc38\uace0: \uc774\uc804 JOIN, ON KEYS \uad6c\ubb38\uc740 \uacc4\uc18d \uc791\ub3d9\ud558\ubbc0\ub85c \uae30\uc874 \ucf54\ub4dc\ub97c \uc5c5\ub370\uc774\ud2b8\ud574\uc57c \ud560 \uac71\uc815\uc740 \ud558\uc9c0 \uc54a\uc544\ub3c4 \ub429\ub2c8\ub2e4.<\/em><\/p>\n<\/div>\n<\/div>\n<\/div>\n<\/div>\n<div class=\"sect1\">\n<h2 id=\"_hash_joins\">\ud574\uc2dc \uc870\uc778<\/h2>\n<div class=\"sectionbody\">\n<div class=\"paragraph\">\n<p>\uadf8 \uc548\uc5d0\ub294 \uc870\uc778\uc744 \uc218\ud589\ud560 \uc218 \uc788\ub294 \ub2e4\uc591\ud55c \ubc29\ubc95\uc774 \uc788\uc2b5\ub2c8\ub2e4. \uc704\uc758 \ucffc\ub9ac\ub97c \uc2e4\ud589\ud558\uba74 Couchbase\uc5d0\uc11c <strong>\uc911\ucca9 \ub8e8\ud504(NL)<\/strong> \uc811\uadfc \ubc29\uc2dd\uc744 \uc0ac\uc6a9\ud558\uc5ec \uc870\uc778\uc744 \uc2e4\ud589\ud569\ub2c8\ub2e4. \uadf8\ub7ec\ub098 Couchbase\uc5d0 \uc870\uc778\uc744 \uc2e4\ud589\ud558\uae30 \uc704\ud574 <strong>\ud574\uc2dc \uc870\uc778<\/strong> \ub300\uc2e0 \uc0ac\uc6a9\ud558\uc138\uc694. \ub54c\ub85c\ub294 \ud574\uc2dc \uc870\uc778\uc774 \uc911\ucca9 \ub8e8\ud504\ubcf4\ub2e4 \uc131\ub2a5\uc774 \ub354 \uc6b0\uc218\ud560 \uc218 \uc788\uc2b5\ub2c8\ub2e4. \ub610\ud55c \ud574\uc2dc \uc870\uc778\uc740 \uc778\ub371\uc2a4\uc5d0 \uc885\uc18d\ub418\uc9c0 \uc54a\uc2b5\ub2c8\ub2e4. \uadf8\ub7ec\ub098 \uc870\uc778\uc774 \ub3d9\uc77c\uc131 \uc870\uc778\uc778\uc9c0 \uc5ec\ubd80\uc5d0 \ub530\ub77c \ub2ec\ub77c\uc9d1\ub2c8\ub2e4.<\/p>\n<\/div>\n<div class=\"paragraph\">\n<p>\uc608\ub97c \ub4e4\uc5b4, '\uc5ec\ud589 \uc0d8\ud50c'\uc5d0\uc11c\ub294 \uc774\uba54\uc77c \ud544\ub4dc\uc5d0 \ub79c\ub4dc\ub9c8\ud06c\uc640 \ud638\ud154\uc744 \uc5f0\uacb0\ud560 \uc218 \uc788\uc2b5\ub2c8\ub2e4. \uc774 \ubc29\ubc95\uc740 \ud638\ud154\uc774 \ub79c\ub4dc\ub9c8\ud06c\uc778\uc9c0 \uc54c\uc544\ub0b4\ub294 \ub370 \uac00\uc7a5 \uc88b\uc740 \ubc29\ubc95\uc740 \uc544\ub2c8\uc9c0\ub9cc \uc774\uba54\uc77c\uc740 \uae30\ubcf8\uc801\uc73c\ub85c \uc0c9\uc778\ud654\ub418\uc9c0 \uc54a\uae30 \ub54c\ubb38\uc5d0 \uc694\uc810\uc744 \uc798 \ubcf4\uc5ec\uc90d\ub2c8\ub2e4.<\/p>\n<\/div>\n<div class=\"listingblock\">\n<div class=\"content\">\n<pre class=\"highlight decode:true\"><code class=\"language-SQL\">SELECT l.name AS landmarkName, h.name AS hotelName, l.email AS landmarkEmail, h.email AS hotelEmail\r\nFROM `travel-sample` l\r\nINNER JOIN `travel-sample` h ON h.email = l.email\r\nWHERE l.type = 'landmark'\r\nAND h.type = 'hotel';<\/code><\/pre>\n<\/div>\n<\/div>\n<div class=\"paragraph\">\n<p>\uc704\uc758 \ucffc\ub9ac\ub294 \uc2e4\ud589\ud558\ub294 \ub370 \ub9e4\uc6b0 \uc624\ub79c \uc2dc\uac04\uc774 \uac78\ub9ac\uba70 \uc2dc\uac04\uc774 \ucd08\uacfc\ub420 \uc218 \uc788\uc2b5\ub2c8\ub2e4.<\/p>\n<\/div>\n<div class=\"sect2\">\n<h3 id=\"_syntax\">\uad6c\ubb38<\/h3>\n<div class=\"paragraph\">\n<p>\ub2e4\uc74c\uc73c\ub85c \uba85\uc2dc\uc801\uc73c\ub85c \ud638\ucd9c\ud574\uc57c \ud558\ub294 \ud574\uc2dc \uc870\uc778\uc744 \uc2dc\ub3c4\ud574 \ubcf4\uaca0\uc2b5\ub2c8\ub2e4. <code>\ud574\uc2dc \uc0ac\uc6a9<\/code> \ud78c\ud2b8.<\/p>\n<\/div>\n<div class=\"listingblock\">\n<div class=\"content\">\n<pre class=\"highlight decode:true\"><code class=\"language-SQL\">SELECT l.name AS landmarkName, h.name AS hotelName, l.email AS landmarkEmail, h.email AS hotelEmail\r\nFROM `travel-sample` l\r\nINNER JOIN `travel-sample` h USE HASH(BUILD) ON h.email = l.email\r\nWHERE l.type = 'landmark'\r\nAND h.type = 'hotel';<\/code><\/pre>\n<\/div>\n<\/div>\n<div class=\"paragraph\">\n<p>\ud574\uc2dc \uc870\uc778\uc5d0\ub294 \ub450 \uac00\uc9c0 \uce21\uba74\uc774 \uc788\uc2b5\ub2c8\ub2e4. <code>\ube4c\ub4dc<\/code> \ubc0f <code>PROBE<\/code>. . <code>\ube4c\ub4dc<\/code> \ucabd\uc740 \uc778\uba54\ubaa8\ub9ac \ud574\uc2dc \ud14c\uc774\ube14\uc744 \ub9cc\ub4dc\ub294 \ub370 \uc0ac\uc6a9\ub429\ub2c8\ub2e4. \uc870\uc778\uc758 <code>PROBE<\/code> \ucabd\uc740 \ud574\ub2f9 \ud14c\uc774\ube14\uc744 \uc0ac\uc6a9\ud558\uc5ec \uc77c\uce58\ud558\ub294 \ud56d\ubaa9\uc744 \ucc3e\uace0 \uc870\uc778\uc744 \uc218\ud589\ud569\ub2c8\ub2e4. \uc77c\ubc18\uc801\uc73c\ub85c \uc774\uac83\uc740 <code>\ube4c\ub4dc<\/code> \ucabd\uc744 \ub450 \uc138\ud2b8 \uc911 \ub354 \uc791\uc740 \ucabd\uc5d0 \uc0ac\uc6a9\ud558\ub3c4\ub85d \uc124\uc815\ud569\ub2c8\ub2e4. \uadf8\ub7ec\ub098 \ud574\uc2dc \ud78c\ud2b8\ub294 \ud558\ub098\uc758 \ud574\uc2dc \ud78c\ud2b8\ub9cc \uc81c\uacf5\ud560 \uc218 \uc788\uc73c\uba70 \uc870\uc778\uc758 \uc624\ub978\ucabd\uc5d0\ub9cc \uc0ac\uc6a9\ud560 \uc218 \uc788\uc2b5\ub2c8\ub2e4. \ub530\ub77c\uc11c <code>\ube4c\ub4dc<\/code> \ub97c \uc624\ub978\ucabd\uc5d0 \ud45c\uc2dc\ud558\uba74 \uc554\uc2dc\uc801\uc73c\ub85c <code>PROBE<\/code> \ub97c \uc67c\ucabd\uc73c\ub85c \uc774\ub3d9\ud569\ub2c8\ub2e4(\ub610\ub294 \uadf8 \ubc18\ub300\ub3c4 \ub9c8\ucc2c\uac00\uc9c0).<\/p>\n<\/div>\n<\/div>\n<div class=\"sect2\">\n<h3 id=\"_build_and_probe\">\ube4c\ub4dc \ubc0f \ud504\ub85c\ube0c<\/h3>\n<div class=\"paragraph\">\n<p>\uadf8\ub807\ub2e4\uba74 \uc65c <code>\ud574\uc2dc(\ube4c\ub4dc)<\/code>?<\/p>\n<\/div>\n<div class=\"paragraph\">\n<p>\uc0ac\uc6a9\ud574\ubcf4\ub2c8 <a href=\"https:\/\/docs.couchbase.com\/server\/current\/n1ql\/n1ql-language-reference\/infer.html\"><code>INFER<\/code><\/a> \ubc0f\/\ub610\ub294 <a href=\"https:\/\/docs.couchbase.com\/server\/current\/tools\/query-workbench.html#bucket-analyzer\">\ubc84\ud0b7 \uc778\uc0ac\uc774\ud2b8<\/a> \ub79c\ub4dc\ub9c8\ud06c\uac00 \ub370\uc774\ud130\uc758 \uc57d 101TB, \ud638\ud154\uc774 \uc57d 31TB\ub97c \ucc28\uc9c0\ud55c\ub2e4\ub294 \uc0ac\uc2e4\uc744 \uc54c\uac8c \ub418\uc5c8\uc2b5\ub2c8\ub2e4. \ub610\ud55c, \uc9c1\uc811 \uc0ac\uc6a9\ud574 \ubcf8 \uacb0\uacfc \ub2e4\uc74c\uacfc \uac19\uc740 \uc0ac\uc2e4\uc744 \uc54c\uac8c \ub418\uc5c8\uc2b5\ub2c8\ub2e4. <code>\ud574\uc2dc(\ube4c\ub4dc)<\/code> \uac00 \uc57d\uac04 \ub354 \ub290\ub838\uc2b5\ub2c8\ub2e4. \ud558\uc9c0\ub9cc \ub450 \uacbd\uc6b0 \ubaa8\ub450 \ucffc\ub9ac \uc2e4\ud589 \uc2dc\uac04\uc740 \ubc00\ub9ac\ucd08\uc600\uc2b5\ub2c8\ub2e4. \uc774\uba54\uc77c \uc8fc\uc18c\uac00 \uac19\uc740 \ud638\ud154-\ub79c\ub4dc\ub9c8\ud06c \uc30d\uc774 \ub450 \uac1c \uc788\ub294 \uac83\uc73c\ub85c \ub098\ud0c0\ub0ac\uc2b5\ub2c8\ub2e4.<\/p>\n<\/div>\n<div class=\"paragraph\">\n<p><span class=\"image\"><img decoding=\"async\" src=\"https:\/\/www.couchbase.com\/blog\/new-querying-features-couchbase-server\/10205-hash-join-results\/\" alt=\"Hash join results\" \/><\/span><\/p>\n<\/div>\n<div class=\"paragraph\">\n<p><code>\ud574\uc2dc \uc0ac\uc6a9<\/code> \ub294 \uce74\uc6b0\uce58\ubca0\uc774\uc2a4\uc5d0 <em>\uc2dc\ub3c4<\/em> \ub97c \ud574\uc2dc \uc870\uc778\ud574\uc57c \ud569\ub2c8\ub2e4. \uadf8\ub807\uac8c \ud560 \uc218 \uc5c6\ub294 \uacbd\uc6b0(\ub610\ub294 Couchbase Server Community Edition\uc744 \uc0ac\uc6a9\ud558\ub294 \uacbd\uc6b0) \uc911\ucca9 \ub8e8\ud504\ub85c \ub3cc\uc544\uac11\ub2c8\ub2e4. (\ucc38\uace0\ub85c, \uc911\ucca9 \ub8e8\ud504\ub97c \uba85\uc2dc\uc801\uc73c\ub85c \uc9c0\uc815\ud558\ub824\uba74 <code>NL \uc0ac\uc6a9<\/code> \uad6c\ubb38\uc744 \uc0ac\uc6a9\ud560 \uc218 \uc788\uc9c0\ub9cc \ud604\uc7ac\ub294 \uadf8\ub807\uac8c \ud560 \uc774\uc720\uac00 \uc5c6\uc2b5\ub2c8\ub2e4).<\/p>\n<\/div>\n<div class=\"paragraph\">\n<p>\uc790\uc138\ud55c \ub0b4\uc6a9\uc740 <a href=\"https:\/\/docs.couchbase.com\/server\/current\/n1ql\/n1ql-language-reference\/join.html#use-hash-hint\">\ud574\uc2dc \uc870\uc778<\/a> \uc601\uc5ed\uc73c\ub85c \uc774\ub3d9\ud569\ub2c8\ub2e4.<\/p>\n<\/div>\n<\/div>\n<\/div>\n<\/div>\n<div class=\"sect1\">\n<h2 id=\"_aggregate_pushdowns\">\ucd1d \ud478\uc2dc\ub2e4\uc6b4 \uc9d1\uacc4<\/h2>\n<div class=\"sectionbody\">\n<div class=\"paragraph\">\n<p>\uacfc\uac70\uc758 \uc9d1\uacc4\ub294 \uc131\ub2a5 \uce21\uba74\uc5d0\uc11c \uae4c\ub2e4\ub85c\uc6e0\uc2b5\ub2c8\ub2e4. Couchbase Server 5.5, <em>\ucd1d \ud478\uc2dc\ub2e4\uc6b4 \uc9d1\uacc4<\/em> \uc774\uc81c \ub2e4\uc74c \ud56d\ubaa9\uc774 \uc9c0\uc6d0\ub429\ub2c8\ub2e4. <code>\ud569\uacc4, \uce74\uc6b4\ud2b8, \ucd5c\uc18c, \ucd5c\ub300 \ubc0f \ud3c9\uade0<\/code>.<\/p>\n<\/div>\n<div class=\"paragraph\">\n<p>\uc774\uc804 \ubc84\uc804\uc758 Couchbase\uc5d0\uc11c\ub294 \ub2e4\uc74c\uacfc \uac19\uc740 \ubb38\uc5d0\ub294 \uc778\ub371\uc2f1\uc774 \uc0ac\uc6a9\ub418\uc9c0 \uc54a\uc558\uc2b5\ub2c8\ub2e4. <code>\uadf8\ub8f9 \uae30\uc900<\/code>. \uc774\uac83\uc740 \ucd94\uac00\uc801\uc778 \"\uadf8\ub8f9\ud654\" \ub2e8\uacc4\uac00 \ud544\uc694\ud558\uae30 \ub54c\ubb38\uc5d0 \uc131\ub2a5\uc5d0 \uc2ec\uac01\ud55c \uc601\ud5a5\uc744 \ubbf8\uce60 \uc218 \uc788\uc2b5\ub2c8\ub2e4. Couchbase Server 5.5\uc5d0\uc11c\ub294 \uc778\ub371\uc2a4 \uc11c\ube44\uc2a4\uac00 \uadf8\ub8f9\ud654\/\uc9d1\uacc4\ub97c \uc218\ud589\ud560 \uc218 \uc788\uc2b5\ub2c8\ub2e4.<\/p>\n<\/div>\n<div class=\"sect2\">\n<h3 id=\"_example\">\uc608<\/h3>\n<div class=\"paragraph\">\n<p>\ub2e4\uc74c\uc740 \ucd1d \ud638\ud154 \uc218\ub97c \ucc3e\uace0 \uad6d\uac00, \uc8fc \ubc0f \ub3c4\uc2dc\ubcc4\ub85c \uadf8\ub8f9\ud654\ud558\ub294 \ucffc\ub9ac \uc608\uc81c\uc785\ub2c8\ub2e4.<\/p>\n<\/div>\n<div class=\"listingblock\">\n<div class=\"content\">\n<pre class=\"highlight decode:true\"><code class=\"language-SQL\">SELECT country, state, city, COUNT(1) AS total\r\nFROM `travel-sample`\r\nWHERE type = 'hotel' and country is not null\r\nGROUP BY country, state, city\r\nORDER BY COUNT(1) DESC;<\/code><\/pre>\n<\/div>\n<\/div>\n<div class=\"paragraph\">\n<p>\ucffc\ub9ac\uac00 \uc2e4\ud589\ub418\uace0 \uadf8 \uacb0\uacfc\ub85c \ubc18\ud658\ub429\ub2c8\ub2e4:<\/p>\n<\/div>\n<div class=\"paragraph\">\n<p><span class=\"image\"><img decoding=\"async\" src=\"https:\/\/www.couchbase.com\/blog\/wp-content\/uploads\/2018\/03\/10203-aggregate-result.png\" alt=\"Aggregation result\" \/><\/span><\/p>\n<\/div>\n<div class=\"paragraph\">\n<p>\uc2dc\uac01\uc801 \ucffc\ub9ac \ud50c\ub79c\uc744 \uc0b4\ud3b4\ubcf4\uaca0\uc2b5\ub2c8\ub2e4(Enterprise \uc5d0\ub514\uc158\uc5d0\uc11c\ub9cc \uc0ac\uc6a9\ud560 \uc218 \uc788\uc9c0\ub9cc \ucee4\ubba4\ub2c8\ud2f0 \uc5d0\ub514\uc158\uc5d0\uc11c\ub294 \uc6d0\uc2dc \ud50c\ub79c \ud14d\uc2a4\ud2b8\ub97c \ubcfc \uc218 \uc788\uc2b5\ub2c8\ub2e4).<\/p>\n<\/div>\n<div class=\"paragraph\">\n<p><span class=\"image\"><img decoding=\"async\" src=\"https:\/\/www.couchbase.com\/blog\/wp-content\/uploads\/2018\/03\/10204-query-plan-no-pushdown.png\" alt=\"Query plan with no pushdown\" \/><\/span><\/p>\n<\/div>\n<div class=\"paragraph\">\n<p>\uc0ac\uc6a9 \uc911\uc778 \uc720\uc77c\ud55c \uc778\ub371\uc2a4\ub294 <code>\uc720\ud615<\/code> \ud544\ub4dc\ub97c \uc785\ub825\ud569\ub2c8\ub2e4. \uadf8\ub8f9\ud654 \ub2e8\uacc4\uc5d0\uc11c\ub294 \uc9d1\uacc4 \uc791\uc5c5\uc744 \uc218\ud589\ud569\ub2c8\ub2e4. \ube44\uad50\uc801 \uc791\uc740 \uc5ec\ud589 \uc0d8\ud50c \ub370\uc774\ud130 \uc138\ud2b8\uc758 \uacbd\uc6b0, \uc774 \ucffc\ub9ac\ub294 \ub2e8\uc77c \ub178\ub4dc \ub370\uc2a4\ud06c\ud1b1\uc5d0\uc11c \uc57d 90ms\uac00 \uc18c\uc694\ub429\ub2c8\ub2e4. \ud558\uc9c0\ub9cc \uadf8\ub8f9\ud654\ud560 \ud544\ub4dc\uc5d0 \uc778\ub371\uc2a4\ub97c \ucd94\uac00\ud558\uba74 \uc5b4\ub5bb\uac8c \ub418\ub294\uc9c0 \uc0b4\ud3b4\ubcf4\uaca0\uc2b5\ub2c8\ub2e4:<\/p>\n<\/div>\n<\/div>\n<div class=\"sect2\">\n<h3 id=\"_indexing\">\uc778\ub371\uc2f1<\/h3>\n<div class=\"listingblock\">\n<div class=\"content\">\n<pre class=\"highlight decode:true\"><code class=\"language-SQL\">CREATE INDEX ix_hotelregions ON `travel-sample` (country, state, city) WHERE type='hotel';<\/code><\/pre>\n<\/div>\n<\/div>\n<div class=\"paragraph\">\n<p>\uc774\uc81c \uc704\uc758 \ub0b4\uc6a9\uc744 \uc2e4\ud589\ud569\ub2c8\ub2e4. <code>\uc120\ud0dd<\/code> \ub97c \ub2e4\uc2dc \ucffc\ub9ac\ud569\ub2c8\ub2e4. \ub3d9\uc77c\ud55c \uacb0\uacfc\uac00 \ubc18\ud658\ub418\uc5b4\uc57c \ud569\ub2c8\ub2e4. \ud558\uc9c0\ub9cc:<\/p>\n<\/div>\n<div class=\"ulist\">\n<ul>\n<li>\uc774\uc81c \ub2e8\uc77c \ub178\ub4dc \ub370\uc2a4\ud06c\ud1b1\uc5d0\uc11c \uc57d 7ms\uac00 \uc18c\uc694\ub429\ub2c8\ub2e4. \uba87 \ucd08\uac00 \uac78\ub9ac\uae34 \ud558\uc9c0\ub9cc, \ubcf4\ub2e4 \ud604\uc2e4\uc801\uc778 \ub300\uaddc\ubaa8 \ub370\uc774\ud130 \uc138\ud2b8\uc5d0\uc11c\ub294 \uadf8 \ucc28\uc774\uac00 \uc5c4\uccad\ub0a9\ub2c8\ub2e4.<\/li>\n<li>\ucffc\ub9ac \uacc4\ud68d\uc774 \ub2e4\ub985\ub2c8\ub2e4.<\/li>\n<\/ul>\n<\/div>\n<div class=\"paragraph\">\n<p><span class=\"image\"><img decoding=\"async\" src=\"https:\/\/www.couchbase.com\/blog\/wp-content\/uploads\/2018\/03\/10205-query-plan-with-pushdown.png\" alt=\"Query plan with pushdown\" \/><\/span><\/p>\n<\/div>\n<div class=\"paragraph\">\n<p>\uc774\ubc88\uc5d0\ub294 '\uadf8\ub8f9' \ub2e8\uacc4\uac00 \uc5c6\ub2e4\ub294 \uc810\uc5d0 \uc720\uc758\ud558\uc138\uc694. \ubaa8\ub4e0 \uc791\uc5c5\uc740 \uc778\ub371\uc2a4 \uc11c\ube44\uc2a4\ub85c \ud478\uc2dc\ub418\uace0 \uc788\uc73c\uba70, \uc774 \uc778\ub371\uc2a4 \uc11c\ube44\uc2a4\ub294 <strong>ix_hotelregions<\/strong> \uc778\ub371\uc2a4\uc785\ub2c8\ub2e4. \ub0b4 \ucffc\ub9ac\uac00 \uc778\ub371\uc2a4\uc758 \ud544\ub4dc\uc640 \uc815\ud655\ud788 \uc77c\uce58\ud558\uae30 \ub54c\ubb38\uc5d0 \uc774 \uc778\ub371\uc2a4\ub97c \uc0ac\uc6a9\ud560 \uc218 \uc788\uc2b5\ub2c8\ub2e4.<\/p>\n<\/div>\n<div class=\"paragraph\">\n<p>\uc778\ub371\uc2a4 \ud478\uc2dc\ub2e4\uc6b4\uc774 \ud56d\uc0c1 \ubc1c\uc0dd\ud558\ub294 \uac83\uc740 \uc544\ub2c8\ubbc0\ub85c \ucffc\ub9ac\uac00 \ud2b9\uc815 \uc870\uac74\uc744 \ucda9\uc871\ud574\uc57c \ud569\ub2c8\ub2e4. \uc790\uc138\ud55c \ub0b4\uc6a9\uc740 <a href=\"https:\/\/docs.couchbase.com\/server\/current\/n1ql\/n1ql-language-reference\/groupby-aggregate-performance.html\">\uadf8\ub8f9 \uae30\uc900 \ubc0f \uc9d1\uacc4 \uc2e4\uc801<\/a> \uc601\uc5ed\uc73c\ub85c \uc774\ub3d9\ud569\ub2c8\ub2e4.<\/p>\n<\/div>\n<\/div>\n<\/div>\n<\/div>\n<div class=\"sect1\">\n<h2 id=\"_summary\">\uc694\uc57d<\/h2>\n<div class=\"sectionbody\">\n<div class=\"paragraph\">\n<p>\ud568\uaed8 <a href=\"https:\/\/www.couchbase.com\/blog\/ko\/announcing-couchbase-server-5-5\/\">\uce74\uc6b0\uce58\ubca0\uc774\uc2a4 \uc11c\ubc84 5.5<\/a>N1QL\uc5d0\ub294 \ud6e8\uc52c \ub354 \ub9ce\uc740 \ud45c\uc900\uc744 \uc900\uc218\ud558\ub294 \uad6c\ubb38\uc774 \ud3ec\ud568\ub418\uc5b4 \uc788\uc73c\uba70 \uadf8 \uc5b4\ub290 \ub54c\ubcf4\ub2e4 \uc131\ub2a5\uc774 \ud5a5\uc0c1\ub418\uc5c8\uc2b5\ub2c8\ub2e4.<\/p>\n<\/div>\n<div class=\"paragraph\">\n<p>\uc9c0\uae08 N1QL\uc744 \uc0ac\uc6a9\ud574 \ubcf4\uc138\uc694. \ub2e4\uc74c\uc744 \uc218\ud589\ud560 \uc218 \uc788\uc2b5\ub2c8\ub2e4. <a href=\"https:\/\/www.couchbase.com\/blog\/ko\/downloads\/\">\uc5d4\ud130\ud504\ub77c\uc774\uc988 \uc5d0\ub514\uc158 \uc124\uce58<\/a> \ub610\ub294 <a href=\"https:\/\/developer.couchbase.com\/tutorials\">\ube0c\ub77c\uc6b0\uc800\uc5d0\uc11c \ubc14\ub85c N1QL\uc744 \uc0ac\uc6a9\ud574 \ubcf4\uc138\uc694.<\/a>.<\/p>\n<\/div>\n<div class=\"paragraph\">\n<p>\uc9c8\ubb38\uc774 \uc788\uc73c\uc2e0\uac00\uc694? I'm on <a href=\"https:\/\/twitter.com\/mgroves\">\ud2b8\uc704\ud130 @mgroves<\/a>. \ub610\ud55c \ub2e4\uc74c\uc744 \ud655\uc778\ud560 \uc218\ub3c4 \uc788\uc2b5\ub2c8\ub2e4. <a href=\"https:\/\/twitter.com\/N1QL\">\ud2b8\uc704\ud130\uc758 @N1QL<\/a>. . <a href=\"https:\/\/www.couchbase.com\/blog\/ko\/forums\/c\/sql\/16\/\">N1QL \ud3ec\ub7fc<\/a> \ub294 N1QL\uc5d0 \ub300\ud55c \uc2ec\uce35\uc801\uc778 \uc9c8\ubb38\uc774 \uc788\ub294 \uacbd\uc6b0 \ubc29\ubb38\ud558\uae30 \uc88b\uc740 \uacf3\uc785\ub2c8\ub2e4.<\/p>\n<\/div>\n<\/div>\n<\/div>","protected":false},"excerpt":{"rendered":"<p>New querying features figure prominently in the latest release of Couchbase Server 5.5. Check out the announcement and download the release for free right now. In this post, I want to highlight a few of the new features and show [&hellip;]<\/p>","protected":false},"author":71,"featured_media":4757,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_acf_changed":false,"inline_featured_image":false,"footnotes":""},"categories":[1816,1812],"tags":[2258,2173,2041,2182,1759],"ppma_author":[8937],"class_list":["post-4756","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-couchbase-server","category-n1ql-query","tag-5-5","tag-aggregates","tag-aggregation","tag-devbuild","tag-hash"],"acf":[],"yoast_head":"<!-- This site is optimized with the Yoast SEO Premium plugin v26.2 (Yoast SEO v26.2) - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>New Querying Features in Couchbase Server 5.5 - The Couchbase Blog<\/title>\n<meta name=\"description\" content=\"New querying features figure prominently in the latest release of Couchbase Server. ANSI JOINs, HASH joins, aggregate pushdowns are covered in this post.\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/www.couchbase.com\/blog\/ko\/new-querying-features-couchbase-server\/\" \/>\n<meta property=\"og:locale\" content=\"ko_KR\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"New Querying Features in Couchbase Server 5.5\" \/>\n<meta property=\"og:description\" content=\"New querying features figure prominently in the latest release of Couchbase Server. ANSI JOINs, HASH joins, aggregate pushdowns are covered in this post.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.couchbase.com\/blog\/ko\/new-querying-features-couchbase-server\/\" \/>\n<meta property=\"og:site_name\" content=\"The Couchbase Blog\" \/>\n<meta property=\"article:published_time\" content=\"2018-03-09T20:06:43+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2025-06-14T00:32:48+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/www.couchbase.com\/blog\/wp-content\/uploads\/sites\/1\/2018\/03\/102-hero-query.jpg\" \/>\n\t<meta property=\"og:image:width\" content=\"1920\" \/>\n\t<meta property=\"og:image:height\" content=\"1056\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/jpeg\" \/>\n<meta name=\"author\" content=\"Matthew Groves\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:creator\" content=\"@mgroves\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"Matthew Groves\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"7\ubd84\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\/\/www.couchbase.com\/blog\/new-querying-features-couchbase-server\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/www.couchbase.com\/blog\/new-querying-features-couchbase-server\/\"},\"author\":{\"name\":\"Matthew Groves\",\"@id\":\"https:\/\/www.couchbase.com\/blog\/#\/schema\/person\/3929663e372020321b0152dc4fa65a58\"},\"headline\":\"New Querying Features in Couchbase Server 5.5\",\"datePublished\":\"2018-03-09T20:06:43+00:00\",\"dateModified\":\"2025-06-14T00:32:48+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/www.couchbase.com\/blog\/new-querying-features-couchbase-server\/\"},\"wordCount\":1124,\"commentCount\":3,\"publisher\":{\"@id\":\"https:\/\/www.couchbase.com\/blog\/#organization\"},\"image\":{\"@id\":\"https:\/\/www.couchbase.com\/blog\/new-querying-features-couchbase-server\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/www.couchbase.com\/blog\/wp-content\/uploads\/sites\/1\/2018\/03\/102-hero-query.jpg\",\"keywords\":[\"5.5\",\"aggregates\",\"aggregation\",\"devbuild\",\"hash\"],\"articleSection\":[\"Couchbase Server\",\"SQL++ \/ N1QL Query\"],\"inLanguage\":\"ko-KR\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\/\/www.couchbase.com\/blog\/new-querying-features-couchbase-server\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/www.couchbase.com\/blog\/new-querying-features-couchbase-server\/\",\"url\":\"https:\/\/www.couchbase.com\/blog\/new-querying-features-couchbase-server\/\",\"name\":\"New Querying Features in Couchbase Server 5.5 - The Couchbase Blog\",\"isPartOf\":{\"@id\":\"https:\/\/www.couchbase.com\/blog\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/www.couchbase.com\/blog\/new-querying-features-couchbase-server\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/www.couchbase.com\/blog\/new-querying-features-couchbase-server\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/www.couchbase.com\/blog\/wp-content\/uploads\/sites\/1\/2018\/03\/102-hero-query.jpg\",\"datePublished\":\"2018-03-09T20:06:43+00:00\",\"dateModified\":\"2025-06-14T00:32:48+00:00\",\"description\":\"New querying features figure prominently in the latest release of Couchbase Server. ANSI JOINs, HASH joins, aggregate pushdowns are covered in this post.\",\"breadcrumb\":{\"@id\":\"https:\/\/www.couchbase.com\/blog\/new-querying-features-couchbase-server\/#breadcrumb\"},\"inLanguage\":\"ko-KR\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/www.couchbase.com\/blog\/new-querying-features-couchbase-server\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"ko-KR\",\"@id\":\"https:\/\/www.couchbase.com\/blog\/new-querying-features-couchbase-server\/#primaryimage\",\"url\":\"https:\/\/www.couchbase.com\/blog\/wp-content\/uploads\/sites\/1\/2018\/03\/102-hero-query.jpg\",\"contentUrl\":\"https:\/\/www.couchbase.com\/blog\/wp-content\/uploads\/sites\/1\/2018\/03\/102-hero-query.jpg\",\"width\":1920,\"height\":1056,\"caption\":\"Question marks, querying from https:\/\/pixabay.com\/en\/question-mark-important-sign-1872665\/\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/www.couchbase.com\/blog\/new-querying-features-couchbase-server\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/www.couchbase.com\/blog\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"New Querying Features in Couchbase Server 5.5\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/www.couchbase.com\/blog\/#website\",\"url\":\"https:\/\/www.couchbase.com\/blog\/\",\"name\":\"The Couchbase Blog\",\"description\":\"Couchbase, the NoSQL Database\",\"publisher\":{\"@id\":\"https:\/\/www.couchbase.com\/blog\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/www.couchbase.com\/blog\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"ko-KR\"},{\"@type\":\"Organization\",\"@id\":\"https:\/\/www.couchbase.com\/blog\/#organization\",\"name\":\"The Couchbase Blog\",\"url\":\"https:\/\/www.couchbase.com\/blog\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"ko-KR\",\"@id\":\"https:\/\/www.couchbase.com\/blog\/#\/schema\/logo\/image\/\",\"url\":\"https:\/\/www.couchbase.com\/blog\/wp-content\/uploads\/2023\/04\/admin-logo.png\",\"contentUrl\":\"https:\/\/www.couchbase.com\/blog\/wp-content\/uploads\/2023\/04\/admin-logo.png\",\"width\":218,\"height\":34,\"caption\":\"The Couchbase Blog\"},\"image\":{\"@id\":\"https:\/\/www.couchbase.com\/blog\/#\/schema\/logo\/image\/\"}},{\"@type\":\"Person\",\"@id\":\"https:\/\/www.couchbase.com\/blog\/#\/schema\/person\/3929663e372020321b0152dc4fa65a58\",\"name\":\"Matthew Groves\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"ko-KR\",\"@id\":\"https:\/\/www.couchbase.com\/blog\/#\/schema\/person\/image\/ba51e6aacc53995c323a634e4502ef54\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/70feb1b28a099ad0112b8d21fe1e81e1a4524beed3e20b7f107d5370e85a07ab?s=96&d=mm&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/70feb1b28a099ad0112b8d21fe1e81e1a4524beed3e20b7f107d5370e85a07ab?s=96&d=mm&r=g\",\"caption\":\"Matthew Groves\"},\"description\":\"Matthew D. Groves is a guy who loves to code. It doesn't matter if it's C#, jQuery, or PHP: he'll submit pull requests for anything. He has been coding professionally ever since he wrote a QuickBASIC point-of-sale app for his parent's pizza shop back in the 90s. He currently works as a Senior Product Marketing Manager for Couchbase. His free time is spent with his family, watching the Reds, and getting involved in the developer community. He is the author of AOP in .NET, Pro Microservices in .NET, a Pluralsight author, and a Microsoft MVP.\",\"sameAs\":[\"https:\/\/crosscuttingconcerns.com\",\"https:\/\/x.com\/mgroves\"],\"url\":\"https:\/\/www.couchbase.com\/blog\/ko\/author\/matthew-groves\/\"}]}<\/script>\n<!-- \/ Yoast SEO Premium plugin. -->","yoast_head_json":{"title":"New Querying Features in Couchbase Server 5.5 - The Couchbase Blog","description":"\uc0c8\ub85c\uc6b4 \ucffc\ub9ac \uae30\ub2a5\uc740 Couchbase Server\uc758 \ucd5c\uc2e0 \ub9b4\ub9ac\uc2a4\uc5d0\uc11c \ub450\ub4dc\ub7ec\uc9c0\uac8c \ub098\ud0c0\ub0a9\ub2c8\ub2e4. \uc774 \uac8c\uc2dc\ubb3c\uc5d0\uc11c\ub294 ANSI \uc870\uc778, \ud574\uc2dc \uc870\uc778, \uc9d1\uacc4 \ud478\uc2dc\ub2e4\uc6b4\uc5d0 \ub300\ud574 \ub2e4\ub8f9\ub2c8\ub2e4.","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/www.couchbase.com\/blog\/ko\/new-querying-features-couchbase-server\/","og_locale":"ko_KR","og_type":"article","og_title":"New Querying Features in Couchbase Server 5.5","og_description":"New querying features figure prominently in the latest release of Couchbase Server. ANSI JOINs, HASH joins, aggregate pushdowns are covered in this post.","og_url":"https:\/\/www.couchbase.com\/blog\/ko\/new-querying-features-couchbase-server\/","og_site_name":"The Couchbase Blog","article_published_time":"2018-03-09T20:06:43+00:00","article_modified_time":"2025-06-14T00:32:48+00:00","og_image":[{"width":1920,"height":1056,"url":"https:\/\/www.couchbase.com\/blog\/wp-content\/uploads\/sites\/1\/2018\/03\/102-hero-query.jpg","type":"image\/jpeg"}],"author":"Matthew Groves","twitter_card":"summary_large_image","twitter_creator":"@mgroves","twitter_misc":{"Written by":"Matthew Groves","Est. reading time":"7\ubd84"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/www.couchbase.com\/blog\/new-querying-features-couchbase-server\/#article","isPartOf":{"@id":"https:\/\/www.couchbase.com\/blog\/new-querying-features-couchbase-server\/"},"author":{"name":"Matthew Groves","@id":"https:\/\/www.couchbase.com\/blog\/#\/schema\/person\/3929663e372020321b0152dc4fa65a58"},"headline":"New Querying Features in Couchbase Server 5.5","datePublished":"2018-03-09T20:06:43+00:00","dateModified":"2025-06-14T00:32:48+00:00","mainEntityOfPage":{"@id":"https:\/\/www.couchbase.com\/blog\/new-querying-features-couchbase-server\/"},"wordCount":1124,"commentCount":3,"publisher":{"@id":"https:\/\/www.couchbase.com\/blog\/#organization"},"image":{"@id":"https:\/\/www.couchbase.com\/blog\/new-querying-features-couchbase-server\/#primaryimage"},"thumbnailUrl":"https:\/\/www.couchbase.com\/blog\/wp-content\/uploads\/sites\/1\/2018\/03\/102-hero-query.jpg","keywords":["5.5","aggregates","aggregation","devbuild","hash"],"articleSection":["Couchbase Server","SQL++ \/ N1QL Query"],"inLanguage":"ko-KR","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/www.couchbase.com\/blog\/new-querying-features-couchbase-server\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/www.couchbase.com\/blog\/new-querying-features-couchbase-server\/","url":"https:\/\/www.couchbase.com\/blog\/new-querying-features-couchbase-server\/","name":"New Querying Features in Couchbase Server 5.5 - The Couchbase Blog","isPartOf":{"@id":"https:\/\/www.couchbase.com\/blog\/#website"},"primaryImageOfPage":{"@id":"https:\/\/www.couchbase.com\/blog\/new-querying-features-couchbase-server\/#primaryimage"},"image":{"@id":"https:\/\/www.couchbase.com\/blog\/new-querying-features-couchbase-server\/#primaryimage"},"thumbnailUrl":"https:\/\/www.couchbase.com\/blog\/wp-content\/uploads\/sites\/1\/2018\/03\/102-hero-query.jpg","datePublished":"2018-03-09T20:06:43+00:00","dateModified":"2025-06-14T00:32:48+00:00","description":"\uc0c8\ub85c\uc6b4 \ucffc\ub9ac \uae30\ub2a5\uc740 Couchbase Server\uc758 \ucd5c\uc2e0 \ub9b4\ub9ac\uc2a4\uc5d0\uc11c \ub450\ub4dc\ub7ec\uc9c0\uac8c \ub098\ud0c0\ub0a9\ub2c8\ub2e4. \uc774 \uac8c\uc2dc\ubb3c\uc5d0\uc11c\ub294 ANSI \uc870\uc778, \ud574\uc2dc \uc870\uc778, \uc9d1\uacc4 \ud478\uc2dc\ub2e4\uc6b4\uc5d0 \ub300\ud574 \ub2e4\ub8f9\ub2c8\ub2e4.","breadcrumb":{"@id":"https:\/\/www.couchbase.com\/blog\/new-querying-features-couchbase-server\/#breadcrumb"},"inLanguage":"ko-KR","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.couchbase.com\/blog\/new-querying-features-couchbase-server\/"]}]},{"@type":"ImageObject","inLanguage":"ko-KR","@id":"https:\/\/www.couchbase.com\/blog\/new-querying-features-couchbase-server\/#primaryimage","url":"https:\/\/www.couchbase.com\/blog\/wp-content\/uploads\/sites\/1\/2018\/03\/102-hero-query.jpg","contentUrl":"https:\/\/www.couchbase.com\/blog\/wp-content\/uploads\/sites\/1\/2018\/03\/102-hero-query.jpg","width":1920,"height":1056,"caption":"Question marks, querying from https:\/\/pixabay.com\/en\/question-mark-important-sign-1872665\/"},{"@type":"BreadcrumbList","@id":"https:\/\/www.couchbase.com\/blog\/new-querying-features-couchbase-server\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/www.couchbase.com\/blog\/"},{"@type":"ListItem","position":2,"name":"New Querying Features in Couchbase Server 5.5"}]},{"@type":"WebSite","@id":"https:\/\/www.couchbase.com\/blog\/#website","url":"https:\/\/www.couchbase.com\/blog\/","name":"\uce74\uc6b0\uce58\ubca0\uc774\uc2a4 \ube14\ub85c\uadf8","description":"NoSQL \ub370\uc774\ud130\ubca0\uc774\uc2a4, Couchbase","publisher":{"@id":"https:\/\/www.couchbase.com\/blog\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/www.couchbase.com\/blog\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"ko-KR"},{"@type":"Organization","@id":"https:\/\/www.couchbase.com\/blog\/#organization","name":"\uce74\uc6b0\uce58\ubca0\uc774\uc2a4 \ube14\ub85c\uadf8","url":"https:\/\/www.couchbase.com\/blog\/","logo":{"@type":"ImageObject","inLanguage":"ko-KR","@id":"https:\/\/www.couchbase.com\/blog\/#\/schema\/logo\/image\/","url":"https:\/\/www.couchbase.com\/blog\/wp-content\/uploads\/2023\/04\/admin-logo.png","contentUrl":"https:\/\/www.couchbase.com\/blog\/wp-content\/uploads\/2023\/04\/admin-logo.png","width":218,"height":34,"caption":"The Couchbase Blog"},"image":{"@id":"https:\/\/www.couchbase.com\/blog\/#\/schema\/logo\/image\/"}},{"@type":"Person","@id":"https:\/\/www.couchbase.com\/blog\/#\/schema\/person\/3929663e372020321b0152dc4fa65a58","name":"\ub9e4\ud29c \uadf8\ub85c\ube0c\uc2a4","image":{"@type":"ImageObject","inLanguage":"ko-KR","@id":"https:\/\/www.couchbase.com\/blog\/#\/schema\/person\/image\/ba51e6aacc53995c323a634e4502ef54","url":"https:\/\/secure.gravatar.com\/avatar\/70feb1b28a099ad0112b8d21fe1e81e1a4524beed3e20b7f107d5370e85a07ab?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/70feb1b28a099ad0112b8d21fe1e81e1a4524beed3e20b7f107d5370e85a07ab?s=96&d=mm&r=g","caption":"Matthew Groves"},"description":"Matthew D. Groves\ub294 \ucf54\ub529\uc744 \uc88b\uc544\ud558\ub294 \uc0ac\ub78c\uc785\ub2c8\ub2e4. C#, jQuery, PHP \ub4f1 \ubb34\uc5c7\uc774\ub4e0 \ud480 \ub9ac\ud018\uc2a4\ud2b8\ub97c \uc81c\ucd9c\ud560 \uc815\ub3c4\ub85c \ucf54\ub529\uc744 \uc88b\uc544\ud569\ub2c8\ub2e4. 90\ub144\ub300\uc5d0 \ubd80\ubaa8\ub2d8\uc758 \ud53c\uc790 \uac00\uac8c\ub97c \uc704\ud574 QuickBASIC POS \uc571\uc744 \ub9cc\ub4e0 \uc774\ud6c4\ub85c \uc804\ubb38\uc801\uc73c\ub85c \ucf54\ub529\uc744 \ud574\uc654\uc2b5\ub2c8\ub2e4. \ud604\uc7ac Couchbase\uc758 \uc120\uc784 \uc81c\ud488 \ub9c8\ucf00\ud305 \uad00\ub9ac\uc790\ub85c \uc77c\ud558\uace0 \uc788\uc2b5\ub2c8\ub2e4. \uc5ec\uac00 \uc2dc\uac04\uc5d0\ub294 \uac00\uc871\uacfc \ud568\uaed8 \ucd95\uad6c \uacbd\uae30\ub97c \uad00\ub78c\ud558\uace0 \uac1c\ubc1c\uc790 \ucee4\ubba4\ub2c8\ud2f0\uc5d0 \ucc38\uc5ec\ud558\uba70 \uc2dc\uac04\uc744 \ubcf4\ub0c5\ub2c8\ub2e4. \uadf8\ub294 .NET\uc758 AOP, .NET\uc758 \ud504\ub85c \ub9c8\uc774\ud06c\ub85c\uc11c\ube44\uc2a4, Pluralsight \uc800\uc790, Microsoft MVP\uc758 \uc800\uc790\uc774\uae30\ub3c4 \ud569\ub2c8\ub2e4.","sameAs":["https:\/\/crosscuttingconcerns.com","https:\/\/x.com\/mgroves"],"url":"https:\/\/www.couchbase.com\/blog\/ko\/author\/matthew-groves\/"}]}},"authors":[{"term_id":8937,"user_id":71,"is_guest":0,"slug":"matthew-groves","display_name":"Matthew Groves","avatar_url":"https:\/\/secure.gravatar.com\/avatar\/70feb1b28a099ad0112b8d21fe1e81e1a4524beed3e20b7f107d5370e85a07ab?s=96&d=mm&r=g","author_category":"","last_name":"Groves","first_name":"Matthew","job_title":"","user_url":"https:\/\/crosscuttingconcerns.com","description":"Matthew D. Groves\ub294 \ucf54\ub529\uc744 \uc88b\uc544\ud558\ub294 \uc0ac\ub78c\uc785\ub2c8\ub2e4.  C#, jQuery, PHP \ub4f1 \ubb34\uc5c7\uc774\ub4e0 \ud480 \ub9ac\ud018\uc2a4\ud2b8\ub97c \uc81c\ucd9c\ud560 \uc815\ub3c4\ub85c \ucf54\ub529\uc744 \uc88b\uc544\ud569\ub2c8\ub2e4.  90\ub144\ub300\uc5d0 \ubd80\ubaa8\ub2d8\uc758 \ud53c\uc790 \uac00\uac8c\ub97c \uc704\ud574 QuickBASIC POS \uc571\uc744 \ub9cc\ub4e0 \uc774\ud6c4\ub85c \uc804\ubb38\uc801\uc73c\ub85c \ucf54\ub529\uc744 \ud574\uc654\uc2b5\ub2c8\ub2e4.  \ud604\uc7ac Couchbase\uc758 \uc120\uc784 \uc81c\ud488 \ub9c8\ucf00\ud305 \uad00\ub9ac\uc790\ub85c \uc77c\ud558\uace0 \uc788\uc2b5\ub2c8\ub2e4. \uc5ec\uac00 \uc2dc\uac04\uc5d0\ub294 \uac00\uc871\uacfc \ud568\uaed8 \ucd95\uad6c \uacbd\uae30\ub97c \uad00\ub78c\ud558\uace0 \uac1c\ubc1c\uc790 \ucee4\ubba4\ub2c8\ud2f0\uc5d0 \ucc38\uc5ec\ud558\uba70 \uc2dc\uac04\uc744 \ubcf4\ub0c5\ub2c8\ub2e4.  \uadf8\ub294 .NET\uc758 AOP, .NET\uc758 \ud504\ub85c \ub9c8\uc774\ud06c\ub85c\uc11c\ube44\uc2a4, Pluralsight \uc800\uc790, Microsoft MVP\uc758 \uc800\uc790\uc774\uae30\ub3c4 \ud569\ub2c8\ub2e4."}],"_links":{"self":[{"href":"https:\/\/www.couchbase.com\/blog\/ko\/wp-json\/wp\/v2\/posts\/4756","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.couchbase.com\/blog\/ko\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.couchbase.com\/blog\/ko\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.couchbase.com\/blog\/ko\/wp-json\/wp\/v2\/users\/71"}],"replies":[{"embeddable":true,"href":"https:\/\/www.couchbase.com\/blog\/ko\/wp-json\/wp\/v2\/comments?post=4756"}],"version-history":[{"count":0,"href":"https:\/\/www.couchbase.com\/blog\/ko\/wp-json\/wp\/v2\/posts\/4756\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.couchbase.com\/blog\/ko\/wp-json\/wp\/v2\/media\/4757"}],"wp:attachment":[{"href":"https:\/\/www.couchbase.com\/blog\/ko\/wp-json\/wp\/v2\/media?parent=4756"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.couchbase.com\/blog\/ko\/wp-json\/wp\/v2\/categories?post=4756"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.couchbase.com\/blog\/ko\/wp-json\/wp\/v2\/tags?post=4756"},{"taxonomy":"author","embeddable":true,"href":"https:\/\/www.couchbase.com\/blog\/ko\/wp-json\/wp\/v2\/ppma_author?post=4756"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}