Home

图数据构建脚本后台远程执行

Here’s the table of contents: execute-graph-data-build execute-graph-data-build 从202机器后台执行CQL脚本,在173集群中构建图数据 #!/bin/bash su - ongdb <<EOF testlab%pro echo "Build Graph Data..." cat /home/ongdb/graph-sync-check-point/temp/public_fund_replenish.cql | /home/ongdb/ongdb-enterprise-3.5.22/bin/cypher-shell -a bolt+routing://10.20.12.17...

Read more

ONgDB集群数据增量备份方案

Here’s the table of contents: 修改集群配置 远程全量热备命令 远程增量热备命令 数据恢复脚本 单节点备份恢复操作指南 1、修改支持备份的配置 2、启动单节点增量备份 3、启动单节点备份恢复 参考文档 修改集群配置 # Enable online backups to be taken from this database. dbms.backup.enabled=true # By default the backup service will only listen on localhost. # To enable remote backups you will ...

Read more

后台执行CQL脚本

Here’s the table of contents: 执行单条CQL test.sh批量执行脚本 执行单条CQL cat /ongdb_data/ongdb-enterprise-3.5.22/test.cql | nohup /ongdb_data/ongdb-enterprise-3.5.22/bin/cypher-shell -a bolt://10.20.7.181:7687 -u ongdb -p testlab%pro >>console.log 2>&1 & test.sh批量执行脚本 #!/bin/bash # 定义CQL文件名称 array=(test1 test2 test3 test4 test5 test6...

Read more

ONgDB批量导入CSV文件

Here’s the table of contents: 版本 cypher-shell执行批量提交的脚本 browser中执行批量提交的CYPHER 版本 ongdb-enterprise-3.5.22 cypher-shell执行批量提交的脚本 USING PERIODIC COMMIT 10000 LOAD CSV FROM 'file:/xbe' AS line WITH TOINT(line[1]) AS ybId,TOINT(line[2]) AS kwId,apoc.convert.toFloat(line[3]) AS weight MATCH (yb:研报)-[r:包含]->(kw:关键词) WHERE ID(yb)=ybId AND I...

Read more

Linux文件切分

Here’s the table of contents: 切分【分割】【文件】 切分【分割】【文件】 查看文件行数 wc -l filename split -l 5000(行数) -a 5(增加文件名上限) /file /new_file_prefix split -6 README #将README文件每六行分割成一个文件

Read more

公司主数据最大连通图分析

Here’s the table of contents: 数据量统计 最大连通图分析脚本 数据量统计 MATCH (n:PREPCODE) RETURN COUNT(*) 465927292 MATCH (n:PREPCODE)-->() RETURN COUNT(*) 965345392 最大连通图分析脚本 CALL algo.unionFind.stream('PREPCODE',NULL,{concurrency:8}) YIELD nodeId,setId WITH nodeId,setId WITH COLLECT(nodeId) AS nodeIdList,setId WITH SIZE(nodeIdList) AS size,nodeIdLis...

Read more

Python发起HTTP请求

Here’s the table of contents: Python - Requests Python - Requests import requests url = "http://10.20.13.200/db/data/transaction/commit" payload="{\r\n \"statements\": [\r\n {\r\n \"statement\": \"CALL apoc.load.jdbc('jdbc:oracle:thin:nfdp/testlabgogo@nfdpdb-sync-prod.crkldnwly6ki.rds.cn-north-1.alibaba.com.cn:1521/OR...

Read more

Shell发起HTTP请求

Here’s the table of contents: Shell - Httppie Shell - wget Shell - curl Shell - Httppie printf '{ "statements": [ { "statement": "CALL apoc.load.jdbc('\''jdbc:oracle:thin:nfdp/testlabgogo@nfdpdb-sync-prod.crkldnwly6ki.rds.cn-north-1.alibaba.com.cn:1521/ORCL'\'', '\''SELECT FUND_HCODE AS \\"hcode\\",CNAME AS \\"cn...

Read more