省略了很多数据集表格列名
SQL ERROR: Data conversion error converting “.”; SQL statement:
SELECT * FROM (SELECT “t_a_0”.“f_f018031135f52d09” AS “f_ax_0”, ROUND(CAST(AVG(CAST(“t_a_0”.“f_1f25a9a93325e8e4” AS DECIMAL(26, 8))) AS DECIMAL(26, 8)), 8) AS “f_ay_0”, ROUND(CAST(AVG(CAST(“t_a_0”.“f_44affad54d3c2840” AS DECIMAL(26, 8))) AS DECIMAL(26, 8)), 8) AS “f_ay_1”, ROUND(CAST(AVG(CAST(“t_a_0”.“f_993874b110e68fe0” AS DECIMAL(26, 8))) AS DECIMAL(26, 8)), 8) AS “f_ay_2”, ROUND(CAST(AVG(CAST(“t_a_0”.“f_a915cb945e81fc1a” AS DECIMAL(26, 8))) AS DECIMAL(26, 8)), 8) AS “f_ay_3”, ROUND(CAST(AVG(CAST(“t_a_0”.“f_5c34317e3e935327” AS DECIMAL(26, 8))) AS DECIMAL(26, 8)), 8) …
DEException(code=40001, msg=SQL ERROR: Data conversion error converting “.”; SQL statement:
SELECT * FROM (SELECT “t_a_0”.“f_f018031135f52d09” AS “f_ax_0”, ROUND(CAST(AVG(CAST(“t_a_0”.“f_1f25a9a93325e8e4” AS DECIMAL(26, 8))) AS DECIMAL(26, 8)), 8) AS…
at io.dataease.exception.DEException.throwException(DEException.java:38)
at io.dataease.datasource.provider.CalciteProvider.jdbcFetchResultField(CalciteProvider.java:443)
at io.dataease.datasource.provider.CalciteProvider.fetchResultField(CalciteProvider.java:158)
at io.dataease.chart.charts.impl.DefaultChartHandler.calcChartResult(DefaultChartHandler.java:122)
at io.dataease.chart.charts.impl.YoyChartHandler.calcChartResult(YoyChartHandler.java:79)
at io.dataease.chart.charts.impl.line.LineHandler.calcChartResult(LineHandler.java:58)
at io.dataease.chart.manage.ChartDataManage.calcData(ChartDataManage.java:404)
at io.dataease.chart.server.ChartDataServer.getData(ChartDataServer.java:92)
at java.base/jdk.internal.reflect.DirectMethodHandleAccessor.invoke(DirectMethodHandleAccessor.java:103)
at java.base/java.lang.reflect.Method.invoke(Method.java:580)
at org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:354)
at org.springframework.aop.framework.ReflectiveMethodInvocation.invokeJoinpoint(ReflectiveMethodInvocation.java:196)
at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:163)