topic Re: Error when querying an XML table Databricks SQL Analytics in Warehousing & Analytics

Error when querying an XML table Databricks SQL Analytics

Bilal1 — Fri, 21 Mar 2025 11:40:15 GMT

I've created an external table that points to an XML file on the ADLS. I've installed spark-xml library on my cluster. I can query the table on the cluster.

However, I cannot query the table on Databricks SQL. I get the following error. I suppose the spark-xml library should also be installed on the SQL endpoint, however there is no option to do so. Is there any way to install the library on the end point ?

java.util.concurrent.ExecutionException: java.lang.ClassNotFoundException: Failed to find data source: com.databricks.spark.xml. Please find packages at http://spark.apache.org/third-party'. (35) (SQLExecDirectW)

Re: Error when querying an XML table Databricks SQL Analytics

Hubert-Dudek — Wed, 13 Oct 2021 15:48:02 GMT

Have you installed like that (in search packages find it in spark packages not maven)?

Re: Error when querying an XML table Databricks SQL Analytics

Anonymous — Wed, 13 Oct 2021 16:23:00 GMT

Hello @Bilal Haniff - My name is Piper and I'm a moderator for the community. It's nice to meet you!

Let's see how your fellow community members answer first and then the team will follow up if they need to.

Re: Error when querying an XML table Databricks SQL Analytics

Bilal1 — Thu, 14 Oct 2021 07:07:54 GMT

Yes. on the Cluster, however the SQL endpoint (cluster for Databricks SQL) does not offer this option.

Re: Error when querying an XML table Databricks SQL Analytics

Bilal1 — Fri, 15 Oct 2021 11:23:29 GMT

@Piper Wilson I believe this is a technical limitation of the platform (Databricks SQL). Can you please check with the team if this is the case?

Re: Error when querying an XML table Databricks SQL Analytics

Anonymous — Fri, 15 Oct 2021 16:26:13 GMT

@Bilal Haniff - Yes. It may be next week before I can get back to you. Thank you for your patience.