- nebula 版本:2.6.0
- 部署方式:集群
- 安装方式:Docker
- 是否为线上版本:N
- 硬件信息
- 磁盘( 推荐使用 SSD)
- CPU、内存信息
- 问题的具体描述
全文索引测试列子中 :
LOOKUP ON player WHERE PREFIX(player.name, “B”);
没有结果
而这一条可以 LOOKUP ON player WHERE WILDCARD(player.name, “ri”) YIELD player.name, player.age 可以检索出来
执行过程
(root@nebula) [(none)]> show spaces
+------+
| Name |
+------+
+------+
Empty set (time spent 1913/2999 us)
Fri, 07 Jan 2022 03:46:59 UTC
(root@nebula) [(none)]> CREATE SPACE IF NOT EXISTS basketballplayer (partition_num=3,replica_factor=1, vid_type=fixed_string(30));
Execution succeeded (time spent 15921/16785 us)
Fri, 07 Jan 2022 03:47:20 UTC
(root@nebula) [(none)]> SIGN IN TEXT SERVICE (192.168.2.242:9200);
Execution succeeded (time spent 10525/11420 us)
Fri, 07 Jan 2022 03:47:38 UTC
(root@nebula) [(none)]> USE basketballplayer;
Execution succeeded (time spent 2846/3724 us)
Fri, 07 Jan 2022 03:47:47 UTC
(root@nebula) [basketballplayer]> ADD LISTENER ELASTICSEARCH 172.23.0.5:9789,172.23.0.8:9789,172.23.0.10:9789;
Execution succeeded (time spent 11212/12201 us)
Fri, 07 Jan 2022 03:48:27 UTC
(root@nebula) [basketballplayer]> CREATE TAG IF NOT EXISTS player(name string, age int);
Execution succeeded (time spent 15048/15830 us)
Fri, 07 Jan 2022 03:48:37 UTC
(root@nebula) [basketballplayer]> CREATE TAG INDEX IF NOT EXISTS name ON player(name(20));
Execution succeeded (time spent 16199/16978 us)
Fri, 07 Jan 2022 03:48:45 UTC
(root@nebula) [basketballplayer]> REBUILD TAG INDEX;
+------------+
| New Job Id |
+------------+
| 10 |
+------------+
Got 1 rows (time spent 11843/12888 us)
Fri, 07 Jan 2022 03:48:54 UTC
(root@nebula) [basketballplayer]> CREATE FULLTEXT TAG INDEX nebula_index_1 ON player(name);
Execution succeeded (time spent 168670/169622 us)
Fri, 07 Jan 2022 03:49:03 UTC
(root@nebula) [basketballplayer]> REBUILD FULLTEXT INDEX;
+------------+
| New Job Id |
+------------+
| 11 |
+------------+
Got 1 rows (time spent 10943/11974 us)
Fri, 07 Jan 2022 03:49:11 UTC
(root@nebula) [basketballplayer]> SHOW FULLTEXT INDEXES;
+------------------+-------------+-------------+--------+
| Name | Schema Type | Schema Name | Fields |
+------------------+-------------+-------------+--------+
| "nebula_index_1" | "Tag" | "player" | "name" |
+------------------+-------------+-------------+--------+
Got 1 rows (time spent 2392/3677 us)
Fri, 07 Jan 2022 03:49:19 UTC
(root@nebula) [basketballplayer]> INSERT VERTEX player(name, age) VALUES \
-> "Russell Westbrook": ("Russell Westbrook", 30), \
-> "Chris Paul": ("Chris Paul", 33),\
-> "Boris Diaw": ("Boris Diaw", 36),\
-> "David West": ("David West", 38),\
-> "Danny Green": ("Danny Green", 31),\
-> "Tim Duncan": ("Tim Duncan", 42),\
-> "James Harden": ("James Harden", 29),\
-> "Tony Parker": ("Tony Parker", 36),\
-> "Aron Baynes": ("Aron Baynes", 32),\
-> "Ben Simmons": ("Ben Simmons", 22),\
-> "Blake Griffin": ("Blake Griffin", 30);
Execution succeeded (time spent 14652/16574 us)
Fri, 07 Jan 2022 03:49:27 UTC
(root@nebula) [basketballplayer]> LOOKUP ON player WHERE PREFIX(player.name, "B");
+----------+
| VertexID |
+----------+
+----------+
Empty set (time spent 676343/677975 us)
Fri, 07 Jan 2022 03:49:36 UTC
(root@nebula) [basketballplayer]> LOOKUP ON player WHERE WILDCARD(player.name, "*ri*") YIELD player.name, player.age;
+--------------+--------------+------------+
| VertexID | player.name | player.age |
+--------------+--------------+------------+
| "Boris Diaw" | "Boris Diaw" | 36 |
| "Chris Paul" | "Chris Paul" | 33 |
+--------------+--------------+------------+
Got 2 rows (time spent 610990/612851 us)
Fri, 07 Jan 2022 03:51:30 UTC
(root@nebula) [basketballplayer]> SHOW FULLTEXT INDEXES;
+------------------+-------------+-------------+--------+
| Name | Schema Type | Schema Name | Fields |
+------------------+-------------+-------------+--------+
| "nebula_index_1" | "Tag" | "player" | "name" |
+------------------+-------------+-------------+--------+
Got 1 rows (time spent 2180/3607 us)
Fri, 07 Jan 2022 03:57:09 UTC
(root@nebula) [basketballplayer]> LOOKUP ON player WHERE PREFIX(player.name, "B") YIELD player.name, player.age
+----------+-------------+------------+
| VertexID | player.name | player.age |
+----------+-------------+------------+
+----------+-------------+------------+
Empty set (time spent 566260/567727 us)
Fri, 07 Jan 2022 03:58:40 UTC
(root@nebula) [basketballplayer]>
结果图片