search

SANSA-Stack / Archived-SANSA-Query

SANSA Query Layer
Apache License 2.0
31 stars 13 forks source link

FILTER in Sparql cannot match string with type transformation #15

Closed sui414 closed 4 years ago

sui414 commented 6 years ago

when filter string in sparql, I used regex() and str() to match the substring. it worked in GraphDB as follows:

image

When I try on SANSA query layer, it gave an error: image

The notebook is: https://dbc-c63f139d-39c4.cloud.databricks.com/#notebook/522/command/531 (command 7)

LorenzBuehmann commented 4 years ago

Is already covered in the Ontop-based SPARQL-to-SQL generator, so this works at least with Ontop.

Aklakan commented 4 years ago

Fixed an issue in the regex mapping for spark in sparqlify, so closing the issue. However, I don't know on which source datatype the string conversion is applied to, so maybe the opener's issue requires additional work on str(...) overload for that datatype - in that case just reopen the issue.