原来正常,更新0.23.9后发现两个报错 #9828
Unanswered
WalkCharlie
asked this question in
Q&A
Replies: 1 comment
-
|
Beta Was this translation helpful? Give feedback.
0 replies
Sign up for free
to join this conversation on GitHub.
Already have an account?
Sign in to comment

Uh oh!
There was an error while loading. Please reload this page.
-
第一如上图
WITH
cte AS (
SELECT
*,
("A侧NOx预测值" - "A侧NOx真值") AS pred_err,
("B侧NOx预测值" - "B侧NOx真值") AS pred_err_b,
("A侧入口NOx折算值" - "A侧NOx真值") AS meas_err,
("B侧入口NOx折算值" - "B侧NOx真值") AS meas_err_b,
("A侧出口NOx折算值" - "A侧FGD出口NOx折算值") AS outlet_exit,
("B侧出口NOx折算值" - "B侧FGD出口NOx折算值") AS outlet_exit_b
FROM
query_table (CAST(tbl AS VARCHAR))
WHERE
(NOT isnan(COLUMNS ('NOx')))
)
SELECT
CAST("时刻" AS DATE) AS day_,
count_star() AS num_rows,
avg(abs(pred_err)) AS "预测值平均绝对误差",
avg(abs(pred_err_b)) AS "B侧预测值平均绝对误差",
avg(abs(meas_err)) AS "测量值平均绝对误差",
avg(abs(meas_err_b)) AS "B侧测量值平均绝对误差",
max(abs(pred_err)) AS "预测值最大误差",
max(abs(pred_err_b)) AS "B侧预测值最大误差",
max(abs(meas_err)) AS "测量值最大误差",
max(abs(meas_err_b)) AS "B侧测量值最大误差",
stddev("A侧入口NOx折算值") AS "脱硝入口NOx标准差",
stddev("B侧入口NOx折算值") AS "脱硝入口B侧NOx标准差",
stddev("A侧出口NOx折算值") AS "脱硝出口NOx标准差",
stddev("B侧出口NOx折算值") AS "脱硝出口B侧NOx标准差",
stddev("A侧FGD出口NOx折算值") AS "烟囱NOx标准差",
stddev("B侧FGD出口NOx折算值") AS "B侧FGD出口NOx标准差",
max(abs(outlet_exit)) AS "SCR出口NOx与烟囱差绝对值的最大值",
avg(abs(outlet_exit)) AS "SCR出口NOx与烟囱差绝对值的平均值",
max(abs(outlet_exit_b)) AS "SCR出口B侧NOx与烟囱差绝对值的最大值",
avg(abs(outlet_exit_b)) AS "SCR出口B侧NOx与烟囱差绝对值的平均值",
((countif ((outlet_exit > 0)) / count_star()) * 100) AS "SCR出口与烟囱NOx倒挂百分比",
((countif ((outlet_exit_b > 0)) / count_star()) * 100) AS "SCRB侧出口与烟囱NOx倒挂百分比"
FROM
cte
GROUP BY
day_
ORDER BY
day_
这句sql没问题呀,导入新数据在执行就报错;怎么会报SQL error
Binder Error: column "时刻" must appear in the GROUP BY clause or must be part of an aggregate function.
Either add it to the GROUP BY list, or use "ANY_VALUE(时刻)" if the exact value of "时刻" is not important.
下面的同样的错误WITH
cte AS (
SELECT
,
grade_load ("负荷") AS cats,
("A侧NOx预测值" - "A侧NOx真值") AS pred_err,
("B侧NOx预测值" - "B侧NOx真值") AS pred_err_b,
("A侧入口NOx折算值" - "A侧NOx真值") AS meas_err,
("B侧入口NOx折算值" - "B侧NOx真值") AS meas_err_b,
("A侧出口NOx折算值" - "A侧FGD出口NOx折算值") AS outlet_exit,
("B侧出口NOx折算值" - "B侧FGD出口NOx折算值") AS outlet_exit_b
FROM
query_table (CAST(tbl AS VARCHAR))
WHERE
(NOT isnan(COLUMNS ('NOx')))
)
SELECT
CAST("时刻" AS DATE) AS day_,
cats,
count_star() AS num_rows,
avg(abs(pred_err)) AS "预测值平均绝对误差",
avg(abs(pred_err_b)) AS "B侧预测值平均绝对误差",
avg(abs(meas_err)) AS "测量值平均绝对误差",
avg(abs(meas_err_b)) AS "B侧测量值平均绝对误差",
max(abs(pred_err)) AS "预测值最大误差",
max(abs(pred_err_b)) AS "B侧预测值最大误差",
max(abs(meas_err)) AS "测量值最大误差",
max(abs(meas_err_b)) AS "B侧测量值最大误差",
stddev("A侧入口NOx折算值") AS "脱硝入口NOx标准差",
stddev("B侧入口NOx折算值") AS "脱硝入口B侧NOx标准差",
stddev("A侧出口NOx折算值") AS "脱硝出口NOx标准差",
stddev("B侧出口NOx折算值") AS "脱硝出口B侧NOx标准差",
stddev("A侧FGD出口NOx折算值") AS "烟囱NOx标准差",
stddev("B侧FGD出口NOx折算值") AS "B侧FGD出口NOx标准差",
max(abs(outlet_exit)) AS "SCR出口NOx与烟囱差绝对值的最大值",
avg(abs(outlet_exit)) AS "SCR出口NOx与烟囱差绝对值的平均值",
max(abs(outlet_exit_b)) AS "SCR出口B侧NOx与烟囱差绝对值的最大值",
avg(abs(outlet_exit_b)) AS "SCR出口B侧NOx与烟囱差绝对值的平均值",
((countif ((outlet_exit > 0)) / count_star()) * 100) AS "SCR出口与烟囱NOx倒挂百分比",
((countif ((outlet_exit_b > 0)) / count_star()) * 100) AS "SCRB侧出口与烟囱NOx倒挂百分比"
FROM
cte
GROUP BY
GROUPING SETS ((), (day_), (day_, cats))
ORDER BY
COLUMNS ()
Beta Was this translation helpful? Give feedback.
All reactions