运行tigergraph地理空间分析demo

[Valdanitooooo]

Geospatial Analysis with a Native Parallel Graph Database

演示视频

https://www.youtube.com/watch?v=gPF_SXibDxw

仓库

https://github.com/tigergraph/ecosys/tree/master/demos/guru_scripts/geospatial_search

部署tigergraph

这个demo的solution使用的2.2.4版本的，最新的3.x.x版本没法导入，找到一个2.4.0版本的

version: '3'
services:
    tigergraph:
        image: docker.tigergraph.com/tigergraph:2.4.0
        container_name: tigergraph-dev
        ports:
            - "14022:22"
            - "9000:9000"
            - "14240:14240"
        volumes:
            - ./tigergraph-data:/home/tigergraph/tigergraph/loadingData
        healthcheck:
            test: ["CMD-SHELL", "curl --fail http://localhost:9000/echo || exit 1"]
            interval: 10s
            timeout: 10s
            retries: 5
        ulimits:
            nofile:
                soft: 1000000
                hard: 1000000
        stdin_open: true
        tty: true

进入容器执行gadmin start all 启动服务

tigergraph:
http://localhost:14240
admin/admin

运行demo

按照readme操作

Please follow the steps to install.

1. Import the solution.tar.gz from your GraphStudio.

2. Copy or merge ExprUtil.hpp and ExprFunctions.hpp to ~/tigergraph/dev/gdk/gsql/src/QueryUdf/

3. Copy or merge TokenBank.cpp to ~/tigergraph/dev/gdk/gsql/src/TokenBank/

4. Copy data under data/ to ~/tigergraph/loadingData/

5. Run loading from GraphStudio. 

6. Run loader.gsql by using command gsql -g MyGraph loader.gsql 

7. Install queries in Write Queries page of GraphStudio.

8. Follow the instructions under geospatial_ui folder to deploy the geo spatial demo UI.

第6步遇到问题，导入报错

{
    "version":{
        "edition":"developer",
        "api":"v2",
        "schema":0
    },
    "error":true,
    "message":"/home/tigergraph/tigergraph/bin/TokenBank.so_RESTPP-LOADER_1_1_w0_h1.dir/1632647309469: undefined symbol: getGridId false\n@void* gse2::GSE_GENERIC_LOADER_UTILITY<reader, writer, buffer>::loadFuncP(const string&) [with reader = restpp::PostReader; writer = topology4::PostWriter; buffer = gse2::GSE_DELTA_BUFFER; std::string = std::basic_string<char>](/opt/builder/workbench/buildcentos652/192.168.11.118/tg_2.4.0_dev/product/src/core/gse/gse2/loader/generic_loader_utility.hpp:3724)\n\nMyGraph_loadGeo for Graph 'MyGraph'.",
    "code":"REST-30000"
}

不太理解是什么错误，应该是和getGridId函数有关，在源码中搜了一下，TokenBank.cpp和ExprFunctions.hpp都有这个函数，ExprFunctions.hpp中是注释掉的状态，里面还有注释

/**     XXX Warning!! Put self-defined struct in ExprUtil.hpp **
 *  No user defined struct, helper functions (that will not be directly called
 *  in the GQuery scripts) etc. are allowed in this file. This file only
 *  contains user-defined expression function's signature and body.
 *  Please put user defined structs, helper functions etc. in ExprUtil.hpp
 */

解压solution.tar.gz里面也有ExprFunctions.hpp文件，不知道是不是因为版本差异没有正确导入ExprFunctions.hpp

手动拷贝ExprFunctions.hpp到与ExprUtil.hpp相同目录

再执行导入，导入成功！

tigergraph@b2a07363607f:~/tigergraph/loadingData$ gsql -g MyGraph loader.gsql
The job loadGeo is dropped!
The job loadGeo is created.
[Tip: Use "CTRL + C" to stop displaying the loading status update, then use "SHOW LOADING STATUS jobid" to track the loading progress again]
[Tip: Manage loading jobs with "ABORT/RESUME LOADING JOB jobid"]
Starting the following job, i.e.
  JobName: loadGeo, jobid: MyGraph.loadGeo.file.m1.1632648940033
  Loading log: '/home/tigergraph/tigergraph/logs/restpp/restpp_loader_logs/MyGraph/MyGraph.loadGeo.file.m1.1632648940033.log'

Job "MyGraph.loadGeo.file.m1.1632648940033" loading status
[FINISHED] m1 ( Finished: 3 / Total: 3 )
  [LOADED]
  +---------------------------------------------------------------------------------------------------------------------+
  |                                                                 FILENAME |   LOADED LINES |   AVG SPEED |   DURATION|
  |                  /home/tigergraph/tigergraph/loadingData/ca_postcode.csv |           2591 |      2 kl/s |     1.00 s|
  |/home/tigergraph/tigergraph/loadingData/healthcare_facility_locations.csv |          10774 |     10 kl/s |     1.02 s|
  |                      /home/tigergraph/tigergraph/loadingData/patient.csv |          10774 |     10 kl/s |     1.00 s|
  +---------------------------------------------------------------------------------------------------------------------+

部署UI

按geospatial_ui的readme操作

写一个部署脚本

nohup http-serve ./ -P http://192.168.31.10:9000 -p 14241 > tg_geospatial_ui.log 2>&1 & echo $! > tg_geospatial_ui.pid

http://localhost:14241/