最新消息:Welcome to the puzzle paradise for programmers! Here, a well-designed puzzle awaits you. From code logic puzzles to algorithmic challenges, each level is closely centered on the programmer's expertise and skills. Whether you're a novice programmer or an experienced tech guru, you'll find your own challenges on this site. In the process of solving puzzles, you can not only exercise your thinking skills, but also deepen your understanding and application of programming knowledge. Come to start this puzzle journey full of wisdom and challenges, with many programmers to compete with each other and show your programming wisdom! Translated with DeepL.com (free version)

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

matteradmin6PV0评论

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?

Post a comment

comment list (0)

  1. No comments so far