Menu
▾
▴
Re: [Bigdata-developers] Problem while loading yago2s in Bigdata
|
From: Maria J. <mar...@gm...> - 2014-10-17 15:57:09
|
Dear Bryan, I have created a ticket with ticket number Ticket #1023 <http://trac.bigdata.com/ticket/1023> (new defect) and have assigned it to you. Sorry I did not get how to create unit test for this case, therefore did not create one. I contains the same example as provided by another user. The example is a small one, you may use it to load data and then query it using both old SPARQL and SPARQL*. Cheers, Maria On Fri, Oct 17, 2014 at 6:26 PM, Bryan Thompson <br...@sy...> wrote: > Can you create a ticket at Trac.bigdata.com and assign it to me. Include > the data, query, expected results, and the equivalent sparql query. The > best thing is to create a unit test. That will get the quickest turn around. > > Thanks, > Bryan > On Oct 17, 2014 12:43 PM, "Maria Jackson" <mar...@gm...> > wrote: > >> Sorry I forgot to mention I also feel SPARQL* is not giving the correct >> results. Although old SPARQL syntax gives the correct results. >> On Fri, Oct 17, 2014 at 4:12 PM, Maria Jackson < >> mar...@gm...> wrote: >> >>> Dear Bryan, >>> >>> I tried with the exact data and SPARQL and SPARQL* queries which another >>> user Jyoti mentions. >>> >>> The service description shows the following XML content, which I think >>> are in accordance wiki. Please correct me if I am wrong: >>> >>> <rdf:RDF><rdf:Description rdf:nodeID="service"><rdf:type rdf:resource=" >>> http://www.w3.org/ns/sparql-service-description#Service"/><endpoint >>> rdf:resource="http://12.18.1.5:9999/bigdata/namespace/test/sparql"/><endpoint >>> rdf:resource="http://12.18.1.5:9999/bigdata/LBS/namespace/test/sparql"/><supportedLanguage >>> rdf:resource=" >>> http://www.w3.org/ns/sparql-service-description#SPARQL10Query"/><supportedLanguage >>> rdf:resource=" >>> http://www.w3.org/ns/sparql-service-description#SPARQL11Query"/><supportedLanguage >>> rdf:resource=" >>> http://www.w3.org/ns/sparql-service-description#SPARQL11Update"/><feature >>> rdf:resource=" >>> http://www.w3.org/ns/sparql-service-description#BasicFederatedQuery"/><feature >>> rdf:resource="http://www.bigdata.com/rdf#/features/KB/Mode/Sids"/><feature >>> rdf:resource="http://www.bigdata.com/rdf#/features/KB/TruthMaintenance"/><inputFormat >>> rdf:resource="http://www.w3.org/ns/formats/RDF_XML"/><inputFormat >>> rdf:resource="http://www.w3.org/ns/formats/N-Triples"/><inputFormat >>> rdf:resource="http://www.w3.org/ns/formats/Turtle"/><inputFormat >>> rdf:resource="http://www.w3.org/ns/formats/N3"/><inputFormat >>> rdf:resource="http://www.wiwiss.fu-berlin.de/suhl/bizer/TriG/Spec/"/><inputFormat >>> rdf:resource="http://sw.deri.org/2008/07/n-quads/#n-quads"/><inputFormat >>> rdf:resource="http://www.w3.org/ns/formats/SPARQL_Results_XML"/><inputFormat >>> rdf:resource="http://www.w3.org/ns/formats/SPARQL_Results_JSON"/><inputFormat >>> rdf:resource="http://www.w3.org/ns/formats/SPARQL_Results_CSV"/><inputFormat >>> rdf:resource="http://www.w3.org/ns/formats/SPARQL_Results_TSV"/><resultFormat >>> rdf:resource="http://www.w3.org/ns/formats/RDF_XML"/><resultFormat >>> rdf:resource="http://www.w3.org/ns/formats/N-Triples"/><resultFormat >>> rdf:resource="http://www.w3.org/ns/formats/Turtle"/><resultFormat >>> rdf:resource="http://www.w3.org/ns/formats/N3"/><resultFormat >>> rdf:resource="http://www.wiwiss.fu-berlin.de/suhl/bizer/TriG/Spec/"/><resultFormat >>> rdf:resource="http://www.w3.org/ns/formats/SPARQL_Results_XML"/><resultFormat >>> rdf:resource="http://www.w3.org/ns/formats/SPARQL_Results_JSON"/><resultFormat >>> rdf:resource="http://www.w3.org/ns/formats/SPARQL_Results_CSV"/><resultFormat >>> rdf:resource="http://www.w3.org/ns/formats/SPARQL_Results_TSV"/><defaultDataset >>> rdf:nodeID="defaultDataset"/></rdf:Description><rdf:Description >>> rdf:nodeID="defaultDataset"><rdf:type rdf:resource=" >>> http://www.w3.org/ns/sparql-service-description#Dataset"/><rdf:type >>> rdf:resource="http://rdfs.org/ns/void#Dataset"/><title>test</title><Namespace>test</Namespace><sparqlEndpoint >>> rdf:resource=" >>> http://12.18.1.5:9999/bigdata/namespace/test/sparql/test/sparql"/><sparqlEndpoint >>> rdf:resource=" >>> http://12.18.1.5:9999/bigdata/LBS/namespace/test/sparql/test/sparql"/><uriRegexPattern>^.*</uriRegexPattern><vocabulary >>> rdf:resource="http://12.18.1.5:9999/bigdata/namespace/test/"/><vocabulary >>> rdf:resource="http://www.w3.org/1999/02/22-rdf-syntax-ns"/><defaultGraph >>> rdf:nodeID="defaultGraph"/></rdf:Description><rdf:Description >>> rdf:nodeID="defaultGraph"><rdf:type rdf:resource=" >>> http://www.w3.org/ns/sparql-service-description#Graph"/><triples >>> rdf:datatype="http://www.w3.org/2001/XMLSchema#long">5</triples><entities >>> rdf:datatype="http://www.w3.org/2001/XMLSchema#long">6</entities><properties >>> rdf:datatype="http://www.w3.org/2001/XMLSchema#int">5</properties><classes >>> rdf:datatype="http://www.w3.org/2001/XMLSchema#int">1</classes><propertyPartition >>> rdf:nodeID="node194eq34ovx1"/></rdf:Description><rdf:Description >>> rdf:nodeID="node194eq34ovx1"><property rdf:resource=" >>> http://192.168.1.50:9999/bigdata/namespace/test/said"/><triples >>> rdf:datatype="http://www.w3.org/2001/XMLSchema#long">1</triples></rdf:Description><rdf:Description >>> rdf:nodeID="defaultGraph"><propertyPartition >>> rdf:nodeID="node194eq34ovx2"/></rdf:Description><rdf:Description >>> rdf:nodeID="node194eq34ovx2"><property rdf:resource=" >>> http://www.w3.org/1999/02/22-rdf-syntax-ns#object"/><triples >>> rdf:datatype="http://www.w3.org/2001/XMLSchema#long">1</triples></rdf:Description><rdf:Description >>> rdf:nodeID="defaultGraph"><propertyPartition >>> rdf:nodeID="node194eq34ovx3"/></rdf:Description><rdf:Description >>> rdf:nodeID="node194eq34ovx3"><property rdf:resource=" >>> http://www.w3.org/1999/02/22-rdf-syntax-ns#predicate"/><triples >>> rdf:datatype="http://www.w3.org/2001/XMLSchema#long">1</triples></rdf:Description><rdf:Description >>> rdf:nodeID="defaultGraph"><propertyPartition >>> rdf:nodeID="node194eq34ovx4"/></rdf:Description><rdf:Description >>> rdf:nodeID="node194eq34ovx4"><property rdf:resource=" >>> http://www.w3.org/1999/02/22-rdf-syntax-ns#subject"/><triples >>> rdf:datatype="http://www.w3.org/2001/XMLSchema#long">1</triples></rdf:Description><rdf:Description >>> rdf:nodeID="defaultGraph"><propertyPartition >>> rdf:nodeID="node194eq34ovx5"/></rdf:Description><rdf:Description >>> rdf:nodeID="node194eq34ovx5"><property rdf:resource=" >>> http://www.w3.org/1999/02/22-rdf-syntax-ns#type"/><triples >>> rdf:datatype="http://www.w3.org/2001/XMLSchema#long">1</triples></rdf:Description><rdf:Description >>> rdf:nodeID="defaultGraph"><classPartition >>> rdf:nodeID="node194eq34ovx6"/></rdf:Description><rdf:Description >>> rdf:nodeID="node194eq34ovx6"><class rdf:resource=" >>> http://www.w3.org/1999/02/22-rdf-syntax-ns#Statement"/><triples >>> rdf:datatype="http://www.w3.org/2001/XMLSchema#long >>> ">1</triples></rdf:Description></rdf:RDF> >>> >>> On Thu, Oct 16, 2014 at 5:56 AM, Maria Jackson < >>> mar...@gm...> wrote: >>> >>>> Dear All, >>>> >>>> I am trying to load yago2s 18.5GB ( >>>> http://www.mpi-inf.mpg.de/departments/databases-and-information-systems/research/yago-naga/yago/downloads/ >>>> <https://contactmonkey.com/api/v1/tracker?cm_session=4d54369b-9f5b-4f3b-ae2d-5c05ba2939a0&cm_type=link&cm_link=36eb659b-7a36-459f-95da-e6d711aec4d0&cm_destination=http://www.mpi-inf.mpg.de/departments/databases-and-information-systems/research/yago-naga/yago/downloads/>) >>>> in Bigdata. I downloaded bigdata from http://www.bigdata.com/download >>>> <https://contactmonkey.com/api/v1/tracker?cm_session=4d54369b-9f5b-4f3b-ae2d-5c05ba2939a0&cm_type=link&cm_link=0b0bc5d8-f7fe-46b3-b416-31eb502201c4&cm_destination=http://www.bigdata.com/download> and >>>> I am using Bigdata workbench via http://localhost:9999. >>>> >>>> I am loading yago2s in BigData's default namespace "kb". I am loading >>>> yago2s using update by specifying the file path there. While Bigdata is >>>> loading yago I notice that it consumes a significant amount of CPU and RAM >>>> for 4-5 hours, but after that it stops using RAM. But my dilemma is that >>>> BigData workbench still keeps on showing "Running update.." although >>>> BigData does not consume any RAM or CPU for the next 48 hours or so (In >>>> fact it keeps showing "Running update.." until I kill the process). Can you >>>> please suggest as to where am I going wrong as after killing the process >>>> BigData is not able to retrieve any tuples (and shows 0 results even for >>>> the query select ?a?b?c where{?a ?b ?c}) >>>> >>>> >>>> Also I am using BigData on a server with 16 cores and 64 GB RAM? >>>> >>>> Any help in this regard will be deeply appreciated. >>>> >>>> Cheers, >>>> Maria >>>> >>> >>> >> |
