Databricks Community

pc · 02-01-2023

com.databricks.backend.common.rpc.DatabricksExceptions$SQLExecutionException: org.apache.spark.sql.AnalysisException: The query operator `UpdateCommandEdge` contains one or more unsupportedexpression types Aggregate, Window or Generate.Invalid expres...

pc · 02-02-2023

Spark version is 3.2.1

pc · 02-01-2023

update eds_us_lake_cdp.cdp_job_log set Average_Run = round(avg(Duration) OVER(partition by job_id ORDER BY Job_Start_Date_Time RANGE BETWEEN INTERVAL 29 DAY PRECEDING AND CURRENT ROW), 2)I have this query but it's thhrowing error. Anything we can do ...

pc · 02-01-2023

com.databricks.backend.common.rpc.DatabricksExceptions$SQLExecutionException: org.apache.spark.sql.AnalysisException:The query operator `UpdateCommandEdge` contains one or more unsupportedexpression types Aggregate, Window or Generate.Invalid express...

Databricks Community

User Stats

User Activity

Error in SQL statement: AnalysisException: The query operator `UpdateCommandEdge` contains one or more unsupported expression types Aggregate, Window or Generate.

Re: Error in SQL statement: AnalysisException: The query operator `UpdateCommandEdge` contains one or more unsupported expression types Aggregate, Window or Generate.

Re: Error in SQL statement: AnalysisException: The query operator `UpdateCommandEdge` contains one or more unsupported expression types Aggregate, Window or Generate.

Re: I am getting this error: com.databricks.backend.common.rpc.DatabricksExceptions$SQLExecutionException: com.databricks.rpc.UnknownRemoteException: Remote exception occurred: