Quick BI中MySQL数据源，两段自定义SQL关联，抽取加速报错“sync error. java.sql.SQLException: errCode = 2, detailMessage = Syntax error in line 38: ... AS tmp ) count_sub_query ^ Encountered: EOF Expected”

【问题描述】

Quick BI中MySQL数据源，两段自定义SQL关联，抽取加速报错“sync error. java.sql.SQLException: errCode = 2, detailMessage = Syntax error in line 38: ... AS tmp ) count_sub_query ^ Encountered: EOF Expected”。

2024-06-12 15:03:55 [INFO] [manual] initialize job context, jobHistoryId:cb508262-43ce-45ed-a68f-ede676d353f0

2024-06-12 15:03:55 [INFO] start execute job.

2024-06-12 15:03:55 [INFO] start sync to quickindex...

2024-06-12 15:03:55 [INFO] [1/2] start to sync table [TS34696938]

2024-06-12 15:03:55 [INFO] sync begin. syncId-[40528861caa3458aad6069a7958e13d5]

2024-06-12 15:03:55 [INFO] data rows will be 186 after synchronization.

2024-06-12 15:04:05 [INFO] sync finished. costs [10,429] ms

2024-06-12 15:04:05 [INFO] [2/2] start to sync table [TS515420858]

2024-06-12 15:04:05 [INFO] sync begin. syncId-[1182e1e0236c4e46bbf978779179bb87]

2024-06-12 15:04:05 [ERROR] execute job failure.error message:

[QE5206002] sync error. [QE5206002] sync error. java.sql.SQLException: errCode = 2, detailMessage = Syntax error in line 38:

... AS tmp ) count_sub_query

^

Encountered: EOF

Expected

【解决方案】

抽取加速不支持占位符，把SQL里占位符相关的都删了，注释也需要删除。

【适用于】

Quick BI专业版