Quick BI数据集抽取加速报错“sync error. java.sql.SQLException: errCode = 2, detailMessage = Syntax error in line 95:... AS tmp ) count_sub_query^Encountered: EOF”

问题描述

Quick BI数据集抽取加速报错“sync error. java.sql.SQLException: errCode = 2, detailMessage = Syntax error in line 95:... AS tmp ) count_sub_query^Encountered: EOF”。完整的报错信息如下：

2025-07-08 10:32:51 [INFO] [manual] initialize job context, jobHistoryId:6dbb5d32-a68e-4295-872f-26db4a66651f
2025-07-08 10:32:51 [INFO] start execute job.
2025-07-08 10:32:51 [INFO] start sync to quickindex...
2025-07-08 10:32:51 [INFO] [1/2] start to sync table [TS561978481]
2025-07-08 10:32:51 [INFO] sync begin. syncId-[2dbd33013d654c5da90c6a97311f868f]
2025-07-08 10:32:51 [ERROR] execute job failure.error message:
[QE5206002] sync error. [QE5206002] sync error. java.sql.SQLException: errCode = 2, detailMessage = Syntax error in line 95:
... AS tmp ) count_sub_query
^
Encountered: EOF
Expected

问题原因

修改过生成数据集的SQL语句，给数据集SQL语句的最后一行加了注释导致。

解决方案

删除数据集SQL语句最后一行的注释语句，然后确认编辑，并保存数据集。再重新抽取加速，问题解决。

适用于

• Quick BI公有云专业版