FineBI数据集创建:报错,错误代码:62400001LogLabel 74174[SqlJDBCExecuteTemplate] 去掉as别名时可以执行,加上就报错。数据集SQL语句如下。 -- ================================================ -- Theme:数据更新监控 -- Description:数据更新任务表 -- Author:linjiaxi -- Create date:2022-06-28 -- ================================================ select countoverview as 各类型表更新情况 ,endtime as 任务结束时间 ,planid as 任务实例标识 ,roleid as 触发人ID ,rolename as 触发人名称 ,runningresult as 完成状态 ,starttime as 任务开始时间 ,statetype as 更新状态 ,taskname as 任务名称 ,triggerid as 触发ID from fine_update_task 但在mysql中可以执行: |