admin管理员组文章数量:1026989
I am creating a databricks dashboard using a streaming delta live table. I am using an sql query to generate the dashboard. The dashboard was working fine, but after some time, it stopped working and I am getting following error:
Failed to execute query: Missing required fields: queries.query_context.predicate_groups.predicates.expression.call_expr.args.call_expr.args.call_expr.function, queries.query_context.predicate_groups.predicates.expression.call_expr.args.call_expr.args.call_expr.function, queries.query_context.predicate_groups.predicates.expression.call_expr.args.call_expr.args.call_expr.function, queries.query_context.predicate_groups.predicates.expression.call_expr.args.call_expr.args.call_expr.function, queries.query_context.predicate_groups.predicates.expression.call_expr.args.call_expr.args.call_expr.function, queries.query_context.predicate_groups.predicates.expression.call_expr.args.call_expr.args.call_expr.function, queries.query_context.predicate_groups.predicates.expression.call_expr.args.call_expr.args.call_expr.function, queries.query_context.predicate_groups.predicates.expression.call_expr.args.call_expr.args.call_expr.function
I am running a simple SQL query for the data:
SELECT
EXTRACT(SECOND FROM col1-col2) AS diff_1,
EXTRACT(SECOND FROM col1-col3) AS diff_2
FROM
catalog.schema.table1;
I can run the SQL query in the Data
section and it is running fine. And if I create a new dashboard and use the same table, it is again working fine and data is displayed in dashboard. It is only in the existing dashboard where I am facing issues. Can someone help me why I have this error in the existing dashboard?
I am creating a databricks dashboard using a streaming delta live table. I am using an sql query to generate the dashboard. The dashboard was working fine, but after some time, it stopped working and I am getting following error:
Failed to execute query: Missing required fields: queries.query_context.predicate_groups.predicates.expression.call_expr.args.call_expr.args.call_expr.function, queries.query_context.predicate_groups.predicates.expression.call_expr.args.call_expr.args.call_expr.function, queries.query_context.predicate_groups.predicates.expression.call_expr.args.call_expr.args.call_expr.function, queries.query_context.predicate_groups.predicates.expression.call_expr.args.call_expr.args.call_expr.function, queries.query_context.predicate_groups.predicates.expression.call_expr.args.call_expr.args.call_expr.function, queries.query_context.predicate_groups.predicates.expression.call_expr.args.call_expr.args.call_expr.function, queries.query_context.predicate_groups.predicates.expression.call_expr.args.call_expr.args.call_expr.function, queries.query_context.predicate_groups.predicates.expression.call_expr.args.call_expr.args.call_expr.function
I am running a simple SQL query for the data:
SELECT
EXTRACT(SECOND FROM col1-col2) AS diff_1,
EXTRACT(SECOND FROM col1-col3) AS diff_2
FROM
catalog.schema.table1;
I can run the SQL query in the Data
section and it is running fine. And if I create a new dashboard and use the same table, it is again working fine and data is displayed in dashboard. It is only in the existing dashboard where I am facing issues. Can someone help me why I have this error in the existing dashboard?
本文标签: sqlDatabricks dashboardFailed to execute query Missing required fieldsStack Overflow
版权声明:本文标题:sql - Databricks dashboard - Failed to execute query: Missing required fields - Stack Overflow 内容由热心网友自发贡献,该文观点仅代表作者本人, 转载请联系作者并注明出处:http://it.en369.cn/questions/1745623565a2159722.html, 本站仅提供信息存储空间服务,不拥有所有权,不承担相关法律责任。如发现本站有涉嫌抄袭侵权/违法违规的内容,一经查实,本站将立刻删除。
发表评论