Hi Fabian, this one was easy: we forgot to implement the substring function. If you update from the GIT develop branch it should work now, can you have a try?
Greetings, Sebastian 2014-10-15 14:18 GMT+02:00 Sebastian Schaffert < sebastian.schaff...@gmail.com>: > Hi Fabian, > > DISTINCT is implemented. I need to have a look at the query to see why it > is not working in this case. My guess it is because of the BIND (which is > awkward to implement in SQL). I am in the middle of preparing for ISWC, so > I am not sure I will manage this week if the problem is more complex. :-S > > A good way to see WHY a SPARQL query is not working is to turn on debug > logging for SPARQL, add the debug log appender to SPARQL and then run the > query. The marmotta-debug.log file will then contain the SQL produced by > the SPARQL query. > > Greetings, > > Sebastian > > 2014-10-15 14:01 GMT+02:00 Fabian Cretton <fabian.cret...@hevs.ch>: > >> Hi, >> >> I thought DISTINCT was implemented, but it seems not ? >> >> This query gives back all results with duplicates: >> >> prefix qb: <http://purl.org/linked-data/cube#> >> prefix sdmx-dimension: <http://purl.org/linked-data/sdmx/2009/dimension#> >> SELECT DISTINCT ?year WHERE { >> ?obs a qb:Observation; >> sdmx-dimension:timePeriod ?timeStamp. >> BIND (SUBSTR(xsd:string(?timeStamp), 1, 4) AS ?year ) >> } >> >> (On Sesame-OWLIM it works fine) >> >> thanks for any advice >> Fabian >> > >
