Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

🐛 Columns are not extracted from [ rr:graphMap [ rr:template ] ] #57

Open
sroze opened this issue Oct 20, 2020 · 2 comments
Open

🐛 Columns are not extracted from [ rr:graphMap [ rr:template ] ] #57

sroze opened this issue Oct 20, 2020 · 2 comments
Assignees

Comments

@sroze
Copy link

sroze commented Oct 20, 2020

Hi there 👋 A found a small issue with graphMap.

Example

<#AnswersTriplesMap>
    # Note: we need to explicitly JOIN the assessments' table so that we can get `care_recipient_id` to
    #       generate the correct graph URI.
    rr:logicalTable [ rr:tableName "my_table" ];
    rr:subjectMap [
        rr:template "https://example.com/{identifier}";
        rr:graphMap [ rr:template "https://example.com/score/{customer_id}" ];
    ];

Expected result
The customer_id column is selected and the graph is set.

Actual result
The customer_id column is not selected and this leads to the following error:

[main] ERROR es.upm.fi.dia.oeg.morph.r2rml.rdb.engine.MorphRDBNodeGenerator - error occured when translating result: The column name V_71150_customer_id was not found in this ResultSet.

Workaround
There is one, yay! Using a predicateObjectMap to explicitly fetch customer_id make the graphMap work.

@dachafra dachafra self-assigned this Oct 20, 2020
@dachafra
Copy link
Member

@jatoledo could you take a look to the issue and test it with a simple example?
@sroze thanks for the feedback, I assume that would be impossible to have a piece of the data to test the system, but at least could you share with us what is the RDBMS you are using?

@sroze
Copy link
Author

sroze commented Oct 21, 2020

at least could you share with us what is the RDBMS you are using?

Yep, this is PostgreSQL 👍

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Projects
None yet
Development

No branches or pull requests

3 participants