{"id":6565,"date":"2018-12-11T12:29:41","date_gmt":"2018-12-11T20:29:41","guid":{"rendered":"https:\/\/www.couchbase.com\/blog\/?p=6565"},"modified":"2025-06-13T23:42:59","modified_gmt":"2025-06-14T06:42:59","slug":"n1ql-and-search-how-to-leverage-fts-index-in-n1ql-query","status":"publish","type":"post","link":"https:\/\/www.couchbase.com\/blog\/ko\/n1ql-and-search-how-to-leverage-fts-index-in-n1ql-query\/","title":{"rendered":"N1QL \ubc0f \uac80\uc0c9: N1QL\uc5d0\uc11c \uc804\uccb4 \ud14d\uc2a4\ud2b8 \uac80\uc0c9(FTS) \uc778\ub371\uc2a4 \ud65c\uc6a9\ud558\uae30"},"content":{"rendered":"

Couchbase v6.5\uc5d0\uc11c\ub294 \uc774\uc81c \uc804\uccb4 \ud14d\uc2a4\ud2b8 \uac80\uc0c9\uc774 Couchbase N1QL \ucffc\ub9ac \uad6c\uc131\uc5d0 \ud1b5\ud569\ub418\uc5c8\uc2b5\ub2c8\ub2e4. \uc774\uc81c \uace0\uac1d\uc740 N1QL\uc5d0\uc11c \uc9c1\uc811 FTS \uc778\ub371\uc2a4\ub97c \ud65c\uc6a9\ud560 \uc218 \uc788\uc2b5\ub2c8\ub2e4. \uc774\ub97c \ud1b5\ud574 \uac1c\ubc1c\uc790\ub294 \ub2e8\uc77c API\ub85c N1QL\uc758 \uc815\ud655\ud55c \uc220\uc5b4 \uc77c\uce58\uc640 FTS\uc758 \uac15\ub825\ud55c \uac80\uc0c9\uc744 \uacb0\ud569\ud560 \uc218 \uc788\uc2b5\ub2c8\ub2e4.<\/p>\n

\uad00\uacc4\ud615 \ub370\uc774\ud130\ubca0\uc774\uc2a4\ub97c \uc0ac\uc6a9\ud558\ub294 \ub9ce\uc740 \uc560\ud50c\ub9ac\ucf00\uc774\uc158 \uac1c\ubc1c\uc790\uac00 \uc9c1\uba74\ud558\ub294 \ud55c \uac00\uc9c0 \uc9c0\uc18d\uc801\uc778 \uacfc\uc81c\ub294 \ucffc\ub9ac \uc131\ub2a5\uc785\ub2c8\ub2e4. \ucffc\ub9ac \uc131\ub2a5 \ubb38\uc81c\ub97c \ud574\uacb0\ud558\uae30 \uc704\ud574\uc11c\ub294 \ub354 \ud070 \ub370\uc774\ud130\ubca0\uc774\uc2a4 \uc11c\ubc84\ub098 \ub354 \ub098\uc740 \uc778\ub371\uc2a4\ub97c \ud655\ubcf4\ud558\ub294 \ub4f1 \uad00\uacc4\ud615 \ub370\uc774\ud130\ubca0\uc774\uc2a4\uac00 \uc81c\uacf5\ud558\ub294 \uae30\ub2a5\uc73c\ub85c \uc81c\ud55c\ub418\ub294 \uacbd\uc6b0\uac00 \ub9ce\uc2b5\ub2c8\ub2e4.<\/p>\n

Couchbase\ub97c \uc0ac\uc6a9\ud558\uba74 N1QL \ucffc\ub9ac \uc131\ub2a5\ub3c4 \uc720\uc0ac\ud55c \uad6c\uc131 \uc694\uc18c\uc5d0 \uc758\uc874\ud569\ub2c8\ub2e4. \uadf8\ub7ec\ub098 \uad00\uacc4\ud615 RDBMS\uc640 \ub2ec\ub9ac, \uc11c\ube44\uc2a4 \uaca9\ub9ac \uc544\ud0a4\ud14d\ucc98\uc758 Couchbase\ub294 \ucffc\ub9ac \ubc0f \uc778\ub371\uc2a4 \uc11c\ube44\uc2a4\ub97c \ubaa8\ub450 \ub3c5\ub9bd\uc801\uc73c\ub85c \ud655\uc7a5\ud560 \uc218 \uc788\ub2e4\ub294 \uac83\uc744 \uc758\ubbf8\ud569\ub2c8\ub2e4. \uc801\uc808\ud55c \ud06c\uae30 \uc870\uc815\uacfc \uc6a9\ub7c9 \uacc4\ud68d\uc744 \ud1b5\ud574 Couchbase\ub294 \ub2e4\uc74c\uacfc \uac19\uc774 \ub9e4\uc6b0 \ube60\ub978 \uc131\ub2a5\uc744 \uc81c\uacf5\ud560 \uc218 \uc788\uc2b5\ub2c8\ub2e4. \uc54c\ud1a0\ub85c\uc2a4 NoSQL \ubca4\uce58\ub9c8\ud06c<\/a> \ubcf4\uace0\uc11c.<\/p>\n

\ucffc\ub9ac \uc220\uc5b4\ub97c \ub118\uc5b4\uc11c - N1QL \ubc0f \uac80\uc0c9<\/h3>\n

\uace0\uac1d\uc740 \uc801\uc808\ud55c \uc778\ub371\uc2a4\ub97c \uc0ac\uc6a9\ud558\uc5ec \ucffc\ub9ac\uc5d0 \ub300\ud574 \ubc00\ub9ac\ucd08 \ub2e8\uc704\uc758 \uc751\ub2f5 \uc2dc\uac04\uc744 \ub2ec\uc131\ud560 \uc218 \uc788\uc2b5\ub2c8\ub2e4. \uadf8\ub7ec\ub098 Couchbase GSI \uc778\ub371\uc2a4\uc5d0\uc11c \uc0ac\uc6a9\ud558\ub294 \ucffc\ub9ac \uc220\uc5b4\ub97c \ubbf8\ub9ac \uc54c \uc218 \uc5c6\ub294 \uacbd\uc6b0\uac00 \uc788\uc2b5\ub2c8\ub2e4. \uc774\uc0c1\uc801\uc778 \uc194\ub8e8\uc158\uc740 \uc0ac\uc6a9 \uac00\ub2a5\ud55c \ucffc\ub9ac \uc220\uc5b4\uc758 \ubaa8\ub4e0 \uc870\ud569\uc5d0\uc11c \uc791\ub3d9\ud560 \uc218 \uc788\ub294 \uc778\ub371\uc2f1 \uc2dc\uc2a4\ud15c\uc744 \uac16\ucd94\ub294 \uac83\uc785\ub2c8\ub2e4.<\/p>\n

\uce74\uc6b0\uce58\ubca0\uc774\uc2a4 \uc801\uc751\ud615 \uc778\ub371\uc2f1\uc740 \uc774\ub7ec\ud55c \uc0ac\uc6a9 \uc0ac\ub840 \uc911 \ub9ce\uc740 \ubd80\ubd84\uc744 \ud574\uacb0\ud560 \uc218 \uc788\uc2b5\ub2c8\ub2e4. Couchbase \uc804\uccb4 \ud14d\uc2a4\ud2b8 \uac80\uc0c9\uc740 \ubd88\uaddc\uce59\ud55c \ud328\ud134 \uc0ac\uc6a9 \uc0ac\ub840\uc5d0 \ub300\ud55c \ub610 \ub2e4\ub978 \uc811\uadfc \ubc29\uc2dd\uc785\ub2c8\ub2e4. \ubb38\uc11c\uc758 \ubaa8\ub4e0 \ud544\ub4dc\uc5d0 \ub300\ud574 \ud14d\uc2a4\ud2b8 \ubc0f \ud37c\uc9c0 \uac80\uc0c9 \uae30\ub2a5\uc744 \uc81c\uacf5\ud569\ub2c8\ub2e4.<\/p>\n

\uc544\ub798\uc758 \ud65c\ub3d9 \uad00\ub9ac \ubb38\uc11c\ub97c \uc0b4\ud3b4\ubcf4\uaca0\uc2b5\ub2c8\ub2e4. \ud65c\ub3d9:<\/p>\n

    \n
  1. \ud56d\uc0c1 \uace0\uac1d(\uacc4\uc815) \uc18c\uc720<\/li>\n
  2. \uace0\uac1d \uc870\uc9c1\uc758 \uc5ec\ub7ec \uc5f0\ub77d\ucc98\ub97c \ubcf4\uc720\ud560 \uc218\ub3c4 \uc788\uc73c\uba70 \uc5ec\ub7ec \uc5f0\ub77d\ucc98 \ubc30\uc5f4\ub85c \ud45c\uc2dc\ub420 \uc218 \uc788\uc2b5\ub2c8\ub2e4.<\/li>\n
  3. \uc5ec\ub7ec \uc0ac\uc6a9\uc790\ub85c \ub300\ud45c\ub418\ub294 \uc5ec\ub7ec \ucc38\uac00\uc790\ub97c \ud3ec\ud568\ud560 \uc218 \uc788\uc2b5\ub2c8\ub2e4.<\/li>\n
  4. \uc57d\uc18d \ub610\ub294 \uc791\uc5c5 \uc720\ud615\uc77c \uc218 \uc788\uc73c\uba70, \ub458 \ub2e4 \uc81c\ubaa9, \uc2dc\uc791\uc77c, \ub9c8\uac10\uc77c \ub4f1\uacfc \uac19\uc740 \ud2b9\uc815 \ud574\ub2f9 \uc18d\uc131\uc774 \uc788\uc2b5\ub2c8\ub2e4.<\/li>\n
  5. \uc791\uc5c5 \uc720\ud615\uc758 \ud65c\ub3d9\uc5d0\ub294 \ud560 \uc77c \ubaa9\ub85d\uc758 \ubc30\uc5f4\uc774 \uc788\uc2b5\ub2c8\ub2e4.<\/li>\n<\/ol>\n

    \"sample \"sample<\/p>\n

    \uc0ac\uc6a9 \uc0ac\ub840<\/h3>\n

    \ucf5c\uc13c\ud130\uc758 \uc11c\ube44\uc2a4 \ub2f4\ub2f9\uc790\uc778 John\uc740 \uace0\uac1d\uacfc \ud1b5\ud654\ud558\ub294 \ub3d9\uc548 \ubaa8\ub4e0 \uace0\uac1d \ud65c\ub3d9\uc744 \uac80\uc0c9\ud574\uc57c \ud569\ub2c8\ub2e4. \uace0\uac1d\uc740 John\uc774 \uc560\ud50c\ub9ac\ucf00\uc774\uc158\uc744 \ucffc\ub9ac\ud558\uae30 \uc704\ud574 \uc544\ub798 \uac12 \uc911 \ud558\ub098 \ub610\ub294 \uc5ec\ub7ec \uac1c\ub97c \uc81c\uacf5\ud560 \uc218 \uc788\uc2b5\ub2c8\ub2e4:<\/p>\n

      \n
    1. \ud65c\ub3d9 \uc81c\ubaa9: \ucffc\ub9ac\ub294 \ud65c\ub3d9 \uc81c\ubaa9\uc758 \uc5b4\ub290 \uc704\uce58\uc5d0\uc11c\ub4e0 \uc774 \ud14d\uc2a4\ud2b8\uac00 \uc788\ub294 \ubaa8\ub4e0 \ud65c\ub3d9\uc744 \ubc18\ud658\ud574\uc57c \ud569\ub2c8\ub2e4.<\/li>\n
    2. \uace0\uac1d \uc774\ub984: \uc785\ub825\ud55c \uace0\uac1d \uc774\ub984\uc774 \ubd88\uc644\uc804\ud560 \uc218 \uc788\uc73c\ubbc0\ub85c \ucffc\ub9ac\uc5d0\uc11c \uc640\uc77c\ub4dc\uce74\ub4dc\ub97c \uc0ac\uc6a9\ud558\uc5ec \uace0\uac1d \uc774\ub984\uacfc \uc77c\uce58\uc2dc\ucf1c\uc57c \ud569\ub2c8\ub2e4.<\/li>\n
    3. \uc5f0\ub77d\ucc98 \uc774\ub984, \uc774\uba54\uc77c \ub610\ub294 \uc804\ud654 \uc5f0\ub77d\ucc98: \uace0\uac1d\uc740 \uc5f0\ub77d\ucc98 \uc138\ubd80 \uc815\ubcf4\ub97c \uc81c\uacf5\ud560 \uc218\ub3c4 \uc788\uc2b5\ub2c8\ub2e4. \uc774\ub7ec\ud55c \uc815\ubcf4\ub294 \ubd88\uc644\uc804\ud560 \uc218\ub3c4 \uc788\uc2b5\ub2c8\ub2e4.<\/li>\n
    4. \ucc38\uc5ec\uc790 \uc774\ub984: \uace0\uac1d\uc740 \ub610\ud55c \uace0\uac1d\uacfc \uc0c1\ud638 \uc791\uc6a9\ud558\uace0 \ud65c\ub3d9\uc5d0 \ucc38\uc5ec\ud588\ub358 Acme\uc758 \uc9c1\uc6d0\uc778 \uacc4\uc815 \uad00\ub9ac\uc790\uc758 \uc774\ub984\uc744 \uc81c\uacf5\ud560 \uc218 \uc788\uc2b5\ub2c8\ub2e4.<\/li>\n
    5. \ud65c\ub3d9 \ub0a0\uc9dc: \uace0\uac1d\uc740 \ub2e4\uc591\ud55c \ud65c\ub3d9 \ub0a0\uc9dc\uc640 \uc2dc\uac04\uc744 \uc81c\uacf5\ud560 \uc218 \uc788\uc2b5\ub2c8\ub2e4.<\/li>\n
    6. \uc11c\ube44\uc2a4 \ub2f4\ub2f9\uc790\ub294 \uc704\uc758 \uc815\ubcf4 \uc911 \ud558\ub098 \uc774\uc0c1\uc744 \ubc1b\uc744 \uc218 \uc788\uc2b5\ub2c8\ub2e4. \ud328\ud134\uc740 \uace0\uc815\ub418\uc5b4 \uc788\uc9c0 \uc54a\uc2b5\ub2c8\ub2e4.<\/li>\n
    7. \ucffc\ub9ac \uc751\ub2f5 \uc2dc\uac04\uc740 ~1\ucd08\uac00 \ub418\uc5b4\uc57c \ud569\ub2c8\ub2e4.<\/li>\n
    8. \ub370\uc774\ud130 \uc591\uc740 \uc5f0\uac04 3\ubc31\ub9cc \uac74, \ubcf4\uc874 \uae30\uac04\uc740 3\ub144\uc785\ub2c8\ub2e4.<\/li>\n<\/ol>\n

      \uc774 \uc815\ubcf4\ub97c \uac80\uc0c9\ud558\ub294 \ub370 \uc5b4\ub5a4 \uc5b4\ub824\uc6c0\uc774 \uc788\ub098\uc694?<\/h3>\n
        \n
      1. \uace0\uac1d\uc774 \uc81c\uacf5\ud560 \uc218 \uc788\ub294 \ud544\ub4dc\ub294 \ucd5c\ub300 8\uac1c\uae4c\uc9c0\uc774\uba70, \uc774 \uc911 \ud544\uc218 \ud56d\ubaa9\uc740 \uc5c6\uc2b5\ub2c8\ub2e4. \uc774\ub294 \uc778\ub371\uc2a4 \uc120\ud0dd\uc744 \uc704\ud574 \uc778\ub371\uc2a4 \ub9ac\ub529 \ud0a4\uac00 \uc788\uc5b4\uc57c \ud558\uae30 \ub54c\ubb38\uc5d0 \ud6a8\uc728\uc801\uc778 GSI \uc778\ub371\uc2a4 \uc124\uacc4\uc5d0 \uc5b4\ub824\uc6c0\uc774 \ub420 \uc218 \uc788\uc2b5\ub2c8\ub2e4. \uacb0\uacfc\uc801\uc73c\ub85c GSI \uc9c0\uc218\ub294 \ubaa8\ub4e0 \uc0ac\ub840\ub97c \ud3ec\uad04\ud560 \uc218 \uc5c6\uc2b5\ub2c8\ub2e4.<\/li>\n
      2. \uc640\uc77c\ub4dc\uce74\ub4dc \ub9e4\uce6d: \uc81c\uacf5\ub41c \ud65c\ub3d9 \uc81c\ubaa9, \uace0\uac1d \ubc0f \uc5f0\ub77d\ucc98 \uc774\ub984, \uc774\uba54\uc77c \ub610\ub294 \uc804\ud654\uac00 \ubd88\uc644\uc804\ud560 \uc218 \uc788\uc73c\ubbc0\ub85c \uc815\ud655\ud55c N1QL \uc220\uc5b4 \ub9e4\uce6d \uae30\uc220\uc774 \uc791\ub3d9\ud558\uc9c0 \uc54a\uc744 \uc218 \uc788\uc2b5\ub2c8\ub2e4.<\/li>\n
      3. \uc5f0\ub77d\ucc98\uc640 \ucc38\uac00\uc790\ub294 \ubaa8\ub450 \ud65c\ub3d9\uc758 \ud558\uc704 \uac1d\uccb4\uc785\ub2c8\ub2e4. JSON \ub370\uc774\ud130 \ubaa8\ub378\uc5d0\uc11c \uc5f0\ub77d\ucc98\uc640 \ucc38\uac00\uc790\ub294 \ub450 \uac1c\uc758 \uac1c\ubcc4 \ubc30\uc5f4\ub85c \ud45c\ud604\ub429\ub2c8\ub2e4. \ucee4\ubc84\ub9ac\uc9c0 \uc778\ub371\uc2a4\uac00 \ud544\uc694\ud55c \uacbd\uc6b0 \ub450 \ubc30\uc5f4\uc758 \uc694\uc18c\ub97c \ud558\ub098 \uc774\uc0c1 \ud3ec\ud568\ud574\uc57c \ud569\ub2c8\ub2e4.<\/li>\n<\/ol>\n

        \uc194\ub8e8\uc158<\/h3>\n

        1. \uac00\uc7a5 \uac04\ub2e8\ud55c \uc811\uadfc \ubc29\uc2dd\uc740 N1QL \uc220\uc5b4\ub97c \uc0ac\uc6a9\ud558\ub294 \uac83\uc785\ub2c8\ub2e4:<\/h4>\n
        SELECT meta(a).id, a.title, a.startDate, a.account.name, a.contacts, a.participants\r\nFROM crm a \r\nWHERE \r\n  a.type='activity' \r\nAND a.activityType='Appointment'\r\nAND\r\n(\r\n    LOWER(a.title) LIKE '%artificial intelligence%'\r\nAND LOWER(a.account.name) LIKE '%collins%' \r\nAND ANY c in a.contacts SATISFIES LOWER(c.name) LIKE '%rogers%' END\r\nAND ANY c in a.contacts SATISFIES LOWER(c.email) = 'elliottpamela@gmail.com' END \r\nAND ANY c in a.contacts SATISFIES c.phone LIKE '%6816%' END\r\nAND ANY p in a.participants SATISFIES LOWER(p.name)LIKE '%james%' END \r\nAND a.startDate between '2016-08-29' AND '2016-08-30'\r\n)<\/pre>\n
        \ub2e4\uc74c GSI \uc778\ub371\uc2a4\ub3c4 \ud544\uc694\ud569\ub2c8\ub2e4:<\/p>\n
        CREATE INDEX crm_activity_appt_startDate_accid_dur ON `crm`(`activityType`,`startDate`,`accid`,`duration`) WHERE `type` = 'activity'\r\nCREATE INDEX act_account_name_type ON `crm`(lower((`account`).`name`)) WHERE `type` = 'activity'\r\nCREATE INDEX act_contacts_name_type ON `crm`(DISTINCT ARRAY lower(`c`.`name`) FOR c in contacts END) WHERE `type` = 'activity'\r\nCREATE INDEX act_contacts_email_type ON `crm`(DISTINCT ARRAY lower(`c`.`email`) FOR c in contacts END) WHERE `type` = 'activity'\r\nCREATE INDEX act_contacts_phone_type ON `crm`(DISTINCT ARRAY c.phone FOR c in contacts END) WHERE `type` = 'activity'\r\nCREATE INDEX act_participants_name_type ON `crm`(DISTINCT ARRAY lower(`p`.`name`) FOR p in participants END) WHERE `type` = 'activity'\r\n\r\n<\/pre>\n
        \uc704\uc758 \ucffc\ub9ac\ub294 \ucffc\ub9ac \uc131\ub2a5\uc744 \uac1c\uc120\ud558\uae30 \uc704\ud574 \uc0ac\uc6a9 \uac00\ub2a5\ud55c \uc778\ub371\uc2a4 \uc911 \ud558\ub098 \ub610\ub294 \uc804\ubd80\ub97c \uc0ac\uc6a9\ud560 \uc218 \uc788\uc2b5\ub2c8\ub2e4. \uadf8\ub7ec\ub098 \ucffc\ub9ac \uacc4\ud68d\uc774 IntersectScan \uc5f0\uc0b0\uc744 \uc0ac\uc6a9\ud574\uc57c \ud558\uae30 \ub54c\ubb38\uc5d0 \uc5ec\uc804\ud788 \uc131\ub2a5 \ubb38\uc81c\uac00 \uc788\uc744 \uc218 \uc788\uc2b5\ub2c8\ub2e4.<\/p>\n
        2. FTS \uc9c0\uc218 \ud65c\uc6a9<\/h4>\n
        Couchbase \uc804\uccb4 \ud14d\uc2a4\ud2b8 \uac80\uc0c9\uc740 \uc815\ud655\ud558\uc9c0 \uc54a\uc740 \uac80\uc0c9 \uae30\ub2a5\uacfc \uc6d0\ud558\ub294 \uc21c\uc11c\ub300\ub85c \ud544\ub4dc\ub97c \uac80\uc0c9\ud560 \uc218 \uc788\ub294 \uae30\ub2a5\uc73c\ub85c \uc778\ud574 \uc774 \uc0ac\uc6a9 \uc0ac\ub840\uc5d0 \ub3c4\uc6c0\uc774 \ub420 \uc218 \uc788\uc2b5\ub2c8\ub2e4. \ub2e4\uc74c\uc740 \uac80\uc0c9 \uae30\uc900\uc744 \ud3ec\uad04\ud560 \uc218 \uc788\ub294 FTS \uc0c9\uc778\uc785\ub2c8\ub2e4.<\/p>\n
        \"couchbase<\/p>\n
        2.1 CURL \uc0ac\uc6a9 - Couchbase 5.5\uc5d0\uc11c \uc9c0\uc6d0\ub429\ub2c8\ub2e4.<\/h4>\n
        SELECT meta(a).id, a.title,a.startDate, a.account.name, a.contacts, a.participants\r\nFROM CURL(\"https:\/\/localhost:8094\/api\/index\/all_acts\/query\", \r\n          {\"request\":\"POST\",\"header\":\"Content-Type: application\/json\", \"data\":\r\n          '{   \"explain\":false,\"fields\": [\"*\"],\r\n                \"highlight\": {},\r\n                \"query\": {\"conjuncts\":\r\n                      [  {\"field\":\"title\", \"match\": \"artificial intelligence\"} \r\n                      ,  {\"field\":\"contacts.name\", \"match\":\"rogers\"}\r\n                      ,  {\"field\":\"contacts.email\", \"match\":\"eliottpamela@gmail.com\"} \r\n                      ,  {\"field\":\"contacts.phone\", \"wildcard\":\"*6816*\"} \r\n                      ,  {\"field\":\"participants.name\", \"match\":\"james\"} \r\n                      ,  {\"field\":\"account.name\", \"match\":\"collins\"}\r\n                      ,  {\"field\":\"startDate\",\"start\": \"2016-08-29\", \"end\":\"2016-08-30\", \"inclusive_start\": true, \r\n                                      \"inclusive_end\": true} \r\n                      ] \r\n                  }\r\n          }',\r\n          \"user\":\"Administrator:password\"}) result\r\n          UNNEST result.hits h\r\n          INNER JOIN crm a ON (h.id = meta(a).id) AND a.type='activity'<\/pre>\n
        2.2 SEARCH_QUERY\ub97c \uc0ac\uc6a9\ud55c N1QL\/FTS \ud1b5\ud569 \uc2dc<\/h4>\n
        SELECT meta(a).id, a.title,a.startDate, a.account.name, a.contacts, a.participants\r\nFROM SEARCH_QUERY(\"all_acts\",{\"explain\":false,\"fields\": [\"*\"],\"highlight\": {}, \r\n    \"query\": {\"conjuncts\":[ {\"field\":\"title\", \"match\": \"artificial intelligence\"} \r\n                          , {\"field\":\"contacts.name\", \"match\":\"rogers\"} \r\n                          ,  {\"field\":\"contacts.email\", \"match\":\"eliottpamela@gmail.com\"} \r\n                          ,  {\"field\":\"contacts.phone\", \"wildcard\":\"*6816*\"} \r\n                          ,  {\"field\": \"participants.name\", \"match\":\"james\"} \r\n                          ,  {\"field\": \"account.name\", \"match\":\"collins\"}\r\n                          ,  {\"field\": \"startDate\",\"start\": \"2016-08-29\", \"end\":\"2016-08-30\", \"inclusive_start\": true, \r\n                                   \"inclusive_end\": true}\r\n                          ] }}\r\n              ) as result\r\n          UNNEST result.hits h\r\n          INNER JOIN crm a ON (h.id = meta(a).id) AND a.type='activity'<\/pre>\n
        2.3 N1QL \uac80\uc0c9 \uc220\uc5b4\ub97c \uc0ac\uc6a9\ud55c N1QL\/FTS \ud1b5\ud569 \uc0ac\uc6a9 \uc2dc<\/h4>\n
        SELECT meta(a).id, a.title,a.startDate, a.account.name, a.contacts, a.participants\r\nFROM crm a\r\nWHERE a.type='activity'\r\nAND a.activityType='Appointment'\r\nAND SEARCH(a,\r\n   {\"conjuncts\":\r\n     [  {\"field\":\"title\", \"match\": \"artificial intelligence\"},\r\n        {\"field\":\"contacts.name\", \"match\":\"rogers\"},\r\n        {\"field\":\"contacts.email\", \"match\":\"eliottpamela@gmail.com\"},\r\n        {\"field\":\"contacts.phone\", \"wildcard\":\"*6816*\"},\r\n        {\"field\": \"participants.name\", \"match\":\"james\"},\r\n        {\"field\": \"account.name\", \"match\":\"collins\"},\r\n        {\"field\": \"startDate\",\"start\": \"2016-08-29\", \"end\":\"2016-08-30\", \"inclusive_start\": true, \"inclusive_end\": true}\r\n     ]\r\n    }, \r\n    {\"index\":\"all_acts\"}) \/* good practice to provide the specific index name *\/<\/pre>\n
        \ucc38\uace0:<\/strong><\/p>\n
          \n
        1. \uc704\uc758 \uc608\ub294 \ubaa8\ub4e0 \uc220\uc5b4\ub97c \ub2e8\uc77c SEARCH() \ud568\uc218\ub85c \uacb0\ud569\ud558\uae30 \uc704\ud574 \uc811\uc18d\uc0ac \uad6c\uc870\uc640 \ud568\uaed8 FTS \ubcf5\ud569 \ucffc\ub9ac\ub97c \ud65c\uc6a9\ud569\ub2c8\ub2e4. \ub2e4\uc74c\uc5d0 \ub300\ud55c \uc790\uc138\ud55c \ub0b4\uc6a9\uc740 Couchbase FTS \uc124\uba85\uc11c\ub97c \ucc38\uc870\ud558\uc138\uc694. FTS \ucffc\ub9ac \uc720\ud615<\/a><\/li>\n
        2. \uc704\uc758 \ubb38\uc740 \ud544\uc694\ud55c \uac80\uc0c9 \uc220\uc5b4\ub9cc \ud3ec\ud568\ud558\ub3c4\ub85d \ud504\ub85c\uadf8\ub798\ubc0d \ubc29\uc2dd\uc73c\ub85c \uad6c\uc131\ud574\uc57c \ud569\ub2c8\ub2e4.<\/li>\n
        3. FTS \uc778\ub371\uc2a4 \ub514\uc790\uc778\uc5d0\ub294 SEARCH() \ud568\uc218\uc5d0\uc11c \uc0ac\uc6a9\ub418\ub294 \ud544\ub4dc\uac00 \ud3ec\ud568\ub418\uc5b4\uc57c \ud569\ub2c8\ub2e4.<\/li>\n
        4. N1QL \uc220\uc5b4\u00a0a.type='activity'\u00a0<\/strong>\ub294 FTS \uc778\ub371\uc2a4 \uc120\ud0dd\uc744 \uc704\ud55c \ucffc\ub9ac\uc5d0 \ubc18\ub4dc\uc2dc \uc874\uc7ac\ud574\uc57c \ud569\ub2c8\ub2e4.<\/li>\n<\/ol>\n
          N1QL SEARCH_QUERY \ubc0f SEARCH \uc220\uc5b4\ub294 Couchbase v6.5\uc5d0\uc11c \uc0ac\uc6a9\ud560 \uc218 \uc788\ub294 N1QL\/FTS \ud1b5\ud569 \uae30\ub2a5\uc758 \uc77c\ubd80\uc774\uba70, \ubb38\uc11c\uac00 \uc81c\uacf5\ub418\uba74 \ube14\ub85c\uadf8\uc5d0 \uc5c5\ub370\uc774\ud2b8\ud560 \uc608\uc815\uc785\ub2c8\ub2e4.<\/p>\n
          FTS \ucffc\ub9ac \uad6c\ubb38\uc5d0 \ub300\ud55c \uc790\uc138\ud55c \ub0b4\uc6a9\uc740 \ub2e4\uc74c\uacfc \uac19\uc774 \ud655\uc778\ud558\uc138\uc694. https:\/\/docs.couchbase.com\/server\/6.0\/fts\/full-text-intro.html<\/a><\/p>\n
          N1QL \ubc0f \uac80\uc0c9 \uc694\uc57d:<\/h4>\n
            \n
          1. N1QL\/FTS \ud1b5\ud569\uc744 \ud1b5\ud574 \ucffc\ub9ac\uc5d0\uc11c FTS \uac80\uc0c9 \uad6c\ubb38\uc744 \uac80\uc0c9 \uc220\uc5b4\ub85c \uc9c1\uc811 \uc0ac\uc6a9\ud560 \uc218 \uc788\uc2b5\ub2c8\ub2e4.<\/li>\n
          2. N1QL \ucffc\ub9ac\uc5d0\uc11c FTS \uc778\ub371\uc2a4\ub97c \uc0ac\uc6a9\ud558\uba74 \uac01 \ucffc\ub9ac \ud328\ud134\uc5d0 \ub300\ud55c \uc815\ud655\ud55c \uc778\ub371\uc2a4\uac00 \ud544\uc694\ud558\uc9c0 \uc54a\uc2b5\ub2c8\ub2e4.<\/li>\n
          3. N1QL\/FTS\ub294 \uac1c\ubc1c\uc790\uac00 \ucffc\ub9ac \uc131\ub2a5 \ubb38\uc81c\ub97c \ucc98\ub9ac\ud560 \ub54c \ud0d0\uc0c9\ud560 \uc218 \uc788\ub294 \ucd94\uac00 \uc635\uc158\uc744 \uc81c\uacf5\ud569\ub2c8\ub2e4.<\/li>\n
          4. FTS \uc778\ub371\uc2a4\ub294 \uc5ec\ub7ec \ud544\ub4dc\ub97c \uc5b4\ub5a4 \uc21c\uc11c\ub85c\ub4e0 \uac80\uc0c9\ud574\uc57c \ud558\ub294 \uacbd\uc6b0\uc5d0 \uc801\ud569\ud569\ub2c8\ub2e4.<\/li>\n
          5. FTS \uc778\ub371\uc2a4\ub294 \uc5ec\ub7ec \ubc30\uc5f4\uc758 \ud544\ub4dc\ub97c \uac80\uc0c9\ud574\uc57c \ud558\ub294 \uacbd\uc6b0\uc5d0 \uc801\ud569\ud569\ub2c8\ub2e4.<\/li>\n<\/ol>\n
            \ub9ac\uc18c\uc2a4<\/b><\/h4>\n