做网站域名备案需要多久,企业年金查询官网,苏州市优化网站推广哪家好,营销网站报备InfiniSynapse 通过自研的第二代LLM-Native RAG实现了企业业务的理解#xff0c;精准的Schema召回保证数据的准确性。提供专门为大模型优化的InfiniSQL语言#xff0c;从而可以更加准确的生成查询语句#xff0c;通过 InfiniSQL 引擎让人类第一次对存储在各种数据源的全模态…
InfiniSynapse 通过自研的第二代LLM-Native RAG实现了企业业务的理解精准的Schema召回保证数据的准确性。提供专门为大模型优化的InfiniSQL语言从而可以更加准确的生成查询语句通过 InfiniSQL 引擎让人类第一次对存储在各种数据源的全模态数据库结构化文档语音视频进行联合智能分析并且支持海量规模。
通过Agentic 范式搭配超强的RAG大模型友好的 InfiniSQL, InfiniSynapse实现了当前智能分析领域的SOTA。
我们不仅仅是 NLP2SQL, 更是让你的每条数据都被智能化分析。
手册AI 辅助分析工具 InfiniSynapse - 飞书云文档 部署和安装001-部署和安装 - 飞书云文档
安装InfiniSynapse
可以Ubuntu或MacOS部署也可以Docker部署先尝试Ubuntu部署。
安装包下载地址
文件名infinisynapse_release.zip 链接: https://pan.baidu.com/s/1F9g_TRUxCWFhhoq-UQOAIg?pwdx615 提取码: x615
或者直接从飞书下载。
下载后先解压
unzip infinisynapse_release.zip
建议解压到用户根目录或者自己设定的其它工作目录。 解压之后会看到一共有两个部分infini-sql和infini-synapse两个部分。 部署Infini-sql
安装java
因为infini-sql依赖java所以我们先进入infini-sql目录使用目录下的脚本安装jdk8. 运行完成之后本地会有一个jdk8的目录
bash install_jdk8.sh
infinisynapse_release/infini-sql$ sh install_jdk8.sh
2025-06-12 23:29:55 - Creating temporary directory at /home/skywalk/download/infinisynapse_release/infini-sql/tmp
2025-06-12 23:29:55 - Setting up environment for linux
2025-06-12 23:29:55 - Downloading JDK for linux% Total % Received % Xferd Average Speed Time Time Time CurrentDload Upload Total Spent Left Speed0 0 0 0 0 0 0 0 --:--:-- --:--:-- --:--:-- 0
100 113M 100 113M 0 0 6998k 0 0:00:16 0:00:16 --:--:-- 7903k 2025-06-13 01:06:19 - JDK setup completed successfully at /home/skywalk/download/infinisynapse_release/infini-sql/jdk8
但是老的安装包有问题因此需要手工安装java 改成手工安装java
到infini-sql目录wget下载文件
wget https://corretto.aws/downloads/latest/amazon-corretto-8-x64-linux-jdk.tar.gz
解压缩
tar -xzvf amazon-corretto-8-x64-linux-jdk.tar.gz
改目录名 mv amazon-corretto-8.452.09.1-linux-x64/ jdk8
安装java8完成
打开byzer服务 安装好jdk后设置java目录路径设置spark目录路径并打开byzer服务
# 设置java路径
export JAVA_HOME$(cd -P -- $(dirname -- $0) pwd -P)/jdk8
# 设置spark路径
export SPARK_HOME$(cd -P -- $(dirname -- $0) pwd -P)/spark
bash bin/byzer.sh start注意这里有可能发生jdk8安装失败的问题可以手工安装见后面调试部分。其它系统的java目录路径设置如下
# mac系统使用
export JAVA_HOME$(cd -P -- $(dirname -- $0) pwd -P)/jdk8/Contents/Home# linux系统使用
export JAVA_HOME$(cd -P -- $(dirname -- $0) pwd -P)/jdk8# windows使用
export JAVA_HOME$(cd -P -- $(dirname -- $0) pwd -P)/jdk8#然后运行
bash bin/byzer.sh start byzer启动成功
Byzer engine is starting. It may take a while. For status, please visit http://192.168.0.16:9003.
You may also check status via: PID:72703, or Log: /home/skywalk/download/infinisynapse_release/infini-sql/logs/byzer-lang.log. 用浏览器连上http://192.168.0.16:9003/
执行默认命令select 1 as a,jack as b as bbc;
输出
a b
1 jack
部署infini-synapse
首先进入infini-synapse目录
安装node22
安装node需要22版本参考Ubuntu下升级node.js从12.22到22.14_ubuntu升级node版本-CSDN博客
下载软件
wget https://nodejs.org/dist/v22.16.0/node-v22.16.0-linux-x64.tar.xz
解压
tar -xvf node-v22.16.0-linux-x64.tar.xz
把解压的目录放置到合适的位置比如放到tools目录 mv download/node-v22.16.0-linux-x64 tools/ 设定路径
export PATH/home/xx/tools/node-v22.16.0-linux-x64/bin:$PATH
把里面的xx改成自己的用户名。
现在就好了
node
Command node not found, but can be installed with:
sudo apt install nodejsexport PATH/home/xx/tools/node-v22.16.0-linux-x64/bin:$PATHnode -v
v22.16.0 安装node依赖
我们的infini-synapse是基于nodejs的需要node22以上同时需要安装pnpm.
npm install -g pnpm
初始化依赖 infinisynapse_release/infini-synapse$ pnpm i
输出东西不少啊
pnpm iWARN deprecated cache-manager-ioredis-yet2.1.2: With cache-manager v6 we now are using Keyv
Downloading typescript4.9.5: 11.62 MB/11.62 MB, doneWARN 6 deprecated subdependencies found: glob7.2.3, glob8.1.0, inflight1.0.6, node-domexception1.0.0, superagent8.1.2, vis4.21.0-EOL
Packages: 1556Progress: resolved 1604, reused 0, downloaded 1557, added 1556, done
node_modules/.pnpm/esbuild0.25.5/node_modules/esbuild: Running postinstall script...
node_modules/.pnpm/esbuild0.25.5/node_modules/esbuild: Running postinstall script, done in 193msstall script...
node_modules/.pnpm/javascript-obfuscator4.1.1/node_modules/javascript-obfuscator: Running postinstall script, done in 206ms_modules/.pnpm/msgpackr-extract3.0.3/node_modules/msgpackr-extract: Running install script...
node_modules/.pnpm/compodoccompodoc1.1.26_typescript5.5.4/node_modules/compodoc/compodoc: Running postinstall scripnode_modules/.pnpm/simple-git-hooks2.13.0/node_modules/simple-git-hooks: Running postinstall script, done in 587msscrip
t, done in 150ms
node_modules/.pnpm/unrs-resolver1.9.0/node_modules/unrs-resolver: Running postinstall script...
node_modules/.pnpm/unrs-resolver1.9.0/node_modules/unrs-resolver: Running postinstall script, done in 179ms2_re_qhjg4ju
node_modules/.pnpm/nestjscore10.4.19_nestjscommon10.4.19_class-transformer0.5.1_class-validator0.14.2_re_qhjg4juuyse6ray6ldaqf4sffe/node_modules/nestjs/core: Running postinstall script, done in 1.1sdependencies:anthropic-ai/bedrock-sdk 0.12.6 (0.22.1 is available)anthropic-ai/sdk 0.37.0 (0.54.0 is available)
......winston-daily-rotate-file 5.0.0zod 3.25.63devDependencies:antfu/eslint-config 3.16.0 (4.14.1 is available)compodoc/compodoc 1.1.26
.......typescript 5.5.4 (5.8.3 is available)webpack-obfuscator 3.5.1WARN Issues with peer dependencies found
.
└─┬ compodoc/compodoc 1.1.26└─┬ angular-devkit/schematics 18.2.8└─┬ angular-devkit/core 18.2.8└── ✕ unmet peer chokidar^3.5.2: found 4.0.3 in compodoc/compodocDone in 2m 6.8s 安装Auto-coder
source py312/bin/activate
uv pip install auto-coder# 若没有装uv就直接pip安装
pip install auto-coder
准备mysql和redis
修改.env.prod文件中的mysql和redis帐号密码同时创建库infinisynapse在这个库下执行 /infini-synapse/sql/ 目录中的脚本infini_synapse-init.sql
安装redis参考redis数据库的安装和简单连接Ubuntu22.04-CSDN博客
设置密码编辑配置文件/etc/redis/redis.conf
加入密码
requirepass infinisynapse
mysql
安装mysql参考
配置mysql
先登录数据库
sudo mysql创建数据库 -- 1. 创建数据库
CREATE DATABASE IF NOT EXISTS infinisynapse
CHARACTER SET utf8mb4
COLLATE utf8mb4_unicode_ci;-- 2. 创建用户MySQL 8.0语法
CREATE USER infinisynapseuser% IDENTIFIED BY infinisynapse123;-- 3. 授予读写权限包含所有表操作权限
GRANT SELECT, INSERT, UPDATE, DELETE, CREATE, ALTER, INDEX, DROP
ON infinisynapse.* TO infinisynapseuser%;-- 4. 刷新权限使设置生效
FLUSH PRIVILEGES;-- 验证用户权限可选
SHOW GRANTS FOR infinisynapseuser%;导入数据
use infinisynapse ;
source infini_synapse-init.sql;
我是在 infinisynapse_release/infini-synapse/sql 这个目录导入的所以没有写路径如果在其它目录导入需要写路径比如 source xxxx/infinisynapse_release/infini-synapse/sql/infini_synapse-init.sql ;
配置好后修改.env.prod文件中的mysql和redis帐号密码。
# 大家按照自己的需求更改
# db
DB_HOST 127.0.0.1
DB_PORT 13306
DB_DATABASE infinisynapse
DB_USERNAME root
DB_PASSWORD infinisynapse123
DB_SYNCHRONIZE true
DB_LOGGING [error]# redis
REDIS_PORT 16379
REDIS_HOST 127.0.0.1
REDIS_PASSWORD infinisynapse
REDIS_DB 0
我的实际情况是这样的
# 大家按照自己的需求更改
# db
DB_HOST 127.0.0.1
DB_PORT 3306
DB_DATABASE infinisynapse
DB_USERNAME infinisynapseuser
DB_PASSWORD infinisynapse123
DB_SYNCHRONIZE true
DB_LOGGING [error]# redis
REDIS_PORT 6379
REDIS_HOST 127.0.0.1
REDIS_PASSWORD infinisynapse
REDIS_DB 0
启动Infini-synapse
在 /infini-synapse/ 目录下执行
bash run.sh
启动成功
登录127.0.0.1:7001试试 登录后先把密码记一下 ID 参数名称keyvalue备注 更新时间 操作1初始密码sys_user_initPassword123456创建管理员账号的初始密码2023-11-10 00:31:44编辑删除2API Tokensys_api_tokennest-admin用于请求 ApiToken 的控制器2023-11-10 00:31:44编辑删除 进入InfiniSynapse 网站继续配置
登录127.0.0.1:7001进入InfiniSynapse 网站后继续配置。 配置llm api token信息 配置Infinity Engine 配置Infinity Engine
http://192.168.0.16:9003/
这个自动配置好了。 配置数据库 重新开机后的动作
已经部署成功再次开机只需要执行下面的命令
source py312/bin/activate
cd ~/download/infinisynapse_release/infini-sql/
# 设置java路径
export JAVA_HOME$(cd -P -- $(dirname -- $0) pwd -P)/jdk8
# 设置spark路径
export SPARK_HOME$(cd -P -- $(dirname -- $0) pwd -P)/spark
bash bin/byzer.sh startexport PATH/home/skywalk/tools/node-v22.16.0-linux-x64/bin:$PATH
cd ~/download/infinisynapse_release/infini-synapse/
bash run.sh InfiniSynapse Docker部署
文档Docker 版本部署 - 飞书云文档
从飞书下载 InfiniSynapse Docker镜像
加载InfiniSynapse Docker镜像
docker load -i infinisynapse_beta_0.0.5.tar
启动InfiniSynapse Docker镜像
docker run -it --rm -p 7001:7001 -p 9003:9003 infinisynapse_beta:v0.0.5
# 或
docker run -it --rm -p 7001:7001 -p 9003:9003 localhost/infinisynapse_beta:v0.0.5 启动后直接访问http://127.0.0.1:7001/
默认访问信息 MySQL 用户名: root MySQL 密码: infinisynapse123 Redis 无密码访问
可以进入docker系统里面看下
docker ps
CONTAINER ID IMAGE COMMAND CREATED STATUS PORTS NAMES
e0a8b5d797f9 localhost/infinisynapse_beta:v0.0.5 /app/start.sh 49 minutes ago Up 49 minutes 3306/tcp, 0.0.0.0:7001-7001/tcp, 6379/tcp, 0.0.0.0:9003-9003/tcp ecstatic_rhodesdocker exec -it e0a8b5d797f9 /bin/bash
比如看到了数据集路径在/app/infini-synapse/data/students_social_media_addiction.csv
配置测试数据集
/app/infini-synapse/data/students_social_media_addiction.csv
注意一定要写备注学生社交信息数据集
然后查询请根据学生社交信息数据集统计国内学生使用app的统计
如果找不到数据集请检查
1 路径有没有写错
2 备注是否写的清楚明白 我们来看看AI的工作真的很让人惊讶
请根据学生社交信息数据集统计国内学生使用app的统计该表包含 Country 字段可用于筛选国内学生Most_Used_Platform 字段很可能就是学生常用App或社交平台字段。统计国内学生Country中国或China等的Most_Used_Platform使用分布即可获得所需统计。
步骤如下过滤Country为中国/China的记录。
统计不同Most_Used_Platform即app名称的数量。
按Infinity SQL规范需先select数据为临时表再统计分组。下一步编写SQL完成上述操作。Autolyze wants to execute SQL queries
sql
复制代码
select * from students_social_media_addiction where Country in (中国, China, Mainland, CN) as domestic_students;
select Most_Used_Platform, count(*) as user_count from domestic_students group by Most_Used_Platform as app_usage_stats;已完成国内学生社交App使用情况的统计。结果如下WeChat15人使用
TikTok1人使用
并已为你生成“国内学生常用社交App统计”的柱状图直观展现各App的受欢迎程度。API Request
Task Completed
已对学生社交信息数据集中的国内学生进行了App使用统计。统计结果如下WeChat15人
TikTok1人
并已生成一张“国内学生常用社交App统计”的柱状图清晰展示国内学生最常用的社交App及使用人数分布。
真的让人佩服啊 调试
启动byzer报错{SPARK_HOME} is not set, exit
bash bin/byzer.sh start Starting Byzer engine... {SPARK_HOME} is not set, exit
也就是说需要设定这个环境变量
export SPARK_HOME$(cd -P -- $(dirname -- $0) pwd -P)/spark
java那块不对
自动执行install_jdk8.sh后没有得到想要的jdk8目录发现里面目录结构是MacOS的。
这里原来手册里讲ubuntu应该是/jdk8,我试下来应该是/jdk8/Contents/Home 所以当时设置路径也是按照/jdk8/Contents/Home设的但是还是报错。可不么Linux下用MacOS的软件最后当然是不通过了。
总感觉java那块有点不对劲看源码
cat install_jdk8.sh
#!/bin/bashset -e# Define ROOT_DIR if not set
ROOT_DIR${ROOT_DIR:-$(pwd)}
TEMP_DIR${ROOT_DIR}/tmplog() {echo $(date %Y-%m-%d %H:%M:%S) - $1
}log Creating temporary directory at ${TEMP_DIR}
mkdir -p $TEMP_DIR# Function to determine the OS type and architecture
detect_os() {if [[ $OSTYPE darwin* ]]; thencase $(uname -m) inx86_64) echo darwin-amd64 ;;arm64) echo darwin-arm64 ;;*)echo Unsupported architecture: $(uname -m)exit 1;;esacelif [[ $OSTYPE linux-gnu* ]]; thenecho linuxelif [[ $OSTYPE cygwin || $OSTYPE msys ]]; thenecho windowselseecho Unsupported OS type: $OSTYPEexit 1fi
}download_jdk8() {local os_type$1local target_dir${ROOT_DIR}# Create target directory if it doesnt existmkdir -p $target_dir# os_type设置为darwin-amd64os_typedarwin-amd64case $os_type indarwin-arm64)local jdk_filenamejdk8-darwin-arm64.tar.gzif [ ! -f $TEMP_DIR/$jdk_filename ]; thencurl -L https://corretto.aws/downloads/latest/amazon-corretto-8-aarch64-macos-jdk.tar.gz -o $TEMP_DIR/$jdk_filenameelseecho Using existing JDK8 download from $TEMP_DIR/$jdk_filenamefitar -xzf $TEMP_DIR/$jdk_filename -C $TEMP_DIRmv $TEMP_DIR/amazon-corretto-8.jdk $target_dir/jdk8rm -rf $TEMP_DIR;;darwin-amd64)local jdk_filenamejdk8-darwin-amd64.tar.gzif [ ! -f $TEMP_DIR/$jdk_filename ]; thencurl -L https://corretto.aws/downloads/latest/amazon-corretto-8-x64-macos-jdk.tar.gz -o $TEMP_DIR/$jdk_filenameelseecho Using existing JDK8 download from $TEMP_DIR/$jdk_filenamefitar -xzf $TEMP_DIR/$jdk_filename -C $TEMP_DIRmv $TEMP_DIR/amazon-corretto-8.jdk $target_dir/jdk8rm -rf $TEMP_DIR;;linux)if [ ! -f $TEMP_DIR/jdk8-linux.tar.gz ]; thencurl -L https://corretto.aws/downloads/latest/amazon-corretto-8-x64-linux-jdk.tar.gz -o $TEMP_DIR/jdk8-linux.tar.gzelseecho Using existing JDK8 download from $TEMP_DIR/jdk8-linux.tar.gzfitar -xzf $TEMP_DIR/jdk8-linux.tar.gz -C $TEMP_DIRmv $TEMP_DIR/amazon-corretto-8* $target_dir/jdk8rm -rf $TEMP_DIR;;windows)if [ ! -f $TEMP_DIR/jdk8-windows.zip ]; thencurl -L https://corretto.aws/downloads/latest/amazon-corretto-8-x64-windows-jdk.zip -o $TEMP_DIR/jdk8-windows.zipelseecho Using existing JDK8 download from $TEMP_DIR/jdk8-windows.zipfiunzip -q $TEMP_DIR/jdk8-windows.zip -d $TEMP_DIR# Windows JDK has a different directory structure, need to handle it differentlyif [ -d $TEMP_DIR/jdk1.8.0_432 ]; thenmv $TEMP_DIR/jdk1.8.0_432 $target_dir/jdk8else# Handle case where directory name might be differentmv $TEMP_DIR/jdk* $target_dir/jdk8firm -rf $TEMP_DIR;;*)echo Unsupported OS type: $os_typeexit 1;;esac
}setup_environment() {local os_type$(detect_os)log Setting up environment for ${os_type}# 下载并设置 JDKlog Downloading JDK for ${os_type}download_jdk8 $os_typelog JDK setup completed successfully at $ROOT_DIR/jdk8
}setup_environment
改成手工
下载文件
wget https://corretto.aws/downloads/latest/amazon-corretto-8-x64-linux-jdk.tar.gz
解压缩
tar -xzvf amazon-corretto-8-x64-linux-jdk.tar.gz
改名 mv amazon-corretto-8.452.09.1-linux-x64/ jdk8
问题解决
导入数据报错-bash: infini_synapse-init.sql: line 1: syntax error near unexpected token (
source infini_synapse-init.sql -bash: infini_synapse-init.sql: line 1: syntax error near unexpected token ( -bash: infini_synapse-init.sql: line 1: -- MySQL dump 10.13 Distrib 9.1.0, for macos14.7 (arm64)
在mysql里面进行导入操作 use infinisynapse ;
source infini_synapse-init.sql;
问题解决
报错Access denied for user infinisynapsuserlocalhost (using password: YES)
[Nest] 74896 - 06/13/2025, 5:33:51 AM ERROR [ExceptionHandler] Access denied for user infinisynapsuserlocalhost (using password: YES) Error: Access denied for user infinisynapsuserlocalhost (using password: YES)
拼写错误infinisynapsuser应该是infinisynapseuser
问题解决
网站报服务繁忙控制台显示ERROR [Catch] SyntaxError: Unexpected end of JSON input at async _0x5a73c0.postStateToWebview (/home/skywalk/download/infinisynapse_release/infini-synapse/dist/main.js:1:7097845) [Nest] 74912 - 06/13/2025, 5:49:08 AM ERROR [Catch] SyntaxError: Unexpected end of JSON input [Nest] 74912 - 06/13/2025, 5:49:14 AM ERROR [Catch] SyntaxError: Unexpected end of JSON input [Nest] 74912 - 06/13/2025, 5:49:18 AM ERROR [Catch] SyntaxError: Unexpected end of JSON input [Nest] 74912 - 06/13/2025, 5:49:28 AM ERROR [WsExceptionsHandler] Unexpected end of JSON input
[Nest] 74912 - 06/13/2025, 6:02:38 AM ERROR [WsExceptionsHandler] Unexpected end of JSON input
SyntaxError: Unexpected end of JSON inputat JSON.parse (anonymous)at /home/skywalk/download/infinisynapse_release/infini-synapse/dist/main.js:1:7115415at Object.TMsaZ (/home/skywalk/download/infinisynapse_release/infini-synapse/dist/main.js:1:95054)at Object.aFGfY (/home/skywalk/download/infinisynapse_release/infini-synapse/dist/main.js:1:3621773)at _0x136349.findValueByKey (/home/skywalk/download/infinisynapse_release/infini-synapse/dist/main.js:1:3670684)at process.processTicksAndRejections (node:internal/process/task_queues:105:5)at async Promise.all (index 20)at async _0x5a73c0.getState (/home/skywalk/download/infinisynapse_release/infini-synapse/dist/main.js:1:7107565)at async _0x5a73c0.getStateToPostToWebview (/home/skywalk/download/infinisynapse_release/infini-synapse/dist/main.js:1:7100118)at async _0x5a73c0.postStateToWebview (/home/skywalk/download/infinisynapse_release/infini-synapse/dist/main.js:1:7097845)
sse user-1已关闭
有人说引擎问题升级ws8.x
pnpm install ws8.xWARN deprecated cache-manager-ioredis-yet2.1.2: With cache-manager v6 we now are using KeyvWARN 6 deprecated subdependencies found: glob7.2.3, glob8.1.0, inflight1.0.6, node-domexception1.0.0, superagent8.1.2, vis4.21.0-EOL
Packages: 1 -1
-
Progress: resolved 1604, reused 1557, downloaded 0, added 1, donedependencies:ws 8.17.1 (8.18.2 is available)WARN Issues with peer dependencies found
.
├─┬ compodoc/compodoc 1.1.26
│ └─┬ angular-devkit/schematics 18.2.8
│ └─┬ angular-devkit/core 18.2.8
│ └── ✕ unmet peer chokidar^3.5.2: found 4.0.3 in compodoc/compodoc
└─┬ openai 4.104.0└── ✕ unmet peer ws^8.18.0: found 8.17.1Done in 15.4s
不行升级到8.18试试
pnpm install ws8.18 不行。
重启系统试试
重启也不行。
装docker临时解决了问题。但是在用了一会儿的情况下又出现这个问题....
在docker下刚开始正常用了一会儿后报错SyntaxError: Unexpected end of JSON input
[Nest] 464 - 06/13/2025, 3:50:44 PM ERROR [WsExceptionsHandler] Unexpected end of JSON input SyntaxError: Unexpected end of JSON input at JSON.parse (anonymous) at /app/infini-synapse/dist/main.js:1:7115415 at Object.TMsaZ (/app/infini-synapse/dist/main.js:1:95054) at Object.aFGfY (/app/infini-synapse/dist/main.js:1:3621773) at _0x136349.findValueByKey (/app/infini-synapse/dist/main.js:1:3670684) at process.processTicksAndRejections (node:internal/process/task_queues:105:5) at async Promise.all (index 20) at async _0x5a73c0.getState (/app/infini-synapse/dist/main.js:1:7107565) at async _0x5a73c0.getStateToPostToWebview (/app/infini-synapse/dist/main.js:1:7100118) at async _0x5a73c0.postStateToWebview (/app/infini-synapse/dist/main.js:1:7097845) [Nest] 464 - 06/13/2025, 3:50:51 PM ERROR [Catch] SyntaxError: Unexpected end of JSON input 问题未解决专门写文章留档超强人工智能解决方案套件InfiniSynapse 启动后出现报错ERROR [WsExceptionsHandler] Unexpected end of JSON input-CSDN博客
估计过两天就会有新版本解决问题。
