In Stardog Cloud, I am working on an altered demo based of the one here: https://cloud.stardog.com/kits/stardog:training-c360:1.0 I downloaded the data from the git repo and uploaded it to Azure and Databricks (more detail below). For the purposes of my demo, I'm using a simplified model: [image…

Jamie, As a follow-up, could you share your (modified to protect privacy) jbdb connection string, along with any ext. options that affect the driver? I'm particularly interested in two parts. In this example: jdbc.url=jdbc:databricks://adb-123456.azuredatabricks.net:443/default;UseNativeQuery=1;tr…

A successful query occurred a moment ago, the first: [image]

The situation continues: [image]

Hi Jamie, The only reasons I can imagine for the error occurring in Explorer but not Studio are: The SPARQL queries could be different somehow reasoning is enabled in Explorer but not Studio, or the active graphs are different The timeouts are different We do not make the Stardog log available…

Hi Paul, Thank you for your replies. I am still working on addressing your first post, but I can respond to your second post (i.e., jdbc connection string details): The current connector is a Simba Spark SQL connector (I used this because when building I was unable to get the Databricks Spark SQL …

In Stardog Designer, when attempting to connect to the Databricks Spark SQL database from the [0] connection details, an error populates: Problem querying data source: Data Source query failed: 'Databricks-C360-Demo-Database': Exception while executing a Data Source query. com.complexible.stardog.S…

That's really strange. I just did some tests and all your variations work for me: swapping endpoints for warehouses, treating AuthMech=3 as optional, semicolon at the end. In your tests it seems if the only thing you change is adding UseNativeQuery=1 it will not connect. I've never seen that. It's r…

Yes, it seems that adding the UseNativeQuery=1 causes the issue when altering the Databricks JDBC connection string. I repeated strings [1] and [2] from above a moment ago with the same result (i.e., including UseNativeQuery=1 plus including or excluding AuthMech=3 without other modifications to JDB…

Update - The queries worked appropriately if I host all the data on a Microsoft SQL Server and use the associated connector. Below are two example queries that routinely failed if data were accessed from a Databricks Spark SQL connector (in tandem with a Microsoft SQL server connector; I used both t…

Hi Jamie, sorry for the delay. I didn't get a notification for some reason that I'll investigate. When you say you are using cloud - are you referring to our cloud apps (Studio, Designer, etc) or the hosted service? IOW, where is Stardog running? I can't understand why the useNativeQuery option is …

Hi Paul, thanks for the feedback. I am using the Stardog Cloud service (i.e., browser interface tools) and, aside from the data tables stored elsewhere, all the content I use for these knowledge graphs is stored, accessed, and executed on Stardog Cloud. In terms of drivers: [1] For Databricks Spar…

Stardog Cloud (Explorer and Studio) - SPARQL query error

Stardog Cloud

PaulJackson (Paul Jackson) June 9, 2023, 10:40pm 15

Excellent. And did that resolve the cross join problem?

Databricks virtualized data query times questions

Topic		Replies	Views
Databricks virtualized data query times questions Stardog Cloud	1	363	June 27, 2023
SPARQL query on virtual graph Support	6	810	July 27, 2018
SPARQL Query Bug Bug	23	1385	June 17, 2021
Open Sparql-endpoint with Stardog Cloud Support	1	296	August 1, 2023
Trouble connecting to MSSQL Support	26	1966	April 23, 2019

Stardog Cloud (Explorer and Studio) - SPARQL query error

Related topics