match id() in [ 1,2,3 ... 15] return. 集合超过 14 个报错

[aya]

• nebula 版本：3.4
• 部署方式：单机
• 安装方式：Docker
• 是否为线上版本： N
• 硬件信息
  • 磁盘（ 推荐使用 SSD）
  • CPU、内存信息
• 问题的具体描述
  match(n) where id(n) in [“”,“”, …, “”] id集合14个以内正常返回 ，15个以上报 [ERROR (-1005)]: Scan vertices or edges need to specify a limit number, or limit number can not push down
  哪位可以指点下 tag
  

[wey]

好神奇，不在电脑边，方便执行一下 两种情况的 explain 结果么？在query前边加 explain 就行

[aya]

[wey]

两个情况都是 ScanVertices 么？奇怪，应该是 passthrough 才对，请问你的配置里有关闭优化器么？确定你的内核是 3.4.0?

explain match (n) where id(n) IN ["a","b"] return n
…
-----+----------------+--------------+----------------+----------------------------------------------
|  1 | PassThrough    | 3            |                | outputVar: {                                |
|    |                |              |                |   "colNames": [                             |
|    |                |              |                |     "_vid"                                  |
|    |                |              |                |   ],                                        |
|    |                |              |                |   "type": "DATASET",                        |
|    |                |              |                |   "name": "__VAR_0"                         |
|    |                |              |                | }                                           |
|    |                |              |                | inputVar:                                   |
-----+----------------+--------------+----------------+----------------------------------------------
|  3 | Start          |              |                | outputVar: {                                |
|    |                |              |                |   "colNames": [],                           |
|    |                |              |                |   "type": "DATASET",                        |
|    |                |              |                |   "name": "__Start_3"                       |
|    |                |              |                | }                                           |
-----+----------------+--------------+----------------+----------------------------------------------

[aya]

超过 15个就是 scanvertices

15个 或以内 是 scanvertices

scanvertices scanvertices 有何区分 具体怎么使用 哪里可以了解下么

[wey]

奇怪，我这里并不能重现，版本是？ SHOW HOSTS GRAPH 的结果是？

explain match(n) where id(n) IN["0", "1", "2", "3", "4", "5", "6", "7", "8", "9", "10", "11", "12", "13", "14", "15", "16"] return n
Execution succeeded (time spent 691/55571 us)
...
-----+----------------+--------------+----------------+--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
|  1 | PassThrough    | 3            |                | outputVar: {                                                                                                                                                                                                                                                                                                      |
|    |                |              |                |   "colNames": [                                                                                                                                                                                                                                                                                                   |
|    |                |              |                |     "_vid"                                                                                                                                                                                                                                                                                                        |
|    |                |              |                |   ],                                                                                                                                                                                                                                                                                                              |
|    |                |              |                |   "type": "DATASET",                                                                                                                                                                                                                                                                                              |
|    |                |              |                |   "name": "__VAR_0"                                                                                                                                                                                                                                                                                               |
|    |                |              |                | }                                                                                                                                                                                                                                                                                                                 |
|    |                |              |                | inputVar:                                                                                                                                                                                                                                                                                                         |
-----+----------------+--------------+----------------+--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
|  3 | Start          |              |                | outputVar: {                                                                                                                                                                                                                                                                                                      |
|    |                |              |                |   "colNames": [],                                                                                                                                                                                                                                                                                                 |
|    |                |              |                |   "type": "DATASET",                                                                                                                                                                                                                                                                                              |
|    |                |              |                |   "name": "__Start_3"                                                                                                                                                                                                                                                                                             |
|    |                |              |                | }                                                                                                                                                                                                                                                                                                                 |
-----+----------------+--------------+----------------+--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------

(root@nebula) [basketballplayer]> SHOW HOSTS GRAPH
+-----------+------+----------+---------+--------------+---------+
| Host      | Port | Status   | Role    | Git Info Sha | Version |
+-----------+------+----------+---------+--------------+---------+
| "graphd"  | 9669 | "ONLINE" | "GRAPH" | "db3c1b3"    | "3.4.0" |
| "graphd1" | 9669 | "ONLINE" | "GRAPH" | "db3c1b3"    | "3.4.0" |
| "graphd2" | 9669 | "ONLINE" | "GRAPH" | "db3c1b3"    | "3.4.0" |
+-----------+------+----------+---------+--------------+---------+
Got 3 rows (time spent 2767/55810 us)

麻烦帮忙确认下版本

[kyle]

我复现了，会尽快修复，感谢反馈。

[wey]

哇，条件是？