全文搜索

    在语句中，使用WHERE子句指定字符串的搜索条件。

    请确保已经部署全文索引。详情请参见部署全文索引和。

    使用全文索引前，请确认已经了解全文索引的使用限制。

    1. SHOW FULLTEXT INDEXES;
    1. DROP FULLTEXT INDEX <index_name>;

    • PREFIX(schema_name.prop_name, prefix_string, row_limit, timeout)

    • WILDCARD(schema_name.prop_name, wildcard_string, row_limit, timeout)

    • REGEXP(schema_name.prop_name, regexp_string, row_limit, timeout)

      • fuzziness：可选项。允许匹配的最大编辑距离。默认值为AUTO。查看其他可选值和更多信息，请参见。

      • operator：可选项。解释文本的布尔逻辑。可选值为OR(默认)和and。

    • row_limit：可选项。指定要返回的行数。默认值为100。

    1. //创建图空间。
    2. nebula> CREATE SPACE basketballplayer (partition_num=3,replica_factor=1, vid_type=fixed_string(30));
    4. //登录文本搜索客户端。
    5. nebula> SIGN IN TEXT SERVICE (127.0.0.1:9200);
    7. //切换图空间。
    8. nebula> USE basketballplayer;
    10. //添加listener到Nebula Graph集群。
    11. nebula> ADD LISTENER ELASTICSEARCH 192.168.8.5:9789;
    13. //创建Tag。
    14. nebula> CREATE TAG player(name string, age int);
    16. //创建原生索引。
    17. nebula> CREATE TAG INDEX name ON player(name(20));
    19. //重建原生索引。
    20. nebula> REBUILD TAG INDEX;
    22. nebula> CREATE FULLTEXT TAG INDEX nebula_index_1 ON player(name);
    24. //重建全文索引。
    25. nebula> REBUILD FULLTEXT INDEX;
    27. //查看全文索引。
    28. nebula> SHOW FULLTEXT INDEXES;
    29. +------------------+-------------+-------------+--------+
    30. | Name             | Schema Type | Schema Name | Fields |
    31. +------------------+-------------+-------------+--------+
    32. | "nebula_index_1" | "Tag"       | "player"    | "name" |
    33. +------------------+-------------+-------------+--------+
    35. //插入测试数据。
    36. nebula> INSERT VERTEX player(name, age) VALUES \
    37.   "Russell Westbrook": ("Russell Westbrook", 30), \
    38.   "Chris Paul": ("Chris Paul", 33),\
    39.   "Boris Diaw": ("Boris Diaw", 36),\
    40.   "David West": ("David West", 38),\
    41.   "Danny Green": ("Danny Green", 31),\
    42.   "Tim Duncan": ("Tim Duncan", 42),\
    43.   "James Harden": ("James Harden", 29),\
    44.   "Tony Parker": ("Tony Parker", 36),\
    45.   "Aron Baynes": ("Aron Baynes", 32),\
    46.   "Ben Simmons": ("Ben Simmons", 22),\
    47.   "Blake Griffin": ("Blake Griffin", 30);
    49. //测试查询
    50. nebula> LOOKUP ON player WHERE PREFIX(player.name, "B");
    51. +-----------------+
    52. | _vid            |
    53. +-----------------+
    54. | "Boris Diaw"    |
    55. +-----------------+
    56. | "Ben Simmons"   |
    57. +-----------------+
    58. | "Blake Griffin" |
    59. +-----------------+
    61. nebula> LOOKUP ON player WHERE WILDCARD(player.name, "*ri*") YIELD player.name, player.age;
    62. +-----------------+-----------------+-----+
    64. | "Chris Paul"    | "Chris Paul"    | 33  |
    65. +-----------------+-----------------+-----+
    66. | "Boris Diaw"    | "Boris Diaw"    | 36  |
    67. +-----------------+-----------------+-----+
    68. | "Blake Griffin" | "Blake Griffin" | 30  |
    69. +-----------------+-----------------+-----+
    71. nebula> LOOKUP ON player WHERE WILDCARD(player.name, "*ri*") | YIELD count(*);
    72. +----------+
    73. | count(*) |
    74. +----------+
    75. | 3        |
    76. +----------+
    78. nebula> LOOKUP ON player WHERE REGEXP(player.name, "R.*") YIELD player.name, player.age;
    79. +---------------------+---------------------+-----+
    80. | _vid                | name                | age |
    81. +---------------------+---------------------+-----+
    82. | "Russell Westbrook" | "Russell Westbrook" | 30  |
    83. +---------------------+---------------------+-----+
    85. nebula> LOOKUP ON player WHERE REGEXP(player.name, ".*");
    86. +---------------------+
    87. | _vid                |
    88. +---------------------+
    89. | "Danny Green"       |
    90. +---------------------+
    91. | "David West"        |
    92. +---------------------+
    93. | "Russell Westbrook" |
    94. +---------------------+
    95. ...
    97. nebula> LOOKUP ON player WHERE FUZZY(player.name, "Tim Dunncan", AUTO, OR) YIELD player.name;
    98. +--------------+--------------+
    99. | _vid         | name         |
    100. +--------------+--------------+
    101. | "Tim Duncan" | "Tim Duncan" |
    102. +--------------+--------------+
    104. nebula> DROP FULLTEXT INDEX nebula_index_1;