查询适用于Wikidata查询服务，但不适用于Apache Jena复制 [英] Query works on wikidata query service but not on Apache Jena copy

问题描述

以下查询是我的问题我的本地Wikidata副本上运行相同的查询 解决方案

@UninformedUser的测试查询:

PREFIX rdfs: <http://www.w3.org/2000/01/rdf-schema#>
PREFIX wd: <http://www.wikidata.org/entity/>
PREFIX wdt: <http://www.wikidata.org/prop/direct/>
PREFIX wikibase: <http://wikiba.se/ontology#>
PREFIX p: <http://www.wikidata.org/prop/>
PREFIX ps: <http://www.wikidata.org/prop/statement/>
PREFIX pq: <http://www.wikidata.org/prop/qualifier/>
SELECT ?country ?shortNameStmt ?shortName      WHERE      
{       
  VALUES ?country {wd:Q40} ?country wdt:P31 wd:Q3624078.              
  OPTIONAL {           
    ?country p:P1813 ?shortNameStmt.            
    ?shortNameStmt ps:P1813 ?shortName  filter (lang(?shortName) = "en")            
    filter not exists {?shortNameStmt pq:P31 wd:Q28840786}        
  }       
}

在基于事实的wikidata导入上进行最新全部导入时，未给出结果.完整查询也是如此.还是要知道为什么查询不能与真实数据集一起工作.

The query below is the accepted answer for my question Getting only english property value. When used on the Wikidata Query service try it! it will show shortNames for countries like Australia -> AUS and Austria -> AUT as requeted. Running the same query on my local Wikidata copy created a few weeks ago based on Apache Jena Fuseki the shortName column stays empty (see screenshot below).

What is the reason for the difference and how could the query be modified to also work with Apache Jena Fuseki?

    # get a list countries with the corresponding ISO code
    PREFIX rdfs: <http://www.w3.org/2000/01/rdf-schema#>
    PREFIX wd: <http://www.wikidata.org/entity/>
    PREFIX wdt: <http://www.wikidata.org/prop/direct/>
    PREFIX wikibase: <http://wikiba.se/ontology#>
    PREFIX p: <http://www.wikidata.org/prop/>
    PREFIX ps: <http://www.wikidata.org/prop/statement/>
    PREFIX pq: <http://www.wikidata.org/prop/qualifier/>
    SELECT ?country ?countryLabel ?shortName (MAX(?pop) as ?population) ?coord ?isocode
    WHERE 
    {
      # instance of country
      ?country wdt:P31 wd:Q3624078.
      OPTIONAL {
         ?country rdfs:label ?countryLabel filter (lang(?countryLabel) = "en").
       }
      OPTIONAL {
          ?country p:P1813 ?shortNameStmt. # get the short name statement
          ?shortNameStmt ps:P1813 ?shortName # the the short name value from the statement
          filter (lang(?shortName) = "en") # filter for English short names only
          filter not exists {?shortNameStmt pq:P31 wd:Q28840786} # ignore flags (aka emojis)
      }
      OPTIONAL { 
        # get the population
         # https://www.wikidata.org/wiki/Property:P1082
         ?country wdt:P1082 ?pop. 
      }
      # get the iso countryCode
      { ?country wdt:P297 ?isocode }.
      # get the coordinate
      OPTIONAL { ?country wdt:P625 ?coord }.
    } 
    GROUP BY ?country ?countryLabel ?shortName ?population ?coord ?isocode 
    ORDER BY ?countryLabel

解决方案

@UninformedUser's test query:

PREFIX rdfs: <http://www.w3.org/2000/01/rdf-schema#>
PREFIX wd: <http://www.wikidata.org/entity/>
PREFIX wdt: <http://www.wikidata.org/prop/direct/>
PREFIX wikibase: <http://wikiba.se/ontology#>
PREFIX p: <http://www.wikidata.org/prop/>
PREFIX ps: <http://www.wikidata.org/prop/statement/>
PREFIX pq: <http://www.wikidata.org/prop/qualifier/>
SELECT ?country ?shortNameStmt ?shortName      WHERE      
{       
  VALUES ?country {wd:Q40} ?country wdt:P31 wd:Q3624078.              
  OPTIONAL {           
    ?country p:P1813 ?shortNameStmt.            
    ?shortNameStmt ps:P1813 ?shortName  filter (lang(?shortName) = "en")            
    filter not exists {?shortNameStmt pq:P31 wd:Q28840786}        
  }       
}

Did not give a result on the truthy-based import of wikidata while it worked on the latest-all import. The same holds true for the full query. Still it would be good to know why the query does not work with the truthy dataset.

这篇关于查询适用于Wikidata查询服务，但不适用于Apache Jena复制的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！