Hi
I am using simple rdf regex filters .
The query being evaluated is this:
SELECT * WHERE {
?pages <http://www.w3.org/2000/01/rdf-schema#label> ?labels .
FILTER (!regex(str(?pages),'^http://dbpedia.org/resource/Category:')).
FILTER (!regex(str(?pages), '^http://dbpedia.org/resource/List')).
?pages ?property ?objects .
}
Can you please provide me with some direction for using free text index
or pre-computed joins to perform free text search .
On Tuesday 06 September 2016 06:58 PM, Puja Valiyil wrote:
Hi Pranav,
I think this is likely due to the fact that filters are being evaluated client
side (so it's possible you are bringing back all 110 million triples multiple
times in your query). Can you send us your query so we can verify?
Sent from my iPhone
On Sep 6, 2016, at 8:49 AM, Meier, Caleb <caleb.me...@parsons.com> wrote:
Hey Pranav,
Even if the filtering is occurring client side, that is still strange behavior.
What does your query look like?
-----Original Message-----
From: pranav.puri [mailto:pranav.p...@orkash.com]
Sent: Monday, September 05, 2016 3:38 AM
To: dev@rya.incubator.apache.org
Subject: regarding slow query execution
Dear All
The query execution time for sparql queries with regex filters is much
more(10-12 minutes) as compared to queries with no filters applied.
The queries are being run on tables containing triples from dbpedia dataset.
Each table(ie Spo,osp,po) contains 110 million entries.I am currently using a
three node accumulo cluster.
Please suggest some ways to improve the query execution time .
Regards
Pranav
