- nebula 版本:3.0.0
- 部署方式:分布式
- 安装方式:RPM
- 是否为线上版本:Y
- 硬件信息
- 磁盘 SATA
- CPU、内存信息 三台虚拟机:都是4核、8g内存
- 问题的具体描述
javr包批量从其他数据库导入数据后,点正常。
但是边不正常,Match查询时不限定边类型可以查到,而限定边类型后就查无数据。
同时我用点去遍历子图,证明是存在这些边的
Match:指定边类型查询
(shixingr@nebula) [field_blood_relation_space]> MATCH ()<-[e:table_rely]-() RETURN e limit 100;
+---+
| e |
+---+
+---+
Empty set (time spent 1952/2372 us)
Fri, 01 Apr 2022 19:04:40 CST
(shixingr@nebula) [field_blood_relation_space]> MATCH ()<-[e:table_rely]-() RETURN e;
+---+
| e |
+---+
+---+
Empty set (time spent 2061/2554 us)
Match:不指定边类型查询
(shixingr@nebula) [field_blood_relation_space]> MATCH ()<-[e]-() RETURN e limit 100;
+--------------------------------------------------------------------------------------------------------------------------------------------------------------+
| e |
+--------------------------------------------------------------------------------------------------------------------------------------------------------------+
| [:table_rely "dwd.dwd_log_detail_d"->" tujia_tmp.cpc_cost_city" @0 {}] |
| [:table_rely "dws.dws_house_d"->" tujia_tmp.cpc_cost_city" @0 {}] |
| [:table_rely "dws.dws_order"->" tujia_tmp.cpc_cost_city" @0 {}] |
| [:table_rely "ods_ploutos_fabs.market_record"->" tujia_tmp.cpc_cost_city" @0 {}] |
| [:table_rely "x1"->" tujia_tmp.cpc_cost_city" @0 {}] |
| [:table_rely "meta_data"->"`ods_callcenter`.`callgroup`" @0 {}] |
| [:table_rely "tujia_tmp.ods_callcenter_callgroup_tmp"->"`ods_callcenter`.`callgroup`" @0 {}] |
| [:table_rely "meta_data"->"`ods_crm`.`busopty_base`" @0 {}] |
| [:table_rely "tujia_tmp.ods_crm_busopty_base_tmp"->"`ods_crm`.`busopty_base`" @0 {}] |
| [:table_rely "meta_data"->"`ods_csc`.`spsupcitymapping`" @0 {}] |
| [:table_rely "tujia_tmp.ods_csc_spsupcitymapping_tmp"->"`ods_csc`.`spsupcitymapping`" @0 {}] |
| [:table_rely "meta_data"->"`ods_csc`.`spsupplierinfo`" @0 {}] |
| [:table_rely "tujia_tmp.ods_csc_spsupplierinfo_tmp"->"`ods_csc`.`spsupplierinfo`" @0 {}] |
| [:table_rely "meta_data"->"`ods_distributionmanager`.`ctrip_hotel_partial_origin_data`" @0 {}] |
| [:table_rely "tujia_tmp.ods_distributionmanager_ctrip_hotel_partial_origin_data_tmp"->"`ods_distributionmanager`.`ctrip_hotel_partial_origin_data`" @0 {}] |
| [:table_rely "meta_data"->"`ods_distributionmanager`.`ctrip_prodcit_rule_relation_info`" @0 {}] |
| [:table_rely "tujia_tmp.ods_distributionmanager_ctrip_prodcit_rule_relation_info_tmp"->"`ods_distributionmanager`.`ctrip_prodcit_rule_relation_info`" @0 {}] |
| [:table_rely "meta_data"->"`ods_houseimport_config`.`api_supplier_online_log`" @0 {}] |
| [:table_rely "tujia_tmp.ods_houseimport_config_api_supplier_online_log_tmp"->"`ods_houseimport_config`.`api_supplier_online_log`" @0 {}] |
| [:table_rely "meta_data"->"`ods_ploutos_fas`.`account_transaction`" @0 {}] |
| [:table_rely "ods_order_data.notify_queue"->"`ods_ploutos_fas`.`account_transaction`" @0 {}] |
| [:table_rely "ods_tns_order_notice.b_notice_queue"->"`ods_ploutos_fas`.`account_transaction`" @0 {}] |
| [:table_rely "ods_tns_order_notice.notice_queue"->"`ods_ploutos_fas`.`account_transaction`" @0 {}] |
| [:table_rely "ods_tns_order_notice.notify_queue"->"`ods_ploutos_fas`.`account_transaction`" @0 {}] |
| [:table_rely "tujia_tmp.ods_ploutos_fas_account_transaction_tmp"->"`ods_ploutos_fas`.`account_transaction`" @0 {}] |
| [:table_rely "meta_data"->"`ods_ploutos_fcss`.`biz_order_item`" @0 {}] |
| [:table_rely "tujia_tmp.ods_ploutos_fcss_biz_order_item_tmp"->"`ods_ploutos_fcss`.`biz_order_item`" @0 {}] |
| [:table_rely "ods_tujiaorder.orderreturncash"->"`ods_systemoperation`.`pageredirectconfig`" @0 {}] |
| [:table_rely "meta_data"->"`ods_tc_iris`.`t_message_info`" @0 {}] |
| [:table_rely "tujia_tmp.ods_tc_iris_t_message_info_tmp"->"`ods_tc_iris`.`t_message_info`" @0 {}] |
get subgraph
获取子图也可查到:
语句如下,打印结果很多 不在此粘贴了
get subgraph 3 steps from "ods_tujia_member.member" out table_rely yield edges as table_rely;
Fri, 01 Apr 2022 19:04:47 CST