Hi Can you please provide the actual steps to reproduce the issue being encountered as it is not clear from the information provided ?
Best Regards Hugh Williams Professional Services OpenLink Software, Inc. // http://www.openlinksw.com/ Weblog -- http://www.openlinksw.com/blogs/ LinkedIn -- http://www.linkedin.com/company/openlink-software/ Twitter -- http://twitter.com/OpenLink Google+ -- http://plus.google.com/100570109519069333827/ Facebook -- http://www.facebook.com/OpenLinkSoftware Universal Data Access, Integration, and Management Technology Providers > On 13 May 2017, at 18:01, Beppe Mazzola <beppemazz...@gmail.com> wrote: > > Hi to everybody > > I have generated with Virtuoso Open Source a virtual graph with the content > of many RDB tables.obtained with an R2RML mapping. > > If I execute the following query I do not get any result. > > select * > from<http://example.com/pesticides/resource > <http://example.com/pesticides/resource>> > where { > <http://example.com/pesticides/resource/annex-0 > <http://example.com/pesticides/resource/annex-0>> ?p ?o. > } > > but if I execute this query (I suppose without index because it takes many > seconds) > > select * > from<http://example.com/pesticides/resource > <http://example.com/pesticides/resource>> > where { > ?s ?p ?o filter regex(str(?s),'annex-0') . > } > > > I get the exact result, that is the content of the corresponding table row. > > http://example.com/pesticides/resource/annex-0 > <http://ec.europa.eu/semantic_webgate/dataset/pesticides/resource/annex-0>http:// > > <http://ec.europa.eu/semantic_webgate/dataset/pesticides/resource/annexId>example.com > > <http://ec.europa.eu/semantic_webgate/dataset/pesticides/resource/annex-0>/pesticides/resource/annexId > 0 > http://example.com/pesticides/resource/annex-0 > <http://ec.europa.eu/semantic_webgate/dataset/pesticides/resource/annex-0> > http:// > <http://ec.europa.eu/semantic_webgate/dataset/pesticides/resource/annexName>example.com > > <http://ec.europa.eu/semantic_webgate/dataset/pesticides/resource/annex-0>/pesticides/resource/annexName > Not Assigned > http://example.com/pesticides/resource/annex-0 > <http://ec.europa.eu/semantic_webgate/dataset/pesticides/resource/annex-0> > http:// > <http://ec.europa.eu/semantic_webgate/dataset/pesticides/resource/annexSpecial>example.com > > <http://ec.europa.eu/semantic_webgate/dataset/pesticides/resource/annex-0>/pesticides/resource/annexSpecial > 0 > http://example.com/pesticides/resource/annex-0 > <http://ec.europa.eu/semantic_webgate/dataset/pesticides/resource/annex-0> > http://www.w3.org/1999/02/22-rdf-syntax-ns#type > <http://www.w3.org/1999/02/22-rdf-syntax-ns#type>http:// > <http://ec.europa.eu/semantic_webgate/dataset/pesticides/resource/Annex>example.com > > <http://ec.europa.eu/semantic_webgate/dataset/pesticides/resource/annex-0>/pesticides/resource/Annex > > It looks like the index does not catch the triples.... This is the involved > R2RML mapping fragment > > <#TriplesMapANNEXES> a rr:TriplesMap; > rr:logicalTable [ > rr:tableSchema "DB" ; > rr:tableOwner "pest" ; > rr:tableName "ANNEXES" > ]; > rr:subjectMap [ > rr:termType rr:IRI ; > rr:template > "http://example.com/pesticides/resource/annex-{ANNEXES_ID} > <http://example.com/pesticides/resource/annex-{ANNEXES_ID}>"; > rr:class pest:Annex; > rr:graph <http://example.com > <http://example.com/>/pesticides/resource> ]; > rr:predicateObjectMap [ > rr:predicateMap [ > rr:constant pest:annexId ] ; > rr:objectMap [ > rr:column "ANNEXES_ID" ]; ] ; > rr:predicateObjectMap [ > rr:predicateMap [ > rr:constant pest:annexName ] ; > rr:objectMap [ > rr:column "ANNEXES_NAMES" ]; ] ; > rr:predicateObjectMap [ > rr:predicateMap [ > rr:constant pest:annexPart ] ; > rr:objectMap [ > rr:column "ANNEXES_PART" ]; ] ; > rr:predicateObjectMap [ > rr:predicateMap [ > rr:constant pest:annexSpecial ] ; > rr:objectMap [ > rr:column "ANNEXES_SPECIAL" ]; > ] . > > of the following Virtuoso table > > CREATE TABLE DB.PEST.ANNEXES > ( > ANNEXES_ID NUMERIC NOT NULL > , ANNEXES_NAMES VARCHAR(50) NOT NULL > , ANNEXES_PART VARCHAR(1) > , ANNEXES_SPECIAL CHAR(1) NOT NULL > , CONSTRAINT PK_ANNEXES PRIMARY KEY (ANNEXES_ID ) > ); > > Had anyone a similar experience? Any hint? > > Thanks! > > Cheers > > Beppe > > > > > ------------------------------------------------------------------------------ > Check out the vibrant tech community on one of the world's most > engaging tech sites, Slashdot.org! > http://sdm.link/slashdot_______________________________________________ > Virtuoso-users mailing list > Virtuoso-users@lists.sourceforge.net > https://lists.sourceforge.net/lists/listinfo/virtuoso-users
smime.p7s
Description: S/MIME cryptographic signature
------------------------------------------------------------------------------ Check out the vibrant tech community on one of the world's most engaging tech sites, Slashdot.org! http://sdm.link/slashdot
_______________________________________________ Virtuoso-users mailing list Virtuoso-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/virtuoso-users
