Re: [Bigdata-developers] Problem while loading yago2s in Bigdata

[Bryan T. <br...@sy...>]

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
>>>
>>
>>
>