Expression.Error: The field 'id' already exists in the record

Created by Steve Place, Modified on Mon, 30 Oct 2023 at 10:29 AM by Steve Place

The BI layer of Stardog autogenerates a column called "id" where it stores the IRI of the instance data. This means any user-defined "id" columns will be considered duplicates and cause this error. If you change your SQL schema to use something like sql:fieldName "realId" (or to just not use id's), the error will go away.

Was this article helpful?

That’s Great!

Thank you for your feedback

Sorry! We couldn't be helpful

Thank you for your feedback

Let us know how can we improve this article!

Select atleast one of the reasons
CAPTCHA verification is required.

Feedback sent

We appreciate your effort and will try to fix the article