永洪社区

标题: 为什么这个报告通过永洪云分享，双击笔刷联动会报错？ [打印本页]

作者: songwanyu 时间: 2023-5-10 17:11
标题: 为什么这个报告通过永洪云分享，双击笔刷联动会报错？

执行数据失败：Related Dashboard: '【年审看板】20230510170907-1397' Related Query: '年审明细' Related Element: '图表1' Run user: '15346_SaaS'
Caused by: java.sql.SQLException 执行SQL失败：“VooltDB exception, code: 386, host: 10.0.16.6, port: 18233; Code: 386. DB::Exception: There is no supertype for types String, Float64 because some of them are String/FixedString and some of them are not: while executing 'FUNCTION equals(年检剩余月份 : 0, 6. : 1) -> equals(年检剩余月份, 6.) Nullable(UInt8) : 2'. (NO_COMMON_TYPE) (version 22.3.2.1)(in query:SELECT "车牌号" AS "LONG_COL_0", "机动车状态" AS "LONG_COL_1", COUNT("序号") AS "LONG_COL_2" FROM "default"."qry_D6febdb22__4e9b8aa.年审明细" WHERE ( "年检剩余月份" = 6.0 ) AND ( ( "城市" = '深圳' ) AND ( "区域" = '华南' )) GROUP BY "LONG_COL_0", "LONG_COL_1" ORDER BY "LONG_COL_0" ASC COLLATE 'zh', "LONG_COL_1" ASC COLLATE 'zh' LIMIT 5000000 FORMAT TabSeparatedWithNamesAndTypes;)..
”

作者: Il.Mare 时间: 2023-5-10 17:22
稍等

作者: Il.Mare 时间: 2023-5-10 17:51
可以了，您这边再试下呢

作者: Il.Mare 时间: 2023-5-16 14:27
您好，为了方便排查问题，您这边方便导出jar出来吗？给您私聊了，您查看一下。

欢迎光临永洪社区 (http://club.yonghongtech.com/)