Databricks Community

donlxz

When issuing a query from Informatica using a Delta connection, the statement use catalog_name.schema_name is executed first. At that time, the following error appeared in the query history:Query could not be scheduled: (conn=5073499)Deadlock found w...

donlxz

When creating materialized view with spark.sql function it returns following error message.[MATERIALIZED_VIEW_OPERATION_NOT_ALLOWED.MV_NOT_ENABLED] The materialized view operation CREATE is not allowed: Materialized view features are not enabled for ...

donlxz

I’ll try making adjustments on the Informatica side.Thank you for your help.

donlxz

Hi @ManojkMohan Thank you for your response.I understand that adjustments are needed on the Informatica side, and I’ll ask them to review the deadlock retry settings.Is there anything that can be changed or configured on the Databricks side to help w...

donlxz

Hi, @szymon_dybczak Thank you for your response.You're right, it was mentioned in the documentation—I missed it when checking.I understand now that it's not possible to do this with spark.sql. Thanks for clarifying!

Databricks Community

User Stats

User Activity

deadlock occurs with use statement

Error occurs on create materialized view with spark.sql

Re: deadlock occurs with use statement

Re: deadlock occurs with use statement

Re: Error occurs on create materialized view with spark.sql