Skip to content

[UC_COMMAND_NOT_SUPPORTED.WITHOUT_RECOMMENDATION] The command(s): AppendData are not supported in Unity Catalog. SQLSTATE: 0AKUC #45872

Open
@LoganPrasad

Description

@LoganPrasad

When I am trying to write data to Cosmos db from Azure databricks spark dataframe , it is giving the below errror:
[UC_COMMAND_NOT_SUPPORTED.WITHOUT_RECOMMENDATION] The command(s): AppendData are not supported
com.azure.cosmos.spark:azure-cosmos-spark_3-5_2-12:4.37.2
Do I need to disable the UC cluster settings for my AP cluster and read it from abfss path to push it to cosmos db
df=spark.sql(query)

Write data to Cosmos DB

df.write.format("cosmos.oltp")
.options(**cosmos_options)
.mode("append")
.save()

Metadata

Metadata

Assignees

No one assigned

    Labels

    ClientThis issue points to a problem in the data-plane of the library.CosmosService AttentionWorkflow: This issue is responsible by Azure service team.customer-reportedIssues that are reported by GitHub users external to the Azure organization.needs-team-attentionWorkflow: This issue needs attention from Azure service team or SDK teamquestionThe issue doesn't require a change to the product in order to be resolved. Most issues start as that

    Type

    No type

    Projects

    No projects

    Milestone

    No milestone

    Relationships

    None yet

    Development

    No branches or pull requests

    Issue actions