sql - Databricks dashboard - Failed to execute query: Missing required fields - Stack Overflow

I am creating a databricks dashboard using a streaming delta live table. I am using an sql query to gen

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?

发布者:admin,转转请注明出处:http://www.yc00.com/questions/1745623566a4636667.html

相关推荐

发表回复

评论列表(0条)

  • 暂无评论

联系我们

400-800-8888

在线咨询: QQ交谈

邮件:admin@example.com

工作时间:周一至周五,9:30-18:30,节假日休息

关注微信