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

admin管理员组

文章数量:1030926

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