{"id":7120,"date":"2019-06-22T10:42:41","date_gmt":"2019-06-22T17:42:41","guid":{"rendered":"https:\/\/www.couchbase.com\/blog\/?p=7120"},"modified":"2025-06-13T17:22:02","modified_gmt":"2025-06-14T00:22:02","slug":"a-preview-of-couchbase-6-5-n1ql-features","status":"publish","type":"post","link":"https:\/\/www.couchbase.com\/blog\/ko\/a-preview-of-couchbase-6-5-n1ql-features\/","title":{"rendered":"Couchbase 6.5 N1QL \uae30\ub2a5 \ubbf8\ub9ac\ubcf4\uae30"},"content":{"rendered":"<p>Couchbase 6.5 \ub9b4\ub9ac\uc2a4\ub294 \ucf58\ud150\uce20 \uce21\uba74\uc5d0\uc11c \uac00\uc7a5 \ud070 \ub9b4\ub9ac\uc2a4 \uc911 \ud558\ub098\uc785\ub2c8\ub2e4. N1QL \ucffc\ub9ac \uc11c\ube44\uc2a4\uc758 \uacbd\uc6b0, \uc5d4\ud130\ud504\ub77c\uc774\uc988 \ub370\uc774\ud130\ubca0\uc774\uc2a4 \uae30\ub2a5\uc744 Couchbase \ub370\uc774\ud130\ubca0\uc774\uc2a4\uc5d0 \ub3c4\uc785\ud558\ub294 \ub370 \uc911\uc810\uc744 \ub450\uc5c8\uc2b5\ub2c8\ub2e4. \uac1c\ubc1c\uc790\uc758 \uc0dd\uc0b0\uc131 \ud5a5\uc0c1\uc744 \ubaa9\ud45c\ub85c \uc5d4\ud130\ud504\ub77c\uc774\uc988 \uc560\ud50c\ub9ac\ucf00\uc774\uc158 \uc694\uad6c \uc0ac\ud56d\uc744 \uc9c0\uc6d0\ud558\uae30 \uc704\ud55c \ucd94\uac00 \uae30\ub2a5\uc73c\ub85c N1QL\uc744 \ud655\uc7a5\ud569\ub2c8\ub2e4.<\/p>\n<p>\ub2e4\uc74c\uc740 N1QL \uae30\ub2a5\uc5d0 \ub300\ud55c \uc694\uc57d\uc785\ub2c8\ub2e4.<\/p>\n<h4>N1QL \uac80\uc0c9()<\/h4>\n<p>N1QL\uc740 N1QL Search() \ud568\uc218\ub97c \ud1b5\ud574 \uc804\uccb4 \ud14d\uc2a4\ud2b8 \uac80\uc0c9 \uae30\ub2a5\uc744 \ucd94\uac00\ud588\uc2b5\ub2c8\ub2e4. \uc774 \uae30\ub2a5\uc740 \ud0a4\uc6cc\ub4dc \ubc0f \ud37c\uc9c0 \uac80\uc0c9\uacfc \uac19\uc740 \ub2e4\uc591\ud55c \ud14d\uc2a4\ud2b8 \uac80\uc0c9 \uae30\ub2a5\uc744 \uc81c\uacf5\ud558\uae30 \uc704\ud574 Couchbase \uc804\uccb4 \ud14d\uc2a4\ud2b8 \uac80\uc0c9\uc744 \ud65c\uc6a9\ud569\ub2c8\ub2e4. \uc804\uccb4 \ud14d\uc2a4\ud2b8 \uac80\uc0c9\uc740 \ub2e4\ucc28\uc6d0 \ud655\uc7a5 \uae30\ub2a5\uc744 \uac16\ucd98 \ubcc4\ub3c4\uc758 \uc11c\ube44\uc2a4\ub85c \uc2e4\ud589\ub418\ub294 Couchbase \ub370\uc774\ud130 \ud50c\ub7ab\ud3fc\uc758 \uc77c\ubd80\uc785\ub2c8\ub2e4. \ubcc4\ub3c4\uc758 \uac80\uc0c9 \uc5d4\uc9c4\uc774 \ud544\uc694\ud558\uc9c0 \uc54a\uc73c\uba70, \ub370\uc774\ud130\ub97c \ubcc4\ub3c4\uc758 \uc11c\ube44\uc2a4\ub85c \uac00\uc838\uc62c \ud544\uc694\ub3c4 \uc5c6\uc2b5\ub2c8\ub2e4. \uc774\uc81c N1QL \uc0ac\uc6a9\uc790\ub294 \ud558\ub098\uc758 \ubb38\uc5d0\uc11c \uc804\uccb4 \ud14d\uc2a4\ud2b8 \uac80\uc0c9\uacfc \ud45c\uc900 N1QL \uc220\uc5b4\ub97c \ubaa8\ub450 \ud65c\uc6a9\ud560 \uc218 \uc788\uc2b5\ub2c8\ub2e4.<\/p>\n<pre class=\"lang:default decode:true\">Match Query: SELECT * \r\n             FROM `beer-sample`  b\r\n             WHERE SEARCH(b,{\"match\":\"hoppiest\",\"field\":\"description\"})\r\n                   AND b.abv &gt; 3\r\n             ORDER BY b.abv DESC\r\n             LIMIT 10 OFFSET 20\r\n\r\nFuzzy Match: SELECT RAW META(t1).id \r\n             FROM `travel-sample` AS t1 \r\n             WHERE SEARCH(t1, { \"match\": \"interest\", \r\n                 \"field\": \"reviews.content\", \"fuzziness\":2}) ;\r\n\r\nRegexp:      SELECT RAW META(t1).id \r\n             FROM `travel-sample` AS t1 \r\n             WHERE SEARCH(t1, {\"regexp\": \"inter.+\",\r\n                 \"field\": \"reviews.content\"}); \r\n\r\nDate Range:  SELECT RAW META(t1).id \r\n             FROM `travel-sample` AS t1 \r\n             WHERE SEARCH(t1, { \"start\": \"2001-10-09T10:20:30-08:00\", \r\n                                \"end\": \"2016-10-31\", \r\n                                \"inclusive_start\": false, \r\n                                \"inclusive_end\": false, \r\n                                \"field\": \"reviews.date\" }); \r\nGeospatial:  SELECT RAW META(t1).id \r\n             FROM `travel-sample` AS t1 \r\n             WHERE SEARCH(t1, { \"location\": { \"lon\": -2.235143, \r\n                                              \"lat\": 53.482358 }, \r\n                                \"distance\": \"100mi\", \r\n                                \"field\": \"geo\" }); \r\n<\/pre>\n<h4>N1QL \ucc3d \ubc0f \ubd84\uc11d \uae30\ub2a5<\/h4>\n<p>\ucc3d \ud568\uc218\ub294 \uae30\ubcf8 \ucffc\ub9ac \uc9d1\uacc4\ub97c \ud655\uc7a5\ud558\uc5ec \uc0ac\uc6a9\uc790\uac00 \ubcf5\uc7a1\ud55c \ucffc\ub9ac\uc640 \uc870\uc778\uc744 \uc791\uc131\ud574\uc57c \ud558\ub294 \ubcf5\uc7a1\ud55c \ube44\uc988\ub2c8\uc2a4 \uc9c8\ubb38\uc744 \uc9c1\uad00\uc801\uc778 N1QL \uad6c\uc870\ub85c \ucc98\ub9ac\ud560 \uc218 \uc788\ub3c4\ub85d \ud569\ub2c8\ub2e4.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-7125\" src=\"https:\/\/www.couchbase.com\/blog\/wp-content\/uploads\/2019\/06\/Screen-Shot-2019-06-19-at-1.16.56-PM.png\" alt=\"\" width=\"697\" height=\"411\" srcset=\"https:\/\/www.couchbase.com\/blog\/wp-content\/uploads\/sites\/1\/2019\/06\/Screen-Shot-2019-06-19-at-1.16.56-PM.png 697w, https:\/\/www.couchbase.com\/blog\/wp-content\/uploads\/sites\/1\/2019\/06\/Screen-Shot-2019-06-19-at-1.16.56-PM-300x177.png 300w, https:\/\/www.couchbase.com\/blog\/wp-content\/uploads\/sites\/1\/2019\/06\/Screen-Shot-2019-06-19-at-1.16.56-PM-20x12.png 20w\" sizes=\"auto, (max-width: 697px) 100vw, 697px\" \/><\/p>\n<h4>N1QL \uacf5\ud1b5 \ud14c\uc774\ube14 \ud45c\ud604\uc2dd<\/h4>\n<p>\uacf5\ud1b5 \ud14c\uc774\ube14 \ud45c\ud604\uc2dd\uc740 \uc0ac\uc6a9\uc790\uac00 \ucffc\ub9ac \ube14\ub85d\uc5d0 \uc774\ub984\uc744 \ud560\ub2f9\ud558\uace0 \ub098\uc911\uc5d0 \ub098\uba38\uc9c0 \ucffc\ub9ac\uc5d0\uc11c \ucc38\uc870\ud560 \uc218 \uc788\ub3c4\ub85d N1QL\uc5d0 WITH \uad6c\ubb38\uc744 \ub3c4\uc785\ud569\ub2c8\ub2e4.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone wp-image-7123\" src=\"https:\/\/www.couchbase.com\/blog\/wp-content\/uploads\/2019\/06\/Screen-Shot-2019-06-19-at-11.05.55-AM.png\" alt=\"\" width=\"780\" height=\"453\" srcset=\"https:\/\/www.couchbase.com\/blog\/wp-content\/uploads\/sites\/1\/2019\/06\/Screen-Shot-2019-06-19-at-11.05.55-AM.png 1294w, https:\/\/www.couchbase.com\/blog\/wp-content\/uploads\/sites\/1\/2019\/06\/Screen-Shot-2019-06-19-at-11.05.55-AM-300x174.png 300w, https:\/\/www.couchbase.com\/blog\/wp-content\/uploads\/sites\/1\/2019\/06\/Screen-Shot-2019-06-19-at-11.05.55-AM-1024x595.png 1024w, https:\/\/www.couchbase.com\/blog\/wp-content\/uploads\/sites\/1\/2019\/06\/Screen-Shot-2019-06-19-at-11.05.55-AM-768x446.png 768w, https:\/\/www.couchbase.com\/blog\/wp-content\/uploads\/sites\/1\/2019\/06\/Screen-Shot-2019-06-19-at-11.05.55-AM-20x12.png 20w\" sizes=\"auto, (max-width: 780px) 100vw, 780px\" \/><\/p>\n<h4>N1QL \uc0ac\uc6a9\uc790 \uc815\uc758 \ud568\uc218<\/h4>\n<p>\uac1c\ubc1c\uc790\uac00 N1QL \ucffc\ub9ac\uc5d0\uc11c \ud638\ucd9c\ud560 \uc218 \uc788\ub294 \uc0ac\uc6a9\uc790 \uc815\uc758 N1QL \ud568\uc218\ub97c \uc815\uc758\ud560 \uc218 \uc788\uc2b5\ub2c8\ub2e4. \ubaa8\ub4e0 \uc560\ud50c\ub9ac\ucf00\uc774\uc158 \ubc0f \ub9c8\uc774\ud06c\ub85c \uc11c\ube44\uc2a4\uc5d0\uc11c \uc7ac\uc0ac\uc6a9\ud560 \uc218 \uc788\ub294 N1QL \uc560\ud50c\ub9ac\ucf00\uc774\uc158 \ub85c\uc9c1\uc744 \uaca9\ub9ac\ud560 \uc218 \uc788\uc2b5\ub2c8\ub2e4.<\/p>\n<pre class=\"lang:default decode:true\">CREATE FUNCTION func1(type) { \r\n  (select * from `travel-sample` where `travel-sample`.type = type) \r\n}\r\n\r\nEXECUTE FUNCTION func1(\"airline\")\r\n<\/pre>\n<h4>\ud558\uc704 \ucffc\ub9ac JOIN<\/h4>\n<p>\uce74\uc6b0\uce58\ubca0\uc774\uc2a4 \ub370\uc774\ud130\ubca0\uc774\uc2a4\ub294 \ud558\uc704 \ucffc\ub9ac\ub97c \uc0ac\uc6a9\ud55c \uc870\uc778\uc744 \ud3ec\ud568\ud558\uc5ec \uc870\uc778\uc5d0\uc11c \ub3d9\uc801 \ucffc\ub9ac \uacb0\uacfc \uc9d1\ud569\uc744 \uc0ac\uc6a9\ud560 \uc218 \uc788\ub3c4\ub85d ANSI \uc870\uc778\uc5d0 \ub300\ud55c \uc9c0\uc6d0\uc744 \uac15\ud654\ud569\ub2c8\ub2e4.<\/p>\n<pre class=\"lang:default decode:true\">SELECT  cus.name Customer, \r\n        cus.industry Industry, \r\n        usr.name Owner, \r\n        count(1) NumOfMeetings, \t\t\r\n\tsum(to_number(act.duration)) `Time Spent`\r\nFROM crm act \r\n  INNER JOIN crm cus ON act.accid = cus.id AND cus.type = 'account'\r\n  INNER JOIN crm usr ON cus.owner = usr.id AND usr.type = 'user'\r\n  <strong>JOIN<\/strong> ( select thl.id from crm thl WHERE thl.type ='_territory_hier_level' \r\n\t\tAND thl.parent='ter3') ter  <strong>\ucf1c\uae30<\/strong> cus.terid = ter.id \r\nWHERE act.type='activity'  \r\n  AND act.activityType='Appointment'\r\n  AND DATE_PART_STR(act.startDate, 'year') =2018 \r\nGROUP BY cus.name, cus.industry,  usr.name<\/pre>\n<p>\ub2e4\uc74c \uae30\ub2a5\ub3c4 6.5 \ubc84\uc804\uc5d0\uc11c \uac1c\ubc1c\uc790 \ud504\ub9ac\ubdf0\ub85c \uc81c\uacf5\ub420 \uc608\uc815\uc785\ub2c8\ub2e4.<\/p>\n<h4>\uc778\ub371\uc2a4 \uc5b4\ub4dc\ubc14\uc774\uc800(DP)<\/h4>\n<p>\uc774\uc81c \uc0ac\uc6a9\uc790\ub294 \uc778\ub371\uc2a4 \uc5b4\ub4dc\ubc14\uc774\uc800\ub97c \uc0ac\uc6a9\ud558\uc5ec \ucffc\ub9ac\uc5d0 \uac00\uc7a5 \uc801\ud569\ud55c \uc778\ub371\uc2a4\ub97c \ub9cc\ub4e4 \uc218 \uc788\uc2b5\ub2c8\ub2e4. \uad8c\uc7a5 \uc778\ub371\uc2a4\uc5d0\ub294 \ucee4\ubc84\ub9c1 \uc778\ub371\uc2a4 \uc139\uc158\ub3c4 \ud3ec\ud568\ub418\uc5b4 \uc788\uc2b5\ub2c8\ub2e4. \ucee4\ubc84\ub9c1 \uc778\ub371\uc2a4\ub97c \ud65c\uc6a9\ud558\ub294 \ucffc\ub9ac\ub294 \ucd94\uac00\uc801\uc778 \ub370\uc774\ud130 \uc11c\ube44\uc2a4 \uac00\uc838\uc624\uae30\ub97c \uc218\ud589\ud558\uc9c0 \uc54a\uc544\ub3c4 \ub418\ubbc0\ub85c \uc804\ubc18\uc801\uc778 \ucffc\ub9ac \uc131\ub2a5\uc744 \ud5a5\uc0c1\uc2dc\ud0ac \uc218 \uc788\uc2b5\ub2c8\ub2e4. \uc778\ub371\uc2a4 \uc5b4\ub4dc\ubc14\uc774\uc800\ub294 \ud2b9\uc815 \ucffc\ub9ac \ub610\ub294 \uc644\ub8cc\ub41c \uc694\uccad \uc6cc\ud06c\ub85c\ub4dc\uc5d0 \ub300\ud574 \uc791\ub3d9\ud569\ub2c8\ub2e4.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone wp-image-7131\" src=\"https:\/\/www.couchbase.com\/blog\/wp-content\/uploads\/2019\/06\/Screen-Shot-2019-04-24-at-1.26.42-PM-Mod.png\" alt=\"\" width=\"1079\" height=\"589\" srcset=\"https:\/\/www.couchbase.com\/blog\/wp-content\/uploads\/sites\/1\/2019\/06\/Screen-Shot-2019-04-24-at-1.26.42-PM-Mod.png 1279w, https:\/\/www.couchbase.com\/blog\/wp-content\/uploads\/sites\/1\/2019\/06\/Screen-Shot-2019-04-24-at-1.26.42-PM-Mod-300x164.png 300w, https:\/\/www.couchbase.com\/blog\/wp-content\/uploads\/sites\/1\/2019\/06\/Screen-Shot-2019-04-24-at-1.26.42-PM-Mod-1024x559.png 1024w, https:\/\/www.couchbase.com\/blog\/wp-content\/uploads\/sites\/1\/2019\/06\/Screen-Shot-2019-04-24-at-1.26.42-PM-Mod-768x419.png 768w, https:\/\/www.couchbase.com\/blog\/wp-content\/uploads\/sites\/1\/2019\/06\/Screen-Shot-2019-04-24-at-1.26.42-PM-Mod-20x11.png 20w\" sizes=\"auto, (max-width: 1079px) 100vw, 1079px\" \/><\/p>\n<h4>Couchbase v6.5\uc758 \uae30\ud0c0 N1QL \uac1c\uc120 \uc0ac\ud56d<\/h4>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone wp-image-7126\" src=\"https:\/\/www.couchbase.com\/blog\/wp-content\/uploads\/2019\/06\/Screen-Shot-2019-06-19-at-1.21.31-PM.png\" alt=\"\" width=\"916\" height=\"599\" srcset=\"https:\/\/www.couchbase.com\/blog\/wp-content\/uploads\/sites\/1\/2019\/06\/Screen-Shot-2019-06-19-at-1.21.31-PM.png 1572w, https:\/\/www.couchbase.com\/blog\/wp-content\/uploads\/sites\/1\/2019\/06\/Screen-Shot-2019-06-19-at-1.21.31-PM-300x196.png 300w, https:\/\/www.couchbase.com\/blog\/wp-content\/uploads\/sites\/1\/2019\/06\/Screen-Shot-2019-06-19-at-1.21.31-PM-1024x670.png 1024w, https:\/\/www.couchbase.com\/blog\/wp-content\/uploads\/sites\/1\/2019\/06\/Screen-Shot-2019-06-19-at-1.21.31-PM-768x502.png 768w, https:\/\/www.couchbase.com\/blog\/wp-content\/uploads\/sites\/1\/2019\/06\/Screen-Shot-2019-06-19-at-1.21.31-PM-1536x1004.png 1536w, https:\/\/www.couchbase.com\/blog\/wp-content\/uploads\/sites\/1\/2019\/06\/Screen-Shot-2019-06-19-at-1.21.31-PM-20x13.png 20w, https:\/\/www.couchbase.com\/blog\/wp-content\/uploads\/sites\/1\/2019\/06\/Screen-Shot-2019-06-19-at-1.21.31-PM-1320x863.png 1320w\" sizes=\"auto, (max-width: 916px) 100vw, 916px\" \/><\/p>\n<h4>\uc694\uc57d<\/h4>\n<p>Couchbase v6.5\uc758 \uc0c8\ub85c\uc6b4 N1QL \ucf58\ud150\uce20\ub294 \uace0\uac1d\ub4e4\uc774 \uc694\uccad\ud574 \uc628 \ub9ce\uc740 \uc694\uccad\uc744 \ud574\uacb0\ud560 \uc218 \uc788\ub294 \uae30\ub2a5\ub4e4\uc774\uae30 \ub54c\ubb38\uc5d0 \ub9e4\uc6b0 \uae30\ub300\uac00 \ub429\ub2c8\ub2e4. \uc5b8\uc81c\ub098 \uadf8\ub807\ub4ef\uc774 \uc0c8\ub85c\uc6b4 \uae30\ub2a5, \ud2b9\ud788 \uc778\ub371\uc2a4 \uc5b4\ub4dc\ubc14\uc774\uc800(DP)\uc5d0 \ub300\ud55c \ud53c\ub4dc\ubc31\uc5d0 \uadc0\ub97c \uae30\uc6b8\uc774\uace0 \uc788\uc2b5\ub2c8\ub2e4.<\/p>\n<p>&nbsp;<\/p>\n<h4><b>\ub9ac\uc18c\uc2a4<\/b><\/h4>\n<ul>\n<li><i>\ub2e4\uc6b4\ub85c\ub4dc<\/i>:\u00a0<a href=\"https:\/\/www.couchbase.com\/blog\/ko\/downloads\/?family=server&amp;product=couchbase-server-developer\">Couchbase Server 6.5 \ub2e4\uc6b4\ub85c\ub4dc<\/a><i><\/i><\/li>\n<li><i>\ubb38\uc11c<\/i>:\u00a0<a href=\"https:\/\/docs.couchbase.com\/server\/6.5\/introduction\/whats-new.html\">\uce74\uc6b0\uce58\ubca0\uc774\uc2a4 \uc11c\ubc84 6.5\uc758 \uc0c8\ub85c\uc6b4 \uae30\ub2a5<\/a><i><\/i><\/li>\n<li><a href=\"https:\/\/www.couchbase.com\/blog\/ko\/tag\/6-5\/\"><b>6.5 \ube14\ub85c\uadf8 \ubaa8\ub450 \ubcf4\uae30<\/b><\/a><\/li>\n<\/ul>\n<p>6.5\uc758 \uae30\ub2a5\uc774 \ub9c8\uc74c\uc5d0 \ub4dc\uc168\ub294\uc9c0, \uc55e\uc73c\ub85c \ube44\uc988\ub2c8\uc2a4\uc5d0 \uc5b4\ub5a4 \ub3c4\uc6c0\uc774 \ub420\uc9c0 \uc5ec\ub7ec\ubd84\uc758 \uc758\uacac\uc744 \ub4e3\uace0 \uc2f6\uc2b5\ub2c8\ub2e4. \ub313\uae00\uc744 \ud1b5\ud574 \uc758\uacac\uc744 \uacf5\uc720\ud574 \uc8fc\uc2dc\uac70\ub098\u00a0<a href=\"https:\/\/www.couchbase.com\/blog\/ko\/forums\/\">\ud3ec\ub7fc<\/a>.<\/p>","protected":false},"excerpt":{"rendered":"<p>Couchbase 6.5 release is one of the largest release content wise for Couchbase. For N1QL Query service, the focus for us is to bring Enterprise Database functionalities to the Couchbase Database. Expanding N1QL with additional functions to support Enterprise Application [&hellip;]<\/p>","protected":false},"author":26326,"featured_media":7125,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_acf_changed":false,"inline_featured_image":false,"footnotes":""},"categories":[1816,1812],"tags":[2378],"ppma_author":[8919],"class_list":["post-7120","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-couchbase-server","category-n1ql-query","tag-6-5"],"acf":[],"yoast_head":"<!-- This site is optimized with the Yoast SEO Premium plugin v25.8 (Yoast SEO v25.8) - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>A Preview of Couchbase 6.5 N1QL Features - The Couchbase Blog<\/title>\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\/a-preview-of-couchbase-6-5-n1ql-features\/\" \/>\n<meta property=\"og:locale\" content=\"ko_KR\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"A Preview of Couchbase 6.5 N1QL Features\" \/>\n<meta property=\"og:description\" content=\"Couchbase 6.5 release is one of the largest release content wise for Couchbase. For N1QL Query service, the focus for us is to bring Enterprise Database functionalities to the Couchbase Database. Expanding N1QL with additional functions to support Enterprise Application [&hellip;]\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.couchbase.com\/blog\/ko\/a-preview-of-couchbase-6-5-n1ql-features\/\" \/>\n<meta property=\"og:site_name\" content=\"The Couchbase Blog\" \/>\n<meta property=\"article:published_time\" content=\"2019-06-22T17:42:41+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2025-06-14T00:22:02+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/www.couchbase.com\/blog\/wp-content\/uploads\/sites\/1\/2019\/06\/Screen-Shot-2019-06-19-at-1.16.56-PM.png\" \/>\n\t<meta property=\"og:image:width\" content=\"697\" \/>\n\t<meta property=\"og:image:height\" content=\"411\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/png\" \/>\n<meta name=\"author\" content=\"Binh Le\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"Binh Le\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"4\ubd84\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\/\/www.couchbase.com\/blog\/a-preview-of-couchbase-6-5-n1ql-features\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/www.couchbase.com\/blog\/a-preview-of-couchbase-6-5-n1ql-features\/\"},\"author\":{\"name\":\"Binh Le\",\"@id\":\"https:\/\/www.couchbase.com\/blog\/#\/schema\/person\/f89064928e262c71eb43bee996c48c63\"},\"headline\":\"A Preview of Couchbase 6.5 N1QL Features\",\"datePublished\":\"2019-06-22T17:42:41+00:00\",\"dateModified\":\"2025-06-14T00:22:02+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/www.couchbase.com\/blog\/a-preview-of-couchbase-6-5-n1ql-features\/\"},\"wordCount\":477,\"commentCount\":0,\"publisher\":{\"@id\":\"https:\/\/www.couchbase.com\/blog\/#organization\"},\"image\":{\"@id\":\"https:\/\/www.couchbase.com\/blog\/a-preview-of-couchbase-6-5-n1ql-features\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/www.couchbase.com\/blog\/wp-content\/uploads\/sites\/1\/2019\/06\/Screen-Shot-2019-06-19-at-1.16.56-PM.png\",\"keywords\":[\"6.5\"],\"articleSection\":[\"Couchbase Server\",\"SQL++ \/ N1QL Query\"],\"inLanguage\":\"ko-KR\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\/\/www.couchbase.com\/blog\/a-preview-of-couchbase-6-5-n1ql-features\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/www.couchbase.com\/blog\/a-preview-of-couchbase-6-5-n1ql-features\/\",\"url\":\"https:\/\/www.couchbase.com\/blog\/a-preview-of-couchbase-6-5-n1ql-features\/\",\"name\":\"A Preview of Couchbase 6.5 N1QL Features - The Couchbase Blog\",\"isPartOf\":{\"@id\":\"https:\/\/www.couchbase.com\/blog\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/www.couchbase.com\/blog\/a-preview-of-couchbase-6-5-n1ql-features\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/www.couchbase.com\/blog\/a-preview-of-couchbase-6-5-n1ql-features\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/www.couchbase.com\/blog\/wp-content\/uploads\/sites\/1\/2019\/06\/Screen-Shot-2019-06-19-at-1.16.56-PM.png\",\"datePublished\":\"2019-06-22T17:42:41+00:00\",\"dateModified\":\"2025-06-14T00:22:02+00:00\",\"breadcrumb\":{\"@id\":\"https:\/\/www.couchbase.com\/blog\/a-preview-of-couchbase-6-5-n1ql-features\/#breadcrumb\"},\"inLanguage\":\"ko-KR\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/www.couchbase.com\/blog\/a-preview-of-couchbase-6-5-n1ql-features\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"ko-KR\",\"@id\":\"https:\/\/www.couchbase.com\/blog\/a-preview-of-couchbase-6-5-n1ql-features\/#primaryimage\",\"url\":\"https:\/\/www.couchbase.com\/blog\/wp-content\/uploads\/sites\/1\/2019\/06\/Screen-Shot-2019-06-19-at-1.16.56-PM.png\",\"contentUrl\":\"https:\/\/www.couchbase.com\/blog\/wp-content\/uploads\/sites\/1\/2019\/06\/Screen-Shot-2019-06-19-at-1.16.56-PM.png\",\"width\":697,\"height\":411},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/www.couchbase.com\/blog\/a-preview-of-couchbase-6-5-n1ql-features\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/www.couchbase.com\/blog\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"A Preview of Couchbase 6.5 N1QL Features\"}]},{\"@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\/f89064928e262c71eb43bee996c48c63\",\"name\":\"Binh Le\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"ko-KR\",\"@id\":\"https:\/\/www.couchbase.com\/blog\/#\/schema\/person\/image\/5b68c37e30928a9d7b2c8470b1a303b7\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/a939f48df6447844a8780bec264bb3be21d589336f3915fabc557075a68fa374?s=96&d=mm&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/a939f48df6447844a8780bec264bb3be21d589336f3915fabc557075a68fa374?s=96&d=mm&r=g\",\"caption\":\"Binh Le\"},\"description\":\"Binh Le is a Principal Product Manager for Couchbase Query service. Prior to Couchbase, he worked at Oracle and led the product management team for Sales Cloud Analytics and CRM OnDemand. Binh holds a Bachelor's Degree in Computer Science from the University of Brighton, UK.\",\"url\":\"https:\/\/www.couchbase.com\/blog\/ko\/author\/binh-le-2\/\"}]}<\/script>\n<!-- \/ Yoast SEO Premium plugin. -->","yoast_head_json":{"title":"A Preview of Couchbase 6.5 N1QL Features - The Couchbase Blog","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\/a-preview-of-couchbase-6-5-n1ql-features\/","og_locale":"ko_KR","og_type":"article","og_title":"A Preview of Couchbase 6.5 N1QL Features","og_description":"Couchbase 6.5 release is one of the largest release content wise for Couchbase. For N1QL Query service, the focus for us is to bring Enterprise Database functionalities to the Couchbase Database. Expanding N1QL with additional functions to support Enterprise Application [&hellip;]","og_url":"https:\/\/www.couchbase.com\/blog\/ko\/a-preview-of-couchbase-6-5-n1ql-features\/","og_site_name":"The Couchbase Blog","article_published_time":"2019-06-22T17:42:41+00:00","article_modified_time":"2025-06-14T00:22:02+00:00","og_image":[{"width":697,"height":411,"url":"https:\/\/www.couchbase.com\/blog\/wp-content\/uploads\/sites\/1\/2019\/06\/Screen-Shot-2019-06-19-at-1.16.56-PM.png","type":"image\/png"}],"author":"Binh Le","twitter_card":"summary_large_image","twitter_misc":{"Written by":"Binh Le","Est. reading time":"4\ubd84"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/www.couchbase.com\/blog\/a-preview-of-couchbase-6-5-n1ql-features\/#article","isPartOf":{"@id":"https:\/\/www.couchbase.com\/blog\/a-preview-of-couchbase-6-5-n1ql-features\/"},"author":{"name":"Binh Le","@id":"https:\/\/www.couchbase.com\/blog\/#\/schema\/person\/f89064928e262c71eb43bee996c48c63"},"headline":"A Preview of Couchbase 6.5 N1QL Features","datePublished":"2019-06-22T17:42:41+00:00","dateModified":"2025-06-14T00:22:02+00:00","mainEntityOfPage":{"@id":"https:\/\/www.couchbase.com\/blog\/a-preview-of-couchbase-6-5-n1ql-features\/"},"wordCount":477,"commentCount":0,"publisher":{"@id":"https:\/\/www.couchbase.com\/blog\/#organization"},"image":{"@id":"https:\/\/www.couchbase.com\/blog\/a-preview-of-couchbase-6-5-n1ql-features\/#primaryimage"},"thumbnailUrl":"https:\/\/www.couchbase.com\/blog\/wp-content\/uploads\/sites\/1\/2019\/06\/Screen-Shot-2019-06-19-at-1.16.56-PM.png","keywords":["6.5"],"articleSection":["Couchbase Server","SQL++ \/ N1QL Query"],"inLanguage":"ko-KR","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/www.couchbase.com\/blog\/a-preview-of-couchbase-6-5-n1ql-features\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/www.couchbase.com\/blog\/a-preview-of-couchbase-6-5-n1ql-features\/","url":"https:\/\/www.couchbase.com\/blog\/a-preview-of-couchbase-6-5-n1ql-features\/","name":"A Preview of Couchbase 6.5 N1QL Features - The Couchbase Blog","isPartOf":{"@id":"https:\/\/www.couchbase.com\/blog\/#website"},"primaryImageOfPage":{"@id":"https:\/\/www.couchbase.com\/blog\/a-preview-of-couchbase-6-5-n1ql-features\/#primaryimage"},"image":{"@id":"https:\/\/www.couchbase.com\/blog\/a-preview-of-couchbase-6-5-n1ql-features\/#primaryimage"},"thumbnailUrl":"https:\/\/www.couchbase.com\/blog\/wp-content\/uploads\/sites\/1\/2019\/06\/Screen-Shot-2019-06-19-at-1.16.56-PM.png","datePublished":"2019-06-22T17:42:41+00:00","dateModified":"2025-06-14T00:22:02+00:00","breadcrumb":{"@id":"https:\/\/www.couchbase.com\/blog\/a-preview-of-couchbase-6-5-n1ql-features\/#breadcrumb"},"inLanguage":"ko-KR","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.couchbase.com\/blog\/a-preview-of-couchbase-6-5-n1ql-features\/"]}]},{"@type":"ImageObject","inLanguage":"ko-KR","@id":"https:\/\/www.couchbase.com\/blog\/a-preview-of-couchbase-6-5-n1ql-features\/#primaryimage","url":"https:\/\/www.couchbase.com\/blog\/wp-content\/uploads\/sites\/1\/2019\/06\/Screen-Shot-2019-06-19-at-1.16.56-PM.png","contentUrl":"https:\/\/www.couchbase.com\/blog\/wp-content\/uploads\/sites\/1\/2019\/06\/Screen-Shot-2019-06-19-at-1.16.56-PM.png","width":697,"height":411},{"@type":"BreadcrumbList","@id":"https:\/\/www.couchbase.com\/blog\/a-preview-of-couchbase-6-5-n1ql-features\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/www.couchbase.com\/blog\/"},{"@type":"ListItem","position":2,"name":"A Preview of Couchbase 6.5 N1QL Features"}]},{"@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\/f89064928e262c71eb43bee996c48c63","name":"Binh Le","image":{"@type":"ImageObject","inLanguage":"ko-KR","@id":"https:\/\/www.couchbase.com\/blog\/#\/schema\/person\/image\/5b68c37e30928a9d7b2c8470b1a303b7","url":"https:\/\/secure.gravatar.com\/avatar\/a939f48df6447844a8780bec264bb3be21d589336f3915fabc557075a68fa374?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/a939f48df6447844a8780bec264bb3be21d589336f3915fabc557075a68fa374?s=96&d=mm&r=g","caption":"Binh Le"},"description":"Binh Le is a Principal Product Manager for Couchbase Query service. Prior to Couchbase, he worked at Oracle and led the product management team for Sales Cloud Analytics and CRM OnDemand. Binh holds a Bachelor's Degree in Computer Science from the University of Brighton, UK.","url":"https:\/\/www.couchbase.com\/blog\/ko\/author\/binh-le-2\/"}]}},"authors":[{"term_id":8919,"user_id":26326,"is_guest":0,"slug":"binh-le-2","display_name":"Binh Le","avatar_url":"https:\/\/secure.gravatar.com\/avatar\/a939f48df6447844a8780bec264bb3be21d589336f3915fabc557075a68fa374?s=96&d=mm&r=g","author_category":"","last_name":"Le","first_name":"Binh","job_title":"","user_url":"","description":"Binh Le\ub294 Couchbase \ucffc\ub9ac \uc11c\ube44\uc2a4\uc758 \uc218\uc11d \uc81c\ud488 \uad00\ub9ac\uc790\uc785\ub2c8\ub2e4. Couchbase\uc5d0 \uc785\uc0ac\ud558\uae30 \uc804\uc5d0\ub294 Oracle\uc5d0\uc11c \uadfc\ubb34\ud558\uba70 Sales Cloud Analytics \ubc0f CRM OnDemand\uc758 \uc81c\ud488 \uad00\ub9ac \ud300\uc744 \uc774\ub04c\uc5c8\uc2b5\ub2c8\ub2e4. \uc601\uad6d \ube0c\ub77c\uc774\ud2bc \ub300\ud559\uad50\uc5d0\uc11c \ucef4\ud4e8\ud130 \uacf5\ud559 \ud559\uc0ac \ud559\uc704\ub97c \ubc1b\uc558\uc2b5\ub2c8\ub2e4."}],"_links":{"self":[{"href":"https:\/\/www.couchbase.com\/blog\/ko\/wp-json\/wp\/v2\/posts\/7120","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\/26326"}],"replies":[{"embeddable":true,"href":"https:\/\/www.couchbase.com\/blog\/ko\/wp-json\/wp\/v2\/comments?post=7120"}],"version-history":[{"count":0,"href":"https:\/\/www.couchbase.com\/blog\/ko\/wp-json\/wp\/v2\/posts\/7120\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.couchbase.com\/blog\/ko\/wp-json\/wp\/v2\/media\/7125"}],"wp:attachment":[{"href":"https:\/\/www.couchbase.com\/blog\/ko\/wp-json\/wp\/v2\/media?parent=7120"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.couchbase.com\/blog\/ko\/wp-json\/wp\/v2\/categories?post=7120"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.couchbase.com\/blog\/ko\/wp-json\/wp\/v2\/tags?post=7120"},{"taxonomy":"author","embeddable":true,"href":"https:\/\/www.couchbase.com\/blog\/ko\/wp-json\/wp\/v2\/ppma_author?post=7120"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}