{"id":8849,"date":"2020-07-07T07:00:08","date_gmt":"2020-07-07T14:00:08","guid":{"rendered":"https:\/\/www.couchbase.com\/blog\/?p=8849"},"modified":"2025-06-13T23:42:34","modified_gmt":"2025-06-14T06:42:34","slug":"first-class-sql-full-text-search-couchbase","status":"publish","type":"post","link":"https:\/\/www.couchbase.com\/blog\/ko\/first-class-sql-full-text-search-couchbase\/","title":{"rendered":"\uc804\uccb4 \ud14d\uc2a4\ud2b8 \uac80\uc0c9\uc744 \uc704\ud55c \ucd5c\uace0 \uc218\uc900\uc758 SQL"},"content":{"rendered":"<p>\uc2dc\uac04\uc774 \uc9c0\ub0a8\uc5d0 \ub530\ub77c \ub370\uc774\ud130\ubca0\uc774\uc2a4 \uc5c5\uacc4\ub294 \uc804\uccb4 \ud14d\uc2a4\ud2b8 \uac80\uc0c9\uacfc SQL\uc774 \ub3d9\uc804\uc758 \uc591\uba74\uc774\ub77c\ub294 \uc0ac\uc2e4\uc744 \uae68\ub2ec\uc558\uc2b5\ub2c8\ub2e4.  \ud14d\uc2a4\ud2b8 \uac80\uc0c9\uc5d0\ub294 \ucd94\uac00 \ucffc\ub9ac \ucc98\ub9ac\uac00 \ud544\uc694\ud558\uace0, \ucffc\ub9ac \ucc98\ub9ac\uc5d0\ub294 \ud14d\uc2a4\ud2b8 \ud328\ud134\uc744 \ud6a8\uc728\uc801\uc73c\ub85c \ud544\ud130\ub9c1\ud558\uae30 \uc704\ud55c \ud14d\uc2a4\ud2b8 \uac80\uc0c9\uc774 \ud544\uc694\ud569\ub2c8\ub2e4.   SQL \ub370\uc774\ud130\ubca0\uc774\uc2a4\ub294 \ub2e8\uc77c \ub178\ub4dc SMP \uc2dc\uc2a4\ud15c\uc6a9\uc774\uae34 \ud558\uc9c0\ub9cc \uadf8 \uc548\uc5d0 \uc804\uccb4 \ud14d\uc2a4\ud2b8 \uac80\uc0c9\uc744 \ucd94\uac00\ud588\uc2b5\ub2c8\ub2e4.<\/p>\n<ul>\n<li style=\"list-style-type: none\">\n<ul>\n<li>SQL Server \uc9c0\uc6d0 <a href=\"https:\/\/docs.microsoft.com\/en-us\/sql\/relational-databases\/search\/full-text-search?view=sql-server-ver15\">\ud14d\uc2a4\ud2b8 \uac80\uc0c9\uc744 \uc704\ud55c CONTAINS()<\/a><\/li>\n<li>\uc624\ub77c\ud074 \uc9c0\uc6d0 <a href=\"https:\/\/docs.oracle.com\/cd\/B28359_01\/text.111\/b28303\/query.htm#BABGAIHJ\">\ud14d\uc2a4\ud2b8 \uac80\uc0c9\uc744 \uc704\ud55c CONTAINS()<\/a><\/li>\n<li>MySQL\uc5d0 f<a href=\"https:\/\/dev.mysql.com\/doc\/refman\/8.0\/en\/fulltext-natural-language.html\">ull \ud14d\uc2a4\ud2b8 \uc9c0\uc6d0\u00a0<\/a><\/li>\n<li>PostgreSQL\uc5d0\ub294 \ub2e4\uc74c\uacfc \uac19\uc740 \uae30\ub2a5\uc774 \uc788\uc2b5\ub2c8\ub2e4. <a href=\"https:\/\/www.postgresql.org\/docs\/12\/functions-textsearch.html\">\uc9c0\uc6d0\ub418\ub294 \ud14d\uc2a4\ud2b8 \uac80\uc0c9<\/a> \ub97c \uc624\ub7ab\ub3d9\uc548 \uc0ac\uc6a9\ud574 \uc654\uc2b5\ub2c8\ub2e4.<\/li>\n<\/ul>\n<\/li>\n<\/ul>\n<p><span style=\"font-weight: 400\">Couchbase \uc804\uccb4 \ud14d\uc2a4\ud2b8 \uac80\uc0c9(FTS)\uc740 \ud06c\uac8c \uc138 \uac00\uc9c0 \ub3d9\uae30\ub85c \ub9cc\ub4e4\uc5b4\uc84c\uc2b5\ub2c8\ub2e4:<\/span><\/p>\n<ul>\n<li style=\"list-style-type: none\">\n<ul>\n<li style=\"font-weight: 400\"><span style=\"font-weight: 400\">\ubb38\uc11c \ub0b4 \uc5ec\ub7ec \ud544\ub4dc\uc5d0\uc11c \ud22c\uba85\ud558\uac8c \uac80\uc0c9\ud558\uae30<\/span><\/li>\n<li style=\"font-weight: 400\"><span style=\"font-weight: 400\">\uac12\uc744 \uc815\ud655\ud558\uac8c \uc77c\uce58\uc2dc\ud0a4\ub294 \uac83 \uc774\uc0c1\uc758 \uae30\ub2a5\uc744 \uc81c\uacf5\ud569\ub2c8\ub2e4. <\/span><a href=\"https:\/\/docs.couchbase.com\/server\/current\/fts\/fts-query-types.html\"><span style=\"font-weight: 400\">\uc5b8\uc5b4 \uae30\ubc18 \uc2a4\ud15c\ubc0d<\/span><\/a><span style=\"font-weight: 400\">, <a href=\"https:\/\/www.couchbase.com\/blog\/ko\/fuzzy-matching\/\">\ud37c\uc9c0 \ub9e4\uce6d<\/a>\ub4f1<\/span><\/li>\n<li style=\"font-weight: 400\"><span style=\"font-weight: 400\">\uad00\ub828\uc131\uc5d0 \uae30\ubc18\ud55c \uac80\uc0c9 \uacb0\uacfc \uc81c\uacf5<\/span><\/li>\n<\/ul>\n<\/li>\n<\/ul>\n<p><span style=\"font-weight: 400\">FTS\ub294 \ubc18\uc804\ub41c \uc778\ub371\uc2a4\uc640 \ud48d\ubd80\ud55c <\/span><a href=\"https:\/\/docs.couchbase.com\/server\/current\/fts\/fts-query-types.html\"><span style=\"font-weight: 400\">\ucffc\ub9ac \uc220\uc5b4<\/span><\/a><span style=\"font-weight: 400\">\uac04\ub2e8\ud55c \ub2e8\uc5b4 \uac80\uc0c9\ubd80\ud130 \ud328\ud134 \ub9e4\uce6d, \ubcf5\uc7a1\ud55c \ubc94\uc704 \uc220\uc5b4\uae4c\uc9c0 \ub2e4\uc591\ud55c \uac80\uc0c9\uc744 \uc9c0\uc6d0\ud569\ub2c8\ub2e4.    \uac80\uc0c9 \uc678\uc5d0\ub3c4 \ub2e4\uc74c\uc744 \ud1b5\ud55c \uc9d1\uacc4\ub97c \uc9c0\uc6d0\ud569\ub2c8\ub2e4. <\/span><a href=\"https:\/\/docs.couchbase.com\/server\/6.5\/fts\/fts-response-object-schema.html#search-facets\"><span style=\"font-weight: 400\">\uac80\uc0c9 \ud328\uc2ef<\/span><\/a><span style=\"font-weight: 400\">.<\/span><\/p>\n<p>NoSQL \uc138\uacc4\uc5d0\uc11c \ub8e8\uc52c\uc740 \ub110\ub9ac \uc0ac\uc6a9\ub418\ub294 \uac80\uc0c9 \uc778\ub371\uc2a4\uc774\uba70, \ub8e8\uc52c \uae30\ubc18\uc758 \uac80\uc0c9 \uc11c\ubc84\ub3c4 \ub9c8\ucc2c\uac00\uc9c0\uc785\ub2c8\ub2e4: <a href=\"https:\/\/lucene.apache.org\/solr\/\">Solr<\/a> \uadf8\ub9ac\uace0 <a href=\"https:\/\/elastic.co\">Elasticsearch<\/a>.  RDBMS \uc0ac\ucd0c\uc744 \ub530\ub77c\uac11\ub2c8\ub2e4, <a href=\"https:\/\/www.elastic.co\/\"><span style=\"font-weight: 400\">Elasticsearch<\/span><\/a><span style=\"font-weight: 400\">, <\/span><a href=\"https:\/\/opendistro.github.io\/for-elasticsearch\/\"><span style=\"font-weight: 400\">Elasticsearch\uc6a9 Opendistro<\/span><\/a><span style=\"font-weight: 400\"> \ubaa8\ub450 \uac80\uc0c9\uc5d0 SQL\uc744 \ucd94\uac00\ud588\uc2b5\ub2c8\ub2e4.  \uce74\uc6b0\uce58\ubca0\uc774\uc2a4\ub294 \uc804\uccb4 \ud14d\uc2a4\ud2b8 \uc11c\ube44\uc2a4\ub97c \ub3c4\uc785\ud588\uc2b5\ub2c8\ub2e4,\u00a0<a href=\"https:\/\/docs.couchbase.com\/server\/current\/fts\/full-text-intro.html\">FTS<\/a> \ub97c \ucd9c\uc2dc\ud588\uc73c\uba70, \ud6c4\uc18d \uc870\uce58\ub85c N1QL \ub0b4 \uac80\uc0c9\uc744 \uc9c0\uc6d0\ud558\uace0 \uc788\uc2b5\ub2c8\ub2e4.<\/span><\/p>\n<ul>\n<li style=\"list-style-type: none\">\n<ul>\n<li style=\"font-weight: 400\"><a href=\"https:\/\/www.couchbase.com\/blog\/ko\/introducing-fts-with-n1ql\/\"><span style=\"font-weight: 400\">N1QL\uc744 \uc0ac\uc6a9\ud55c FTS<\/span><\/a><\/li>\n<li style=\"font-weight: 400\"><a href=\"https:\/\/www.elastic.co\/what-is\/elasticsearch-sql\"><span style=\"font-weight: 400\">SQL\uc744 \uc0ac\uc6a9\ud55c Elasticsearch<\/span><\/a><\/li>\n<li style=\"font-weight: 400\"><a href=\"https:\/\/opendistro.github.io\/for-elasticsearch-docs\/docs\/sql\/\"><span style=\"font-weight: 400\">SQL\uc744 \uc0ac\uc6a9\ud55c Elasticsearch\uc6a9 Opendistro<\/span><\/a><\/li>\n<li style=\"font-weight: 400\"><span style=\"font-weight: 400\">\uadf8\ub9ac\uace0 \ucd5c\uadfc \uac80\uc0c9 \uc2dc\uc7a5\uc5d0 \uc9c4\uc785\ud55c \ubabd\uace0DB\ub294 \ub2e4\uc74c\uacfc \uac19\uc740 \uae30\ub2a5\uc744 \ucd94\uac00\ud588\uc2b5\ub2c8\ub2e4. <\/span><a href=\"https:\/\/docs.atlas.mongodb.com\/atlas-search\/\"><span style=\"font-weight: 400\">MQL\ub85c \uac80\uc0c9<\/span><\/a><span style=\"font-weight: 400\"> Atlas \uc11c\ube44\uc2a4\uc5d0\uc11c Lucene\uc744 \uc0ac\uc6a9\ud558\uace0 \uc788\uc2b5\ub2c8\ub2e4. <\/span><\/li>\n<\/ul>\n<\/li>\n<\/ul>\n<p><strong>\uc758 SQL \uad6c\ud604 <a href=\"https:\/\/www.elastic.co\/what-is\/elasticsearch-sql\">SQL\uc744 \uc0ac\uc6a9\ud55c Elasticsearch<\/a> \uadf8\ub9ac\uace0 <a href=\"https:\/\/docs.atlas.mongodb.com\/atlas-search\/\">MongoDB\uc758 MQL<\/a> \uc5d0\ub294 \uc5ec\ub7ec \uac00\uc9c0 \uc81c\ud55c \uc0ac\ud56d\uc774 \uc788\uc2b5\ub2c8\ub2e4.<\/strong><\/p>\n<p><span style=\"font-weight: 400\"><a href=\"https:\/\/www.elastic.co\/what-is\/elasticsearch-sql\">SQL\uc744 \uc0ac\uc6a9\ud55c Elasticsearch<\/a><\/span> \uc758 \uc81c\ud55c \uc0ac\ud56d\uc744 \uc5ec\uae30\uc5d0 \ub098\uc5f4\ud588\uc2b5\ub2c8\ub2e4:<\/p>\n<ul>\n<li style=\"list-style-type: none\">\n<ul>\n<li>\uc804\uccb4 \ubaa9\ub85d: <a href=\"https:\/\/www.elastic.co\/guide\/en\/elasticsearch\/reference\/current\/sql-limitations.html\">https:\/\/www.elastic.co\/guide\/en\/elasticsearch\/reference\/current\/sql-limitations.html<\/a><\/li>\n<li>\ub610\ud55c \uc774 \uc5b8\uc5b4\ub294 \ucd08\uae30 \uad6c\ud604\uc73c\ub85c \uc778\ud574 \ub2f9\uc5f0\ud788 \uc81c\ud55c\uc801\uc785\ub2c8\ub2e4.\n<ul>\n<li>\uc9d1\ud569 \uc791\uc5c5 \uc870\uc778 \ub4f1\uc744 \uc9c0\uc6d0\ud558\uc9c0 \uc54a\uc2b5\ub2c8\ub2e4.<\/li>\n<li>\ucc3d \uae30\ub2a5\uc774 \uc5c6\uc2b5\ub2c8\ub2e4.<\/li>\n<\/ul>\n<\/li>\n<\/ul>\n<\/li>\n<\/ul>\n<p><span style=\"font-weight: 400\"><a href=\"https:\/\/docs.atlas.mongodb.com\/atlas-search\/\">MongoDB\uc758 MQL\uc758<\/a> \uac80\uc0c9 \ud1b5\ud569\uc5d0\ub294 \uc5ec\ub7ec \uac00\uc9c0 \uc81c\ud55c \uc0ac\ud56d\uc774 \uc788\uc2b5\ub2c8\ub2e4.<\/span><\/p>\n<ul>\n<li style=\"list-style-type: none\">\n<ul>\n<li>Atlas \uac80\uc0c9 \uc11c\ube44\uc2a4\uc5d0\uc11c\ub9cc \uc0ac\uc6a9\ud560 \uc218 \uc788\uc73c\uba70 \uc628\ud504\ub808\ubbf8\uc2a4 \uc81c\ud488\uc5d0\uc11c\ub294 \uc0ac\uc6a9\ud560 \uc218 \uc5c6\uc2b5\ub2c8\ub2e4.<\/li>\n<li>\uac80\uc0c9\uc740 \uc9d1\uacc4() \ud30c\uc774\ud504\ub77c\uc778 \ub0b4\uc5d0\uc11c \uccab \ubc88\uc9f8 \uc791\uc5c5\ub9cc \ud560 \uc218 \uc788\uc2b5\ub2c8\ub2e4.<\/li>\n<li>\uc9d1\uacc4 \ud30c\uc774\ud504\ub77c\uc778(aggregate())\uc5d0\uc11c\ub9cc \uc0ac\uc6a9\ud560 \uc218 \uc788\uc73c\uba70 find(), insert(), update(), remove() \ubc0f \uae30\ud0c0 \ub2e4\ub978 \uc791\uc5c5\uc5d0\uc11c\ub294 \uc0ac\uc6a9\ud560 \uc218 \uc5c6\uc2b5\ub2c8\ub2e4.<\/li>\n<\/ul>\n<\/li>\n<\/ul>\n<p><span style=\"font-weight: 400\">aggregate() API\uc640\uc758 \ud1b5\ud569\uc5d0\ub294 \uba87 \uac00\uc9c0 \uc81c\ud55c \uc0ac\ud56d\uc774 \uc788\uc2b5\ub2c8\ub2e4: \uc628\ud504\ub808\ubbf8\uc2a4 \ub370\uc774\ud130\ubca0\uc774\uc2a4\uc5d0\uc11c\ub294 \uc0ac\uc6a9\ud560 \uc218 \uc5c6\ub294 \ud30c\uc774\ud504\ub77c\uc778\uc758 \uccab \ubc88\uc9f8 \uc791\uc5c5\ub9cc \uac00\ub2a5\ud569\ub2c8\ub2e4. <\/span>\uc774 \ubb38\uc11c\uc5d0\uc11c \uc124\uba85\ud558\ub294 \uae30\ub2a5\uc740 Couchbase 6.5 \uc774\uc0c1 \ubc84\uc804\uc5d0 \uc788\uc2b5\ub2c8\ub2e4.<\/p>\n<p>\ub2e4\uc74c\uc740 N1QL\uc758 \uc608\uc785\ub2c8\ub2e4:<\/p>\n<pre class=\"theme:familiar font-size:17 line-height:20 whitespace-before:2 whitespace-after:2 lang:mysql decode:true\">\uad6d\uac00\ub97c \uc120\ud0dd\ud569\ub2c8\ub2e4,\r\n               \ub3c4\uc2dc\r\n               name,\r\n               ROW_NUMBER() OVER(ORDER BY \uad6d\uac00 DESC, \ub3c4\uc2dc DESC) rownum\r\nFROM `travel-sample` AS t1\r\nWHERE t1.type = \"hotel\" AND SEARCH(t1.description, \"garden\")\r\n\uadf8\ub9ac\uace0 \ub9ac\ubdf0\uc758 \ubaa8\ub4e0 r\uc774 r.ratings.Service &gt; 3\uc744 \ub9cc\uc871\ud558\ub294 \uacbd\uc6b0 END;\r\n<\/pre>\n<p><span style=\"font-weight: 400\">\uc5ec\uae30\uc5d0\ub294 SEARCH() \uc678\uc5d0\ub3c4 \ub2e4\uc74c\uc774 \ud3ec\ud568\ub429\ub2c8\ub2e4:<\/span><\/p>\n<ul>\n<li style=\"font-weight: 400\"><span style=\"font-weight: 400\">\ubb38\uc11c\uc5d0\uc11c \ud544\ub4dc \ud22c\uc601: \uad6d\uac00, \ub3c4\uc2dc, \uc774\ub984<\/span><\/li>\n<li style=\"font-weight: 400\"><span style=\"font-weight: 400\">\ucc3d \ud568\uc218 ROW_NUMBER()\ub97c \ud1b5\ud55c \ud589 \ubc88\ud638 \uc0dd\uc131<\/span><\/li>\n<li style=\"font-weight: 400\"><span style=\"font-weight: 400\">\ucd94\uac00 \uc2a4\uce7c\ub77c \uc220\uc5b4 t1.type = \"hotel\"<\/span><\/li>\n<li style=\"font-weight: 400\"><span style=\"font-weight: 400\">\ub9ac\ubdf0\uc5d0 \ub300\ud55c \ubc30\uc5f4 \uc220\uc5b4(ANY)<\/span><\/li>\n<\/ul>\n<p><span style=\"font-weight: 400\">\ud6a8\uc728\uc801\uc778 \uac80\uc0c9\uacfc \ub354\ubd88\uc5b4 \ucd5c\uace0 \uc218\uc900\uc758 \ucffc\ub9ac \ucc98\ub9ac\uc758 \ubaa8\ub4e0 \uc774\uc810\uc744 \ub204\ub9b4 \uc218 \uc788\uc2b5\ub2c8\ub2e4.  \uc774\ubfd0\ub9cc\uc774 \uc544\ub2d9\ub2c8\ub2e4. N1QL\uc5d0\ub294 \ub354 \ub9ce\uc740 \uae30\ub2a5\uc774 \uc788\uc2b5\ub2c8\ub2e4. <\/span><span style=\"font-weight: 400\">\ud61c\ud0dd \ubc0f <\/span><a href=\"https:\/\/www.couchbase.com\/blog\/ko\/unreasonable-effectiveness-of-sql\/\"><span style=\"font-weight: 400\">SQL\uc758 \ud6a8\uacfc<\/span><\/a><span style=\"font-weight: 400\"> \ub294 \uc798 \uc54c\ub824\uc838 \uc788\uc2b5\ub2c8\ub2e4.  N1QL\uc740 JSON\uc6a9 SQL\uc785\ub2c8\ub2e4. N1QL\uc758 \ubaa9\ud45c\ub294 \uac1c\ubc1c\uc790\uc640 \uae30\uc5c5\uc5d0\uac8c JSON \ub370\uc774\ud130\ub97c \ucffc\ub9ac, \ubcc0\ud658 \ubc0f \uc870\uc791\ud560 \uc218 \uc788\ub294 \ud45c\ud604\ub825\uc774 \ud48d\ubd80\ud558\uace0 \uac15\ub825\ud558\uba70 \uc644\ubcbd\ud55c \uc5b8\uc5b4\ub97c \uc81c\uacf5\ud558\ub294 \uac83\uc785\ub2c8\ub2e4.<\/span><\/p>\n<p><span style=\"font-weight: 400\">\uc0ac\uc6a9\uc758 \uc774\uc810 <\/span><a href=\"https:\/\/docs.couchbase.com\/server\/current\/n1ql\/n1ql-language-reference\/index.html\"><span style=\"font-weight: 400\">N1QL<\/span><\/a><span style=\"font-weight: 400\"> \ub97c \uac80\uc0c9\ud558\uba74 \ub2e4\uc74c\uacfc \uac19\uc740 \uacb0\uacfc\ub97c \uc5bb\uc744 \uc218 \uc788\uc2b5\ub2c8\ub2e4:<\/span><\/p>\n<ol>\n<li style=\"font-weight: 400\"><span style=\"font-weight: 400\">\uc220\uc5b4:<\/span>\n<ul>\n<li style=\"font-weight: 400\"><span style=\"font-weight: 400\">FTS\ub294 \uad00\ub828\uc131 \uae30\ubc18 \uac80\uc0c9\uc5d0 \uc801\ud569\ud569\ub2c8\ub2e4. SQL\uc740 \ubcf5\ud569 \uc220\uc5b4, \ubc30\uc5f4 \uc220\uc5b4, \ucd94\uac00 \uc2a4\uce7c\ub77c \ub4f1 \ubcf5\uc7a1\ud55c \ucffc\ub9ac \ucc98\ub9ac\ub97c \ucc98\ub9ac\ud560 \ub54c \uc720\uc6a9\ud569\ub2c8\ub2e4.\u00a0<\/span><\/li>\n<\/ul>\n<\/li>\n<li style=\"font-weight: 400\"><a href=\"https:\/\/docs.couchbase.com\/server\/current\/n1ql\/n1ql-language-reference\/arithmetic.html\"><span style=\"font-weight: 400\">\uc5f0\uc0b0\uc790<\/span><\/a><span style=\"font-weight: 400\"> \uadf8\ub9ac\uace0 <\/span><a href=\"https:\/\/docs.couchbase.com\/server\/current\/n1ql\/n1ql-language-reference\/aggregatefun.html\"><span style=\"font-weight: 400\">\ud568\uc218<\/span><\/a><span style=\"font-weight: 400\">:<\/span>\n<ol>\n<li style=\"font-weight: 400\"><span style=\"font-weight: 400\">\uc220\uc5b4 \ucc98\ub9ac(\ud544\ud130 \ucc98\ub9ac)<\/span>\n<ol>\n<li style=\"font-weight: 400\"><span style=\"font-weight: 400\">\ucd94\uac00 \uc2a4\uce7c\ub77c \ubc0f \ubc30\uc5f4 \uc220\uc5b4<\/span><\/li>\n<li style=\"font-weight: 400\"><span style=\"font-weight: 400\">\uc220\uc5b4 \ub0b4\uc5d0\uc11c \uc2a4\uce7c\ub77c \ubc0f \ubc30\uc5f4 \ud568\uc218\ub3c4 \uc0ac\uc6a9\ud560 \uc218 \uc788\uc2b5\ub2c8\ub2e4.<\/span><\/li>\n<li style=\"font-weight: 400\"><span style=\"font-weight: 400\">\ud558\uc704 \ucffc\ub9ac<\/span>\n<ol>\n<li style=\"font-weight: 400\"><span style=\"font-weight: 400\">\uc5f0\uad00\ub41c \ud558\uc704 \ucffc\ub9ac<\/span><\/li>\n<li style=\"font-weight: 400\"><span style=\"font-weight: 400\">\uad00\ub828 \uc5c6\ub294 \ud558\uc704 \ucffc\ub9ac\u00a0<\/span><\/li>\n<\/ol>\n<\/li>\n<\/ol>\n<\/li>\n<li style=\"font-weight: 400\"><a href=\"https:\/\/docs.couchbase.com\/server\/current\/n1ql\/n1ql-language-reference\/aggregatefun.html\"><span style=\"font-weight: 400\">\uc9d1\uacc4<\/span><\/a><\/li>\n<li style=\"font-weight: 400\"><a href=\"https:\/\/docs.couchbase.com\/server\/current\/n1ql\/n1ql-language-reference\/windowfun.html\"><span style=\"font-weight: 400\">\ucc3d \uae30\ub2a5<\/span><\/a><\/li>\n<\/ol>\n<\/li>\n<li style=\"font-weight: 400\"><span style=\"font-weight: 400\">\uc870\uc778 \ucc98\ub9ac<\/span>\n<ol>\n<li style=\"font-weight: 400\"><span style=\"font-weight: 400\">N1QL\uc740 \ub0b4\ubd80 \uc870\uc778, \uc67c\ucabd \uc678\ubd80 \uc870\uc778, (\uc81c\ud55c\ub41c) \uc624\ub978\ucabd \uc678\ubd80 \uc870\uc778, \uc911\ucca9, \uc911\ucca9 \ud574\uc81c\ub97c \uc218\ud589\ud560 \uc218 \uc788\uc2b5\ub2c8\ub2e4.<\/span><\/li>\n<li style=\"font-weight: 400\"><span style=\"font-weight: 400\">\ubc84\ud0b7, \uceec\ub809\uc158 \ubc0f \ud558\uc704 \ucffc\ub9ac \uacb0\uacfc \uac04\uc5d0 \uc870\uc778\ud569\ub2c8\ub2e4.<\/span><\/li>\n<\/ol>\n<\/li>\n<li style=\"font-weight: 400\"><a href=\"https:\/\/docs.couchbase.com\/server\/current\/n1ql\/n1ql-language-reference\/union.html\"><span style=\"font-weight: 400\">SET \uc791\uc5c5<\/span><\/a>\n<ol>\n<li style=\"font-weight: 400\"><span style=\"font-weight: 400\">UNION<\/span><\/li>\n<li style=\"font-weight: 400\"><span style=\"font-weight: 400\">\ubaa8\ub450 \ud1b5\ud569<\/span><\/li>\n<li style=\"font-weight: 400\"><span style=\"font-weight: 400\">\uc608\uc678<\/span><\/li>\n<li style=\"font-weight: 400\"><span style=\"font-weight: 400\">\ubaa8\ub450 \uc81c\uc678<\/span><\/li>\n<li style=\"font-weight: 400\"><span style=\"font-weight: 400\">\uad50\ucc28<\/span><\/li>\n<li style=\"font-weight: 400\"><span style=\"font-weight: 400\">\ubaa8\ub450 \uad50\ucc28<\/span><\/li>\n<\/ol>\n<\/li>\n<li style=\"font-weight: 400\"><a href=\"https:\/\/docs.couchbase.com\/server\/6.5\/n1ql\/n1ql-language-reference\/with.html\"><span style=\"font-weight: 400\">CTE<\/span><\/a><span style=\"font-weight: 400\"> (\uacf5\ud1b5 \ud14c\uc774\ube14 \ud45c\ud604\uc2dd) \ubc0f <\/span><a href=\"https:\/\/docs.couchbase.com\/server\/current\/n1ql\/n1ql-language-reference\/let.html\"><span style=\"font-weight: 400\">LET \uc808<\/span><\/a><span style=\"font-weight: 400\"> \ucffc\ub9ac \uc791\uc131 \uac1c\uc120<\/span><\/li>\n<li style=\"font-weight: 400\"><span style=\"font-weight: 400\">SEARCH() \uc774\uc0c1<\/span>\n<ol>\n<li style=\"font-weight: 400\"><span style=\"font-weight: 400\">SELECT \uc678\uc5d0\ub3c4 INSERT, UPDATE, DELETE, MERGE \ubb38\uc758 WHERE \uc808\uc5d0 SEARCH() \uc220\uc5b4\ub97c \uc0ac\uc6a9\ud560 \uc218 \uc788\uc2b5\ub2c8\ub2e4.<\/span><\/li>\n<li style=\"font-weight: 400\"><span style=\"font-weight: 400\">\uc774\ub7ec\ud55c \ubb38\uc7a5\uc744 \uc900\ube44\ud558\uace0 \ubc18\ubcf5\uc801\uc774\uace0 \ud6a8\uc728\uc801\uc73c\ub85c \uc2e4\ud589\ud560 \uc218 \uc788\uc2b5\ub2c8\ub2e4.<\/span><\/li>\n<li style=\"font-weight: 400\"><span style=\"font-weight: 400\">\ubd80\uc5ec \ubc0f \ucde8\uc18c\ub97c \ud1b5\ud574 RBAC \uc5ed\ud560\uc744 \ud1b5\ud574 \uc77c\ubc18\uc801\uc778 \ubcf4\uc548\uc744 \ud655\ubcf4\ud560 \uc218 \uc788\uc2b5\ub2c8\ub2e4.<\/span><\/li>\n<\/ol>\n<\/li>\n<li style=\"font-weight: 400\"><span style=\"font-weight: 400\">\uac1c\ubc1c\uc790 \uc0dd\uc0b0\uc131: \uac1c\ubc1c\uc790\uac00 \uc774\ubbf8 \uc54c\uace0 \uc788\ub294 \uc5b8\uc5b4\uc778 SQL\ub85c \ucffc\ub9ac\ub97c \uc791\uc131\ud569\ub2c8\ub2e4.<\/span><\/li>\n<\/ol>\n<p>N1QL \uc5d4\uc9c4\uc774 \uc774\ub97c \uc5b4\ub5bb\uac8c \uc2e4\ud589\ud558\ub294\uc9c0 \uc0b4\ud3b4\ubd05\uc2dc\ub2e4.  Couchbase FTS \uc5d4\uc9c0\ub2c8\uc5b4\ub9c1\uc758 Abhinav Dangeti\ub294 \uc774\ubbf8 <a href=\"https:\/\/www.couchbase.com\/blog\/ko\/introducing-fts-with-n1ql\/\">\uc758\uc0ac \uacb0\uc815\uacfc \uc0ac\ub840\ub97c \uc790\uc138\ud788 \uc124\uba85\ud558\ub294 \ud6cc\ub96d\ud55c \ube14\ub85c\uadf8<\/a>.  \uc774 \ubb38\uc11c\uc5d0\uc11c\ub294 \uc704\uc5d0\uc11c \uc5b8\uae09\ud55c \uce74\ud14c\uace0\ub9ac\uc758 \ucd94\uac00 \uc608\uc2dc\ub97c \ud1b5\ud574 \uc774\ub97c \uc2dc\uac01\uc801\uc73c\ub85c \uc124\uba85\ud569\ub2c8\ub2e4.<\/p>\n<h5><strong>1.  \ucffc\ub9ac \uc2e4\ud589\uc744 \uc704\ud55c \uc544\ud0a4\ud14d\ucc98<\/strong><\/h5>\n<p>\uac80\uc0c9() \uc744 \uc0ac\uc6a9\ud558\ub294 \ucffc\ub9ac \uc2e4\ud589\uc5d0 \uc138 \uac00\uc9c0 \uc911\uc694\ud55c \ub2e8\uacc4\ub97c \ucd94\uac00\ud588\uc2b5\ub2c8\ub2e4:<\/p>\n<ol>\n<li>\uac80\uc0c9() \uc220\uc5b4\uac00 \ucffc\ub9ac\uc5d0 \uc874\uc7ac\ud558\ub294 \uacbd\uc6b0 \ud50c\ub798\ub108\ub294 FTS \uac80\uc0c9 \uc778\ub371\uc2a4\ub97c \uc720\ud6a8\ud55c \uc561\uc138\uc2a4 \uacbd\ub85c \uc911 \ud558\ub098\ub85c \uac04\uc8fc\ud569\ub2c8\ub2e4.\n<ul>\n<li>\uac80\uc0c9 \uc778\ub371\uc2a4\ub97c \uc120\ud0dd\ud558\uba74 \uac80\uc0c9 \uc220\uc5b4\ub97c FTS \uc778\ub371\uc2a4\uc5d0 \ubc00\uc5b4\ub123\uc5b4 \uacc4\ud68d\uc744 \uc0dd\uc131\ud569\ub2c8\ub2e4.<\/li>\n<\/ul>\n<\/li>\n<li>\uac80\uc0c9 \uc778\ub371\uc2a4\uac00 \uc120\ud0dd\ub418\uba74, \uc2e4\ud589\uc790\ub294 \uc778\ub371\uc2a4 \uc11c\ube44\uc2a4\uc5d0 \ub300\ud55c \uac80\uc0c9 \uc694\uccad \ub300\uc2e0 FTS \ub178\ub4dc \uc911 \ud558\ub098\uc5d0 \uac80\uc0c9 \uc694\uccad\uc744 \ubc1c\ud589\ud569\ub2c8\ub2e4.<\/li>\n<li>\uac80\uc0c9 \uacb0\uacfc\uac00 \ud655\uc815\ub418\uae30 \uc804\uc5d0 \ucffc\ub9ac \uc11c\ube44\uc2a4\ub294 \ub370\uc774\ud130\uc5d0 \ub300\ud55c \ubb38\uc11c\uc758 \uac80\uc0c9 \uc790\uaca9\uc744 \ub2e4\uc2dc \ud655\uc778\ud569\ub2c8\ub2e4.<\/li>\n<\/ol>\n<div id=\"attachment_8852\" style=\"width: 855px\" class=\"wp-caption aligncenter\"><a href=\"https:\/\/www.couchbase.com\/blog\/wp-content\/uploads\/2020\/07\/Screen-Shot-2020-07-01-at-7.02.40-PM.png\"><img loading=\"lazy\" decoding=\"async\" aria-describedby=\"caption-attachment-8852\" class=\"wp-image-8852\" src=\"https:\/\/www.couchbase.com\/blog\/wp-content\/uploads\/2020\/07\/Screen-Shot-2020-07-01-at-7.02.40-PM-300x164.png\" alt=\"N1QL query execution with FTS\" width=\"845\" height=\"462\" srcset=\"https:\/\/www.couchbase.com\/blog\/wp-content\/uploads\/sites\/1\/2020\/07\/Screen-Shot-2020-07-01-at-7.02.40-PM-300x164.png 300w, https:\/\/www.couchbase.com\/blog\/wp-content\/uploads\/sites\/1\/2020\/07\/Screen-Shot-2020-07-01-at-7.02.40-PM-1024x559.png 1024w, https:\/\/www.couchbase.com\/blog\/wp-content\/uploads\/sites\/1\/2020\/07\/Screen-Shot-2020-07-01-at-7.02.40-PM-768x420.png 768w, https:\/\/www.couchbase.com\/blog\/wp-content\/uploads\/sites\/1\/2020\/07\/Screen-Shot-2020-07-01-at-7.02.40-PM-1536x839.png 1536w, https:\/\/www.couchbase.com\/blog\/wp-content\/uploads\/sites\/1\/2020\/07\/Screen-Shot-2020-07-01-at-7.02.40-PM-2048x1119.png 2048w, https:\/\/www.couchbase.com\/blog\/wp-content\/uploads\/sites\/1\/2020\/07\/Screen-Shot-2020-07-01-at-7.02.40-PM-20x11.png 20w, https:\/\/www.couchbase.com\/blog\/wp-content\/uploads\/sites\/1\/2020\/07\/Screen-Shot-2020-07-01-at-7.02.40-PM-1320x721.png 1320w\" sizes=\"auto, (max-width: 845px) 100vw, 845px\" \/><\/a><p id=\"caption-attachment-8852\" class=\"wp-caption-text\">FTS\ub97c \uc0ac\uc6a9\ud55c N1QL \ucffc\ub9ac \uc2e4\ud589<\/p><\/div>\n<div id=\"attachment_8853\" style=\"width: 849px\" class=\"wp-caption aligncenter\"><a href=\"https:\/\/www.couchbase.com\/blog\/wp-content\/uploads\/2020\/07\/Screen-Shot-2020-07-01-at-7.11.26-PM.png\"><img loading=\"lazy\" decoding=\"async\" aria-describedby=\"caption-attachment-8853\" class=\"wp-image-8853\" src=\"https:\/\/www.couchbase.com\/blog\/wp-content\/uploads\/2020\/07\/Screen-Shot-2020-07-01-at-7.11.26-PM-300x127.png\" alt=\"Inside the Query Service\" width=\"839\" height=\"355\" srcset=\"https:\/\/www.couchbase.com\/blog\/wp-content\/uploads\/sites\/1\/2020\/07\/Screen-Shot-2020-07-01-at-7.11.26-PM-300x127.png 300w, https:\/\/www.couchbase.com\/blog\/wp-content\/uploads\/sites\/1\/2020\/07\/Screen-Shot-2020-07-01-at-7.11.26-PM-1024x433.png 1024w, https:\/\/www.couchbase.com\/blog\/wp-content\/uploads\/sites\/1\/2020\/07\/Screen-Shot-2020-07-01-at-7.11.26-PM-768x325.png 768w, https:\/\/www.couchbase.com\/blog\/wp-content\/uploads\/sites\/1\/2020\/07\/Screen-Shot-2020-07-01-at-7.11.26-PM-1536x649.png 1536w, https:\/\/www.couchbase.com\/blog\/wp-content\/uploads\/sites\/1\/2020\/07\/Screen-Shot-2020-07-01-at-7.11.26-PM-2048x865.png 2048w, https:\/\/www.couchbase.com\/blog\/wp-content\/uploads\/sites\/1\/2020\/07\/Screen-Shot-2020-07-01-at-7.11.26-PM-20x8.png 20w, https:\/\/www.couchbase.com\/blog\/wp-content\/uploads\/sites\/1\/2020\/07\/Screen-Shot-2020-07-01-at-7.11.26-PM-1320x558.png 1320w\" sizes=\"auto, (max-width: 839px) 100vw, 839px\" \/><\/a><p id=\"caption-attachment-8853\" class=\"wp-caption-text\">\ucffc\ub9ac \uc11c\ube44\uc2a4 \ub0b4\ubd80<\/p><\/div>\n<h5><\/h5>\n<h5><strong>2. \uc220\uc5b4 \ucc98\ub9ac<\/strong><\/h5>\n<p>\ub2e4\uc74c \ucffc\ub9ac\uc5d0\uc11c SEARCH() \uc220\uc5b4(predicate-2)\ub294 FTS \uac80\uc0c9 \uc694\uccad\uc73c\ub85c \ud478\uc2dc\ub429\ub2c8\ub2e4.  \ub2e4\ub978 \ubaa8\ub4e0 \uc220\uc5b4\ub294 \uc704\uc758 '\ucffc\ub9ac \uc11c\ube44\uc2a4 \ub0b4\ubd80' \uadf8\ub9bc\uc5d0 \ud45c\uc2dc\ub41c \uac83\ucc98\ub7fc \ucffc\ub9ac \uc5d4\uc9c4\uc774 \uac80\uc0c9 \ud6c4 '\ud544\ud130' \ub2e8\uacc4\uc5d0\uc11c \ucc98\ub9ac\ud569\ub2c8\ub2e4.  \uc5ec\uae30\uc5d0\ub294 \ud55c \uac00\uc9c0 \uc608\uc678\uac00 \uc788\uc2b5\ub2c8\ub2e4.  FTS \uc778\ub371\uc2a4\uac00 \ub2e4\uc74c\uacfc \uac19\uc740 \uc778\ub371\uc2a4\ub97c \uc0dd\uc131\ud55c \uacbd\uc6b0 <strong>JSON \uc720\ud615 \ud544\ub4dc(\uc778\ub371\uc2a4 \uc815\uc758 \ubb38\uc11c\uc758 doc_config.type_field)<\/strong>\u00a0\ub97c \uc815\uc758\ud558\uc5ec(\uc774 \uacbd\uc6b0 \uc720\ud615 = \"hotel\") \ubb38\uc11c\uc758 \ud558\uc704 \uc9d1\ud569\uc5d0 \uc778\ub371\uc2a4\ub97c \ub9cc\ub4e4\uba74 \uc778\ub371\uc2a4 \uc120\ud0dd\uacfc \uac80\uc0c9 \ud478\uc2dc\ub2e4\uc6b4 \ubaa8\ub450 \uc774 \uc220\uc5b4\ub97c \ud65c\uc6a9\ud569\ub2c8\ub2e4.  \uc774 \uacbd\uc6b0\uc5d0\ub3c4 \uc774 \uc220\uc5b4\ub294 \ubb38\uc11c \uac00\uc838\uc624\uae30 \ud6c4\uc5d0 \ub2e4\uc2dc \uc801\uc6a9\ub429\ub2c8\ub2e4.<\/p>\n<pre class=\"theme:familiar font-size:17 line-height:20 whitespace-before:2 whitespace-after:2 lang:mysql decode:true\">\uad6d\uac00\ub97c \uc120\ud0dd\ud569\ub2c8\ub2e4,\r\n               \ub3c4\uc2dc\r\n               name,\r\n               ROW_NUMBER() OVER(ORDER BY \uad6d\uac00 DESC, \ub3c4\uc2dc DESC) rownum\r\nFROM `travel-sample` AS t1\r\nWHERE\r\nt1.type = \"hotel\" \/* predicate-1 *\/.\r\nAND SEARCH(t1.description, \"garden\") \/* predicate-2 *\/\r\n\uadf8\ub9ac\uace0 \ub9ac\ubdf0\uc758 \ubaa8\ub4e0 r\uc774 r.ratings.Service &gt; 3\uc744 \ub9cc\uc871\ud55c\ub2e4\uba74 END; \/* predicate-2 *\/\r\n<\/pre>\n<h5><\/h5>\n<h5><strong>3. <a href=\"https:\/\/docs.couchbase.com\/server\/6.5\/n1ql\/n1ql-language-reference\/operators.html\">\uc6b4\uc601\uc790<\/a> \uadf8\ub9ac\uace0 <a href=\"https:\/\/docs.couchbase.com\/server\/6.5\/n1ql\/n1ql-language-reference\/functions.html\">\uae30\ub2a5<\/a><\/strong><\/h5>\n<p>\ub2e4\uc74c\uc740 \uc5f0\uc0b0\uc790\uc640 \ud568\uc218\ub97c \uc545\uc6a9\ud558\ub294 \ucffc\ub9ac\uc758 \uc608\uc785\ub2c8\ub2e4.<\/p>\n<pre class=\"theme:familiar font-size:17 line-height:20 whitespace-before:2 whitespace-after:2 lang:mysql decode:true\">SELECT LOWER(country), \/* \uc2a4\uce7c\ub77c \ud568\uc218 *\/.\r\n       city,\r\n       \uc131 || \" \" || firstname AS fullname \/* \ubb38\uc790\uc5f4 \uc5f0\uc0b0\uc790 *\/\r\n       ROW_NUMBER() OVER(ORDER BY \uad6d\uac00 DESC, \ub3c4\uc2dc DESC) rownum \/* \uc708\ub3c4\uc6b0 \ud568\uc218 *\/\r\nFROM `travel-sample` AS t1\r\nWHERE\r\nLOWER(t1.type) = \"hotel\" \/* \uc2a4\uce7c\ub77c \ud568\uc218 *\/ \ub97c \uc785\ub825\ud569\ub2c8\ub2e4.\r\nAND SEARCH(t1.description, \"garden\")\r\nAND ARRAY_CONTAINS(public_likes, \"Joe Black\") \/* \ubc30\uc5f4 \ud568\uc218 *\/\r\n<\/pre>\n<p>\uc774 \ucffc\ub9ac\uc5d0 \ub300\ud55c \ucffc\ub9ac \uacc4\ud68d\uc740 \ub2e4\uc74c\uacfc \uac19\uc2b5\ub2c8\ub2e4. IndexSearch\ub294 FTS \uac80\uc0c9 \uc694\uccad\uc744 \uc218\ud589\ud558\uba70 \uc774\ub294 \ucffc\ub9ac \uc2e4\ud589 \ud30c\uc774\ud504\ub77c\uc778\uc5d0 \uacc4\uce35\ud654\ub429\ub2c8\ub2e4.  \ub530\ub77c\uc11c \ucffc\ub9ac\ub294 N1QL\uc758 \ub2e4\ub978 \ubaa8\ub4e0 \uae30\ub2a5\uc758 \uc774\uc810\uc744 \uc5bb\uc2b5\ub2c8\ub2e4.  \uc774\uac83\uc740 \uc704 \uadf8\ub9bc\uc758 \ud30c\uc774\ud504\ub77c\uc778 \ub2e8\uacc4\ub97c \ubc18\uc601\ud569\ub2c8\ub2e4.<\/p>\n<div id=\"attachment_8856\" style=\"width: 1044px\" class=\"wp-caption aligncenter\"><a href=\"https:\/\/www.couchbase.com\/blog\/wp-content\/uploads\/2020\/07\/Screen-Shot-2020-07-02-at-12.18.16-PM.png\"><img loading=\"lazy\" decoding=\"async\" aria-describedby=\"caption-attachment-8856\" class=\"wp-image-8856\" src=\"https:\/\/www.couchbase.com\/blog\/wp-content\/uploads\/2020\/07\/Screen-Shot-2020-07-02-at-12.18.16-PM-300x190.png\" alt=\"Query plan with SEARCH()\" width=\"1034\" height=\"654\" srcset=\"https:\/\/www.couchbase.com\/blog\/wp-content\/uploads\/sites\/1\/2020\/07\/Screen-Shot-2020-07-02-at-12.18.16-PM-300x190.png 300w, https:\/\/www.couchbase.com\/blog\/wp-content\/uploads\/sites\/1\/2020\/07\/Screen-Shot-2020-07-02-at-12.18.16-PM-1024x647.png 1024w, https:\/\/www.couchbase.com\/blog\/wp-content\/uploads\/sites\/1\/2020\/07\/Screen-Shot-2020-07-02-at-12.18.16-PM-768x485.png 768w, https:\/\/www.couchbase.com\/blog\/wp-content\/uploads\/sites\/1\/2020\/07\/Screen-Shot-2020-07-02-at-12.18.16-PM-1536x970.png 1536w, https:\/\/www.couchbase.com\/blog\/wp-content\/uploads\/sites\/1\/2020\/07\/Screen-Shot-2020-07-02-at-12.18.16-PM-20x13.png 20w, https:\/\/www.couchbase.com\/blog\/wp-content\/uploads\/sites\/1\/2020\/07\/Screen-Shot-2020-07-02-at-12.18.16-PM-1320x834.png 1320w, https:\/\/www.couchbase.com\/blog\/wp-content\/uploads\/sites\/1\/2020\/07\/Screen-Shot-2020-07-02-at-12.18.16-PM.png 1722w\" sizes=\"auto, (max-width: 1034px) 100vw, 1034px\" \/><\/a><p id=\"caption-attachment-8856\" class=\"wp-caption-text\">SEARCH()\ub97c \uc0ac\uc6a9\ud55c \ucffc\ub9ac \uacc4\ud68d<\/p><\/div>\n<h5>4. \uc870\uc778 \ucc98\ub9ac<\/h5>\n<p>.SEARCH()\ub97c \uc870\uc778 \ucc98\ub9ac\uc758 \uc77c\ubd80\ub85c \uc0ac\uc6a9\ud560 \uc218\ub3c4 \uc788\uc2b5\ub2c8\ub2e4.  \uc774 \uacbd\uc6b0 FTS\ub294 \uc815\uc6d0\uc774 \uc788\ub294 \ud638\ud154\uc774 \uc788\ub294 \ubaa8\ub4e0 \ub3c4\uc2dc\ub97c \ucc3e\uc740 \ub2e4\uc74c \uacf5\ud56d\uacfc \uc870\uc778\ud558\ub294 \ub370 \uc0ac\uc6a9\ub429\ub2c8\ub2e4.<\/p>\n<pre class=\"theme:familiar font-size:17 line-height:20 whitespace-before:2 whitespace-after:2 lang:mysql decode:true\">SELECT hotel.name hname,\r\n       airport.city\r\nFROM `travel-sample` hotel\r\nLEFT OUTER JOIN `travel-sample` airport ON hotel.city = airport.city\r\nWHERE hotel.type = 'hotel'\r\n    AND SEARCH(hotel.description, \"garden\")\r\n    AND airport.type = 'airport' ;\r\n<\/pre>\n<p>&nbsp;<\/p>\n<p>&nbsp;<\/p>\n<div id=\"attachment_8857\" style=\"width: 777px\" class=\"wp-caption aligncenter\"><a href=\"https:\/\/www.couchbase.com\/blog\/wp-content\/uploads\/2020\/07\/Screen-Shot-2020-07-02-at-1.52.41-PM.png\"><img loading=\"lazy\" decoding=\"async\" aria-describedby=\"caption-attachment-8857\" class=\"wp-image-8857\" src=\"https:\/\/www.couchbase.com\/blog\/wp-content\/uploads\/2020\/07\/Screen-Shot-2020-07-02-at-1.52.41-PM-300x200.png\" alt=\"JOIN with SEARCH\" width=\"767\" height=\"511\" srcset=\"https:\/\/www.couchbase.com\/blog\/wp-content\/uploads\/sites\/1\/2020\/07\/Screen-Shot-2020-07-02-at-1.52.41-PM-300x200.png 300w, https:\/\/www.couchbase.com\/blog\/wp-content\/uploads\/sites\/1\/2020\/07\/Screen-Shot-2020-07-02-at-1.52.41-PM-1024x683.png 1024w, https:\/\/www.couchbase.com\/blog\/wp-content\/uploads\/sites\/1\/2020\/07\/Screen-Shot-2020-07-02-at-1.52.41-PM-768x512.png 768w, https:\/\/www.couchbase.com\/blog\/wp-content\/uploads\/sites\/1\/2020\/07\/Screen-Shot-2020-07-02-at-1.52.41-PM-1536x1024.png 1536w, https:\/\/www.couchbase.com\/blog\/wp-content\/uploads\/sites\/1\/2020\/07\/Screen-Shot-2020-07-02-at-1.52.41-PM-400x267.png 400w, https:\/\/www.couchbase.com\/blog\/wp-content\/uploads\/sites\/1\/2020\/07\/Screen-Shot-2020-07-02-at-1.52.41-PM-450x300.png 450w, https:\/\/www.couchbase.com\/blog\/wp-content\/uploads\/sites\/1\/2020\/07\/Screen-Shot-2020-07-02-at-1.52.41-PM-20x13.png 20w, https:\/\/www.couchbase.com\/blog\/wp-content\/uploads\/sites\/1\/2020\/07\/Screen-Shot-2020-07-02-at-1.52.41-PM-1320x880.png 1320w, https:\/\/www.couchbase.com\/blog\/wp-content\/uploads\/sites\/1\/2020\/07\/Screen-Shot-2020-07-02-at-1.52.41-PM.png 1764w\" sizes=\"auto, (max-width: 767px) 100vw, 767px\" \/><\/a><p id=\"caption-attachment-8857\" class=\"wp-caption-text\">\uac80\uc0c9\uc73c\ub85c \uac00\uc785\ud558\uae30<\/p><\/div>\n<h5>5. <a href=\"https:\/\/docs.couchbase.com\/server\/6.5\/n1ql\/n1ql-language-reference\/with.html\">\uacf5\ud1b5 \ud14c\uc774\ube14 \ud45c\ud604\uc2dd(CTE).<\/a><\/h5>\n<p>\ucffc\ub9ac \uc11c\ube44\uc2a4\uc758 N1QL\uc740 \ube44\uc7ac\uadc0\uc801 CTE\ub97c \uc9c0\uc6d0\ud569\ub2c8\ub2e4.   \uac01 \ud45c\ud604\uc2dd \ub0b4\uc5d0\uc11c SEARCH()\ub97c \uc0ac\uc6a9\ud560 \uc218 \uc788\uc2b5\ub2c8\ub2e4. \ud574\ub2f9 \ud45c\ud604\uc2dd\uc5d0\uc11c \ud30c\uc0dd\ub41c \ud14c\uc774\ube14(\ud638\ud154 \ubc0f \uacf5\ud56d)\uc774 \ucffc\ub9ac \ub0b4\uc5d0\uc11c \ud0a4 \uc2a4\ud398\uc774\uc2a4\ub85c \uc0ac\uc6a9\ub429\ub2c8\ub2e4.<\/p>\n<pre class=\"theme:familiar font-size:17 line-height:20 whitespace-before:2 whitespace-after:2 lang:mysql decode:true\">WITH \ud638\ud154 AS (\r\n    SELECT name,\r\n           city\r\n    FROM `travel-sample`\r\n    WHERE type = 'hotel'\r\n        AND search(description, \"garden\")),\r\nairport AS (\r\n    SELECT name,\r\n           city\r\n    FROM `travel-sample`\r\n    WHERE type = 'airport'\r\n        AND SEARCH(city, \"angeles\"))\r\nSELECT hotel.name hname,\r\n       airport.city\r\nFROM hotel\r\nINNER JOIN airport ON hotel.city = airport.city\r\nORDER BY airport.city,\r\n         hotel.name;\r\n<\/pre>\n<p><a href=\"https:\/\/www.couchbase.com\/blog\/wp-content\/uploads\/2020\/07\/Screen-Shot-2020-07-02-at-3.00.13-PM.png\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter wp-image-8858\" src=\"https:\/\/www.couchbase.com\/blog\/wp-content\/uploads\/2020\/07\/Screen-Shot-2020-07-02-at-3.00.13-PM-198x300.png\" alt=\"\" width=\"536\" height=\"812\" srcset=\"https:\/\/www.couchbase.com\/blog\/wp-content\/uploads\/sites\/1\/2020\/07\/Screen-Shot-2020-07-02-at-3.00.13-PM-198x300.png 198w, https:\/\/www.couchbase.com\/blog\/wp-content\/uploads\/sites\/1\/2020\/07\/Screen-Shot-2020-07-02-at-3.00.13-PM-300x454.png 300w, https:\/\/www.couchbase.com\/blog\/wp-content\/uploads\/sites\/1\/2020\/07\/Screen-Shot-2020-07-02-at-3.00.13-PM-13x20.png 13w, https:\/\/www.couchbase.com\/blog\/wp-content\/uploads\/sites\/1\/2020\/07\/Screen-Shot-2020-07-02-at-3.00.13-PM.png 518w\" sizes=\"auto, (max-width: 536px) 100vw, 536px\" \/><\/a><\/p>\n<h5><strong>5. \uc5c5\ub370\uc774\ud2b8\uc5d0\uc11c \uc0ac\uc6a9<\/strong><\/h5>\n<p>SEARCH()\ub294 \ub2e4\ub978 DML \ubb38 \ub0b4\uc5d0\uc11c \uc220\uc5b4\uac00 \ud5c8\uc6a9\ub418\ub294 \uacf3\uc774\uba74 \uc5b4\ub514\uc5d0\uc11c\ub098 \uc0ac\uc6a9\ud560 \uc218 \uc788\uc2b5\ub2c8\ub2e4.<\/p>\n<pre class=\"theme:familiar font-size:17 line-height:20 whitespace-before:2 whitespace-after:2 lang:mysql decode:true\">\/* \uc0bd\uc785... SELECT \ubb38\uc785\ub2c8\ub2e4. *\/\r\nINSERT INTO mybucket (KEY id, VALUES v)\r\n          SELECT meta().id id, v\r\n          FROM `travel-sample` v\r\n          WHERE SEARCH(v, \"+type:hotel +description:clean\");\r\n\r\n\/* DELETE \ubb38 *\/\r\nDELETE FROM `travel-sample` WHERE SEARCH(v, \"+type:hotel +description:clean\");\r\n\r\n\/* UPDATE \ubb38 *\/\r\nUPDATE `travel-sample` SET new_field = \"search n update!\" WHERE SEARCH(v, \"+type:hotel +description:clean\"); \r\n\r\n\r\n<\/pre>\n<h5>\uc608\uc81c\ub294 \uae38\uac8c \uc774\uc5b4\uc9c8 \uc218 \uc788\uc2b5\ub2c8\ub2e4.  \uc77c\ubc18\uc801\uc778 \uc0d8\ud50c \uc608\uc81c\ub97c \ubcf4\uc5ec\ub4dc\ub838\uc2b5\ub2c8\ub2e4. \ub2e4\uc591\ud55c SQL \ubb38(DML)\uc5d0\uc11c \uc774 \uc608\uc81c\ub97c \uc0ac\uc6a9\ud569\ub2c8\ub2e4.<\/h5>\n<h5><strong>\uacb0\ub860<\/strong>:<\/h5>\n<p>Couchbase FTS\ub294 \ud655\uc7a5 \uac00\ub2a5\ud55c \ubd84\uc0b0\ud615 \ud14d\uc2a4\ud2b8 \uac80\uc0c9 \uc5d4\uc9c4\uc744 \uc81c\uacf5\ud569\ub2c8\ub2e4.  \uc774\ub97c Couchbase \ucffc\ub9ac \uc11c\ube44\uc2a4\uc758 N1QL\uc5d0 \uc6d0\ud65c\ud558\uac8c \uacc4\uce35\ud654\ud558\uc5ec \ucffc\ub9ac\uc758 \ubaa8\ub4e0 \uae30\ub2a5\uc744 \uac80\uc0c9\uc758 \ubaa8\ub4e0 \uae30\ub2a5\uacfc \ud568\uaed8 \uc0ac\uc6a9\ud560 \uc218 \uc788\ub3c4\ub85d \ud588\uc2b5\ub2c8\ub2e4.   \ub354 \ub9ce\uc740 \ud601\uc2e0\uc774 \uc900\ube44 \uc911\uc785\ub2c8\ub2e4. \uacc4\uc18d \uc9c0\ucf1c\ubd10 \uc8fc\uc138\uc694!<\/p>","protected":false},"excerpt":{"rendered":"<p>Over time, the database industry has realized full-text search and SQL are two sides of the same coin.\u00a0 Text search needs further query processing, query processing needs text search to efficiently filter for text patterns.\u00a0 \u00a0The SQL databases have added [&hellip;]<\/p>","protected":false},"author":55,"featured_media":8850,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_acf_changed":false,"inline_featured_image":false,"footnotes":""},"categories":[1814,1815,1821,2165,1812],"tags":[1584,1292,1261],"ppma_author":[8929],"class_list":["post-8849","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-application-design","category-best-practices-and-tutorials","category-couchbase-architecture","category-full-text-search","category-n1ql-query","tag-bleve","tag-elasticsearch","tag-json"],"acf":[],"yoast_head":"<!-- This site is optimized with the Yoast SEO Premium plugin v25.7.1 (Yoast SEO v25.7) - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>FIRST CLASS SQL for FULL-TEXT SEARCH - 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\/first-class-sql-full-text-search-couchbase\/\" \/>\n<meta property=\"og:locale\" content=\"ko_KR\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"FIRST CLASS SQL for FULL-TEXT SEARCH\" \/>\n<meta property=\"og:description\" content=\"Over time, the database industry has realized full-text search and SQL are two sides of the same coin.\u00a0 Text search needs further query processing, query processing needs text search to efficiently filter for text patterns.\u00a0 \u00a0The SQL databases have added [&hellip;]\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.couchbase.com\/blog\/ko\/first-class-sql-full-text-search-couchbase\/\" \/>\n<meta property=\"og:site_name\" content=\"The Couchbase Blog\" \/>\n<meta property=\"article:published_time\" content=\"2020-07-07T14:00:08+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2025-06-14T06:42:34+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/www.couchbase.com\/blog\/wp-content\/uploads\/sites\/1\/2020\/07\/triangle1-e1593651195823.jpg\" \/>\n\t<meta property=\"og:image:width\" content=\"1300\" \/>\n\t<meta property=\"og:image:height\" content=\"1244\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/jpeg\" \/>\n<meta name=\"author\" content=\"Keshav Murthy\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:creator\" content=\"@rkeshavmurthy\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"Keshav Murthy\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"8\ubd84\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\/\/www.couchbase.com\/blog\/first-class-sql-full-text-search-couchbase\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/www.couchbase.com\/blog\/first-class-sql-full-text-search-couchbase\/\"},\"author\":{\"name\":\"Keshav Murthy\",\"@id\":\"https:\/\/www.couchbase.com\/blog\/#\/schema\/person\/c261644262bf98e146372fe647682636\"},\"headline\":\"FIRST CLASS SQL for FULL-TEXT SEARCH\",\"datePublished\":\"2020-07-07T14:00:08+00:00\",\"dateModified\":\"2025-06-14T06:42:34+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/www.couchbase.com\/blog\/first-class-sql-full-text-search-couchbase\/\"},\"wordCount\":1197,\"commentCount\":0,\"publisher\":{\"@id\":\"https:\/\/www.couchbase.com\/blog\/#organization\"},\"image\":{\"@id\":\"https:\/\/www.couchbase.com\/blog\/first-class-sql-full-text-search-couchbase\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/www.couchbase.com\/blog\/wp-content\/uploads\/sites\/1\/2020\/07\/triangle1-e1593651195823.jpg\",\"keywords\":[\"bleve\",\"elasticsearch\",\"JSON\"],\"articleSection\":[\"Application Design\",\"Best Practices and Tutorials\",\"Couchbase Architecture\",\"Full-Text Search\",\"SQL++ \/ N1QL Query\"],\"inLanguage\":\"ko-KR\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\/\/www.couchbase.com\/blog\/first-class-sql-full-text-search-couchbase\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/www.couchbase.com\/blog\/first-class-sql-full-text-search-couchbase\/\",\"url\":\"https:\/\/www.couchbase.com\/blog\/first-class-sql-full-text-search-couchbase\/\",\"name\":\"FIRST CLASS SQL for FULL-TEXT SEARCH - The Couchbase Blog\",\"isPartOf\":{\"@id\":\"https:\/\/www.couchbase.com\/blog\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/www.couchbase.com\/blog\/first-class-sql-full-text-search-couchbase\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/www.couchbase.com\/blog\/first-class-sql-full-text-search-couchbase\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/www.couchbase.com\/blog\/wp-content\/uploads\/sites\/1\/2020\/07\/triangle1-e1593651195823.jpg\",\"datePublished\":\"2020-07-07T14:00:08+00:00\",\"dateModified\":\"2025-06-14T06:42:34+00:00\",\"breadcrumb\":{\"@id\":\"https:\/\/www.couchbase.com\/blog\/first-class-sql-full-text-search-couchbase\/#breadcrumb\"},\"inLanguage\":\"ko-KR\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/www.couchbase.com\/blog\/first-class-sql-full-text-search-couchbase\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"ko-KR\",\"@id\":\"https:\/\/www.couchbase.com\/blog\/first-class-sql-full-text-search-couchbase\/#primaryimage\",\"url\":\"https:\/\/www.couchbase.com\/blog\/wp-content\/uploads\/sites\/1\/2020\/07\/triangle1-e1593651195823.jpg\",\"contentUrl\":\"https:\/\/www.couchbase.com\/blog\/wp-content\/uploads\/sites\/1\/2020\/07\/triangle1-e1593651195823.jpg\",\"width\":1300,\"height\":1244},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/www.couchbase.com\/blog\/first-class-sql-full-text-search-couchbase\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/www.couchbase.com\/blog\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"FIRST CLASS SQL for FULL-TEXT SEARCH\"}]},{\"@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\/c261644262bf98e146372fe647682636\",\"name\":\"Keshav Murthy\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"ko-KR\",\"@id\":\"https:\/\/www.couchbase.com\/blog\/#\/schema\/person\/image\/4e51d72fc07c662aa791316deafffac4\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/af74df754db27152971d0aed2f323ead5a1f9fe5afd0209af91e12e784451224?s=96&d=mm&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/af74df754db27152971d0aed2f323ead5a1f9fe5afd0209af91e12e784451224?s=96&d=mm&r=g\",\"caption\":\"Keshav Murthy\"},\"description\":\"Keshav Murthy is a Vice President at Couchbase R&amp;D. Previously, he was at MapR, IBM, Informix, Sybase, with more than 20 years of experience in database design &amp; development. He lead the SQL and NoSQL R&amp;D team at IBM Informix. He has received two President's Club awards at Couchbase, two Outstanding Technical Achievement Awards at IBM. Keshav has a bachelor's degree in Computer Science and Engineering from the University of Mysore, India, holds eleven US patents and has four US patents pending.\",\"sameAs\":[\"https:\/\/blog.planetnosql.com\/\",\"https:\/\/x.com\/rkeshavmurthy\"],\"url\":\"https:\/\/www.couchbase.com\/blog\/ko\/author\/keshav-murthy\/\"}]}<\/script>\n<!-- \/ Yoast SEO Premium plugin. -->","yoast_head_json":{"title":"FIRST CLASS SQL for FULL-TEXT SEARCH - 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\/first-class-sql-full-text-search-couchbase\/","og_locale":"ko_KR","og_type":"article","og_title":"FIRST CLASS SQL for FULL-TEXT SEARCH","og_description":"Over time, the database industry has realized full-text search and SQL are two sides of the same coin.\u00a0 Text search needs further query processing, query processing needs text search to efficiently filter for text patterns.\u00a0 \u00a0The SQL databases have added [&hellip;]","og_url":"https:\/\/www.couchbase.com\/blog\/ko\/first-class-sql-full-text-search-couchbase\/","og_site_name":"The Couchbase Blog","article_published_time":"2020-07-07T14:00:08+00:00","article_modified_time":"2025-06-14T06:42:34+00:00","og_image":[{"width":1300,"height":1244,"url":"https:\/\/www.couchbase.com\/blog\/wp-content\/uploads\/sites\/1\/2020\/07\/triangle1-e1593651195823.jpg","type":"image\/jpeg"}],"author":"Keshav Murthy","twitter_card":"summary_large_image","twitter_creator":"@rkeshavmurthy","twitter_misc":{"Written by":"Keshav Murthy","Est. reading time":"8\ubd84"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/www.couchbase.com\/blog\/first-class-sql-full-text-search-couchbase\/#article","isPartOf":{"@id":"https:\/\/www.couchbase.com\/blog\/first-class-sql-full-text-search-couchbase\/"},"author":{"name":"Keshav Murthy","@id":"https:\/\/www.couchbase.com\/blog\/#\/schema\/person\/c261644262bf98e146372fe647682636"},"headline":"FIRST CLASS SQL for FULL-TEXT SEARCH","datePublished":"2020-07-07T14:00:08+00:00","dateModified":"2025-06-14T06:42:34+00:00","mainEntityOfPage":{"@id":"https:\/\/www.couchbase.com\/blog\/first-class-sql-full-text-search-couchbase\/"},"wordCount":1197,"commentCount":0,"publisher":{"@id":"https:\/\/www.couchbase.com\/blog\/#organization"},"image":{"@id":"https:\/\/www.couchbase.com\/blog\/first-class-sql-full-text-search-couchbase\/#primaryimage"},"thumbnailUrl":"https:\/\/www.couchbase.com\/blog\/wp-content\/uploads\/sites\/1\/2020\/07\/triangle1-e1593651195823.jpg","keywords":["bleve","elasticsearch","JSON"],"articleSection":["Application Design","Best Practices and Tutorials","Couchbase Architecture","Full-Text Search","SQL++ \/ N1QL Query"],"inLanguage":"ko-KR","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/www.couchbase.com\/blog\/first-class-sql-full-text-search-couchbase\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/www.couchbase.com\/blog\/first-class-sql-full-text-search-couchbase\/","url":"https:\/\/www.couchbase.com\/blog\/first-class-sql-full-text-search-couchbase\/","name":"FIRST CLASS SQL for FULL-TEXT SEARCH - The Couchbase Blog","isPartOf":{"@id":"https:\/\/www.couchbase.com\/blog\/#website"},"primaryImageOfPage":{"@id":"https:\/\/www.couchbase.com\/blog\/first-class-sql-full-text-search-couchbase\/#primaryimage"},"image":{"@id":"https:\/\/www.couchbase.com\/blog\/first-class-sql-full-text-search-couchbase\/#primaryimage"},"thumbnailUrl":"https:\/\/www.couchbase.com\/blog\/wp-content\/uploads\/sites\/1\/2020\/07\/triangle1-e1593651195823.jpg","datePublished":"2020-07-07T14:00:08+00:00","dateModified":"2025-06-14T06:42:34+00:00","breadcrumb":{"@id":"https:\/\/www.couchbase.com\/blog\/first-class-sql-full-text-search-couchbase\/#breadcrumb"},"inLanguage":"ko-KR","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.couchbase.com\/blog\/first-class-sql-full-text-search-couchbase\/"]}]},{"@type":"ImageObject","inLanguage":"ko-KR","@id":"https:\/\/www.couchbase.com\/blog\/first-class-sql-full-text-search-couchbase\/#primaryimage","url":"https:\/\/www.couchbase.com\/blog\/wp-content\/uploads\/sites\/1\/2020\/07\/triangle1-e1593651195823.jpg","contentUrl":"https:\/\/www.couchbase.com\/blog\/wp-content\/uploads\/sites\/1\/2020\/07\/triangle1-e1593651195823.jpg","width":1300,"height":1244},{"@type":"BreadcrumbList","@id":"https:\/\/www.couchbase.com\/blog\/first-class-sql-full-text-search-couchbase\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/www.couchbase.com\/blog\/"},{"@type":"ListItem","position":2,"name":"FIRST CLASS SQL for FULL-TEXT SEARCH"}]},{"@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\/c261644262bf98e146372fe647682636","name":"\ucf00\uc0e4\ube0c \uba38\uc2dc","image":{"@type":"ImageObject","inLanguage":"ko-KR","@id":"https:\/\/www.couchbase.com\/blog\/#\/schema\/person\/image\/4e51d72fc07c662aa791316deafffac4","url":"https:\/\/secure.gravatar.com\/avatar\/af74df754db27152971d0aed2f323ead5a1f9fe5afd0209af91e12e784451224?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/af74df754db27152971d0aed2f323ead5a1f9fe5afd0209af91e12e784451224?s=96&d=mm&r=g","caption":"Keshav Murthy"},"description":"\ucf00\uc0e4\ube0c \uba38\uc2dc\ub294 Couchbase R&amp;D\uc758 \ubd80\uc0ac\uc7a5\uc785\ub2c8\ub2e4. \uc774\uc804\uc5d0\ub294 MapR, IBM, Informix, Sybase\uc5d0\uc11c \uadfc\ubb34\ud588\uc73c\uba70 \ub370\uc774\ud130\ubca0\uc774\uc2a4 \uc124\uacc4 \ubc0f \uac1c\ubc1c \ubd84\uc57c\uc5d0\uc11c 20\ub144 \uc774\uc0c1\uc758 \uacbd\ub825\uc744 \uc313\uc558\uc2b5\ub2c8\ub2e4. IBM Informix\uc5d0\uc11c SQL \ubc0f NoSQL R&amp;D \ud300\uc744 \uc774\ub04c\uc5c8\uc2b5\ub2c8\ub2e4. Couchbase\uc5d0\uc11c \ub450 \ucc28\ub840\uc758 President's Club \uc0c1\uc744, IBM\uc5d0\uc11c \ub450 \ucc28\ub840\uc758 Outstanding Technical Achievement Award\ub97c \uc218\uc0c1\ud588\uc2b5\ub2c8\ub2e4. \uc778\ub3c4 \ub9c8\uc774\uc18c\ub974 \ub300\ud559\uad50\uc5d0\uc11c \ucef4\ud4e8\ud130 \uacfc\ud559 \ubc0f \uacf5\ud559 \ud559\uc0ac \ud559\uc704\ub97c \ubc1b\uc558\uc73c\uba70, 11\uac1c\uc758 \ubbf8\uad6d \ud2b9\ud5c8\ub97c \ubcf4\uc720\ud558\uace0 \uc788\uace0 4\uac1c\uc758 \ubbf8\uad6d \ud2b9\ud5c8\ub97c \ucd9c\uc6d0 \uc911\uc785\ub2c8\ub2e4.","sameAs":["https:\/\/blog.planetnosql.com\/","https:\/\/x.com\/rkeshavmurthy"],"url":"https:\/\/www.couchbase.com\/blog\/ko\/author\/keshav-murthy\/"}]}},"authors":[{"term_id":8929,"user_id":55,"is_guest":0,"slug":"keshav-murthy","display_name":"Keshav Murthy","avatar_url":"https:\/\/secure.gravatar.com\/avatar\/af74df754db27152971d0aed2f323ead5a1f9fe5afd0209af91e12e784451224?s=96&d=mm&r=g","first_name":"Keshav","last_name":"Murthy","user_url":"https:\/\/blog.planetnosql.com\/","author_category":"","description":"\ucf00\uc0e4\ube0c \uba38\uc2dc\ub294 Couchbase R&amp;D\uc758 \ubd80\uc0ac\uc7a5\uc785\ub2c8\ub2e4. \uc774\uc804\uc5d0\ub294 MapR, IBM, Informix, Sybase\uc5d0\uc11c \uadfc\ubb34\ud588\uc73c\uba70 \ub370\uc774\ud130\ubca0\uc774\uc2a4 \uc124\uacc4 \ubc0f \uac1c\ubc1c \ubd84\uc57c\uc5d0\uc11c 20\ub144 \uc774\uc0c1\uc758 \uacbd\ub825\uc744 \uc313\uc558\uc2b5\ub2c8\ub2e4. IBM Informix\uc5d0\uc11c SQL \ubc0f NoSQL R&amp;D \ud300\uc744 \uc774\ub04c\uc5c8\uc2b5\ub2c8\ub2e4. Couchbase\uc5d0\uc11c \ub450 \ubc88\uc758 President's Club \uc0c1\uc744, IBM\uc5d0\uc11c \ub450 \ubc88\uc758 \uc6b0\uc218 \uae30\uc220 \uc5c5\uc801\uc0c1\uc744 \uc218\uc0c1\ud588\uc2b5\ub2c8\ub2e4. \uc778\ub3c4 \ub9c8\uc774\uc18c\ub974 \ub300\ud559\uad50\uc5d0\uc11c \ucef4\ud4e8\ud130 \uacfc\ud559 \ubc0f \uacf5\ud559 \ud559\uc0ac \ud559\uc704\ub97c \ubc1b\uc558\uc73c\uba70, 10\uac1c\uc758 \ubbf8\uad6d \ud2b9\ud5c8\ub97c \ubcf4\uc720\ud558\uace0 \uc788\uace0 3\uac1c\uc758 \ubbf8\uad6d \ud2b9\ud5c8\ub97c \ucd9c\uc6d0 \uc911\uc785\ub2c8\ub2e4."}],"_links":{"self":[{"href":"https:\/\/www.couchbase.com\/blog\/ko\/wp-json\/wp\/v2\/posts\/8849","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\/55"}],"replies":[{"embeddable":true,"href":"https:\/\/www.couchbase.com\/blog\/ko\/wp-json\/wp\/v2\/comments?post=8849"}],"version-history":[{"count":0,"href":"https:\/\/www.couchbase.com\/blog\/ko\/wp-json\/wp\/v2\/posts\/8849\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.couchbase.com\/blog\/ko\/wp-json\/wp\/v2\/media\/8850"}],"wp:attachment":[{"href":"https:\/\/www.couchbase.com\/blog\/ko\/wp-json\/wp\/v2\/media?parent=8849"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.couchbase.com\/blog\/ko\/wp-json\/wp\/v2\/categories?post=8849"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.couchbase.com\/blog\/ko\/wp-json\/wp\/v2\/tags?post=8849"},{"taxonomy":"author","embeddable":true,"href":"https:\/\/www.couchbase.com\/blog\/ko\/wp-json\/wp\/v2\/ppma_author?post=8849"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}