R2RML import

[PaulZH]

Having a R2RML mapping file that works in ontop version 1.18.0.1.

Using the same R2RML now in stardog I get:

 An error occurred adding RDF to the index: Ambiguous column name 'GemeenteID'.

I tried to figure out what is going on, but no success.

The stardog log file is attached. 

Paul

[Evren Sirin]

Does the SQL query in your mappings work as is for the RDBMS? Which
RDBMS are you using? Can you share your mappings or at least the SQL
query?

Best,
Evren

> --
> -- --
> You received this message because you are subscribed to the C&P "Stardog"
> group.
> To post to this group, send email to sta...@clarkparsia.com
> To unsubscribe from this group, send email to
> stardog+u...@clarkparsia.com
> For more options, visit this group at
> http://groups.google.com/a/clarkparsia.com/group/stardog?hl=en

[Zachary Whitley]

I ran into something similar a little while ago in a previous post [1]. There are a couple of links in there about quoting identifiers that might be helpful if you're running MySQL. It would be interesting to see if the solution that I came across works for you and you can verify that I'm not crazy. 

[1] https://groups.google.com/a/clarkparsia.com/forum/m/#!topic/stardog/ssZAn38Dw2w

--

-- --
You received this message because you are subscribed to the C&P "Stardog" group.
To post to this group, send email to sta...@clarkparsia.com
To unsubscribe from this group, send email to
stardog+u...@clarkparsia.com
For more options, visit this group at
http://groups.google.com/a/clarkparsia.com/group/stardog?hl=en

---
You received this message because you are subscribed to the Google Groups "Stardog" group.
To unsubscribe from this group and stop receiving emails from it, send an email to stardog+u...@clarkparsia.com.

<stardog.log>

[PaulZH]

Hi Zachary,

In our case it is MS SQL server, which has indeed some peculiarities as indicated in one of your links.

But the same R2RML file is working in -ontop-.

Anyhow Evren is having a look now (sent him all the info) and will keep us current.

[Evren Sirin]

For materialization we execute SQL queries in your mappings as-is.
Ontop always performs some preprocessing and serializes the query
string from the object representation. So even if your SQL database
cannot execute the SQL queries in your mappings the preprocessing
might work around that. So I'm guessing there might be some syntax
issue in the queries that MS SQL server doesn't like. We'll take a
look at the mappings and see if that is the issue.

Best,
Evren