You are viewing a plain text version of this content. The canonical link for it is here.
Posted to users@jena.apache.org by José Luis Larroque <la...@gmail.com> on 2014/03/09 03:07:35 UTC
A query with an OR "smaller" doesn't work, but the same OR "bigger" does!
This query doesn't work:
PREFIX dc: <http://purl.org/dc/terms/>PREFIX movie: <
http://data.linkedmdb.org/resource/movie/>SELECT ?titulo ?id ?fecha WHERE{
?movie movie:actor ?actor .?movie dc:title ?titulo . ?movie dc:date
?fecha.?movie movie:filmid ?id .FILTER( ?actor = <
http://data.linkedmdb.org/resource/actor/30711> || ?actor = <
http://data.linkedmdb.org/resource/actor/31259> || ?actor = <
http://data.linkedmdb.org/resource/actor/29536> || ?actor = <
http://data.linkedmdb.org/resource/actor/30485> || ?actor = <
http://data.linkedmdb.org/resource/actor/31204> || ?actor = <
http://data.linkedmdb.org/resource/actor/29852>)}
But this one, does:
PREFIX dc: <http://purl.org/dc/terms/>PREFIX movie: <
http://data.linkedmdb.org/resource/movie/>SELECT ?titulo ?id ?fecha WHERE{
?movie movie:actor ?actor .?movie dc:title ?titulo . ?movie dc:date
?fecha.?movie movie:filmid ?id .FILTER( ?actor = <
http://data.linkedmdb.org/resource/actor/68186> || ?actor = <
http://data.linkedmdb.org/resource/actor/9547> || ?actor = <
http://data.linkedmdb.org/resource/actor/570> || ?actor = <
http://data.linkedmdb.org/resource/actor/38579> || ?actor = <
http://data.linkedmdb.org/resource/actor/9546> || ?actor = <
http://data.linkedmdb.org/resource/actor/31700> || ?actor = <
http://data.linkedmdb.org/resource/actor/35706> || ?actor = <
http://data.linkedmdb.org/resource/actor/42962> || ?actor = <
http://data.linkedmdb.org/resource/actor/45825> || ?actor = <
http://data.linkedmdb.org/resource/actor/35702> || ?actor = <
http://data.linkedmdb.org/resource/actor/30922> || ?actor = <
http://data.linkedmdb.org/resource/actor/37416> || ?actor = <
http://data.linkedmdb.org/resource/actor/55943> || ?actor = <
http://data.linkedmdb.org/resource/actor/36078> || ?actor = <
http://data.linkedmdb.org/resource/actor/34357> || ?actor = <
http://data.linkedmdb.org/resource/actor/30535> || ?actor = <
http://data.linkedmdb.org/resource/actor/37983> || ?actor = <
http://data.linkedmdb.org/resource/actor/29961> || ?actor = <
http://data.linkedmdb.org/resource/actor/9332> || ?actor = <
http://data.linkedmdb.org/resource/actor/30532> || ?actor = <
http://data.linkedmdb.org/resource/actor/29959> || ?actor = <
http://data.linkedmdb.org/resource/actor/30723> || ?actor = <
http://data.linkedmdb.org/resource/actor/36453> || ?actor = <
http://data.linkedmdb.org/resource/actor/30913> || ?actor = <
http://data.linkedmdb.org/resource/actor/31101> || ?actor = <
http://data.linkedmdb.org/resource/actor/38167> || ?actor = <
http://data.linkedmdb.org/resource/actor/31099> || ?actor = <
http://data.linkedmdb.org/resource/actor/33199> || ?actor = <
http://data.linkedmdb.org/resource/actor/30715> || ?actor = <
http://data.linkedmdb.org/resource/actor/40456> || ?actor = <
http://data.linkedmdb.org/resource/actor/46372> || ?actor = <
http://data.linkedmdb.org/resource/actor/38156> || ?actor = <
http://data.linkedmdb.org/resource/actor/42356> || ?actor = <
http://data.linkedmdb.org/resource/actor/32996> || ?actor = <
http://data.linkedmdb.org/resource/actor/62792> || ?actor = <
http://data.linkedmdb.org/resource/actor/37770> || ?actor = <
http://data.linkedmdb.org/resource/actor/62790> || ?actor = <
http://data.linkedmdb.org/resource/actor/34712> || ?actor = <
http://data.linkedmdb.org/resource/actor/41397> || ?actor = <
http://data.linkedmdb.org/resource/actor/331> || ?actor = <
http://data.linkedmdb.org/resource/actor/37956> || ?actor = <
http://data.linkedmdb.org/resource/actor/37765> || ?actor = <
http://data.linkedmdb.org/resource/actor/44446> || ?actor = <
http://data.linkedmdb.org/resource/actor/31454> || ?actor = <
http://data.linkedmdb.org/resource/actor/55137> || ?actor = <
http://data.linkedmdb.org/resource/actor/46350> || ?actor = <
http://data.linkedmdb.org/resource/actor/33169> || ?actor = <
http://data.linkedmdb.org/resource/actor/44817> || ?actor = <
http://data.linkedmdb.org/resource/actor/31827> || ?actor = <
http://data.linkedmdb.org/resource/actor/34309> || ?actor = <
http://data.linkedmdb.org/resource/actor/37743> || ?actor = <
http://data.linkedmdb.org/resource/actor/29718> || ?actor = <
http://data.linkedmdb.org/resource/actor/35257> || ?actor = <
http://data.linkedmdb.org/resource/actor/34492> || ?actor = <
http://data.linkedmdb.org/resource/actor/301> || ?actor = <
http://data.linkedmdb.org/resource/actor/37927> || ?actor = <
http://data.linkedmdb.org/resource/actor/10994> || ?actor = <
http://data.linkedmdb.org/resource/actor/30857> || ?actor = <
http://data.linkedmdb.org/resource/actor/31047> || ?actor = <
http://data.linkedmdb.org/resource/actor/31810> || ?actor = <
http://data.linkedmdb.org/resource/actor/31997> || ?actor = <
http://data.linkedmdb.org/resource/actor/50332> || ?actor = <
http://data.linkedmdb.org/resource/actor/29512> || ?actor = <
http://data.linkedmdb.org/resource/actor/31421> || ?actor = <
http://data.linkedmdb.org/resource/actor/33712> || ?actor = <
http://data.linkedmdb.org/resource/actor/859> || ?actor = <
http://data.linkedmdb.org/resource/actor/31790> || ?actor = <
http://data.linkedmdb.org/resource/actor/29689> || ?actor = <
http://data.linkedmdb.org/resource/actor/36564> || ?actor = <
http://data.linkedmdb.org/resource/actor/34270> || ?actor = <
http://data.linkedmdb.org/resource/actor/36752> || ?actor = <
http://data.linkedmdb.org/resource/actor/50122> || ?actor = <
http://data.linkedmdb.org/resource/actor/36553> || ?actor = <
http://data.linkedmdb.org/resource/actor/37316> || ?actor = <
http://data.linkedmdb.org/resource/actor/32730> || ?actor = <
http://data.linkedmdb.org/resource/actor/29865> || ?actor = <
http://data.linkedmdb.org/resource/actor/1215> || ?actor = <
http://data.linkedmdb.org/resource/actor/29864> || ?actor = <
http://data.linkedmdb.org/resource/actor/33492> || ?actor = <
http://data.linkedmdb.org/resource/actor/39604> || ?actor = <
http://data.linkedmdb.org/resource/actor/31581> || ?actor = <
http://data.linkedmdb.org/resource/actor/65000> || ?actor = <
http://data.linkedmdb.org/resource/actor/31193> || ?actor = <
http://data.linkedmdb.org/resource/actor/64999> || ?actor = <
http://data.linkedmdb.org/resource/actor/40168> || ?actor = <
http://data.linkedmdb.org/resource/actor/45898> || ?actor = <
http://data.linkedmdb.org/resource/actor/64998> || ?actor = <
http://data.linkedmdb.org/resource/actor/29851> || ?actor = <
http://data.linkedmdb.org/resource/actor/37681> || ?actor = <
http://data.linkedmdb.org/resource/actor/37680> || ?actor = <
http://data.linkedmdb.org/resource/actor/51> || ?actor = <
http://data.linkedmdb.org/resource/actor/34430> || ?actor = <
http://data.linkedmdb.org/resource/actor/30610> || ?actor = <
http://data.linkedmdb.org/resource/actor/31565> || ?actor = <
http://data.linkedmdb.org/resource/actor/41305> || ?actor = <
http://data.linkedmdb.org/resource/actor/10362> || ?actor = <
http://data.linkedmdb.org/resource/actor/10361> || ?actor = <
http://data.linkedmdb.org/resource/actor/43399> || ?actor = <
http://data.linkedmdb.org/resource/actor/43398> || ?actor = <
http://data.linkedmdb.org/resource/actor/39> || ?actor = <
http://data.linkedmdb.org/resource/actor/41867> || ?actor = <
http://data.linkedmdb.org/resource/actor/34989> || ?actor = <
http://data.linkedmdb.org/resource/actor/31932> || ?actor = <
http://data.linkedmdb.org/resource/actor/31549> || ?actor = <
http://data.linkedmdb.org/resource/actor/34222> || ?actor = <
http://data.linkedmdb.org/resource/actor/38614> || ?actor = <
http://data.linkedmdb.org/resource/actor/32501> || ?actor = <
http://data.linkedmdb.org/resource/actor/37650> || ?actor = <
http://data.linkedmdb.org/resource/actor/32108> || ?actor = <
http://data.linkedmdb.org/resource/actor/30769> || ?actor = <
http://data.linkedmdb.org/resource/actor/31914> || ?actor = <
http://data.linkedmdb.org/resource/actor/43558> || ?actor = <
http://data.linkedmdb.org/resource/actor/38396> || ?actor = <
http://data.linkedmdb.org/resource/actor/32093> || ?actor = <
http://data.linkedmdb.org/resource/actor/30373> || ?actor = <
http://data.linkedmdb.org/resource/actor/33046> || ?actor = <
http://data.linkedmdb.org/resource/actor/60548> || ?actor = <
http://data.linkedmdb.org/resource/actor/32661>)}
The only difference between both, are the size, because both are almost
identical, with the exception that the second has a OR more bigger.
Both are code-generated querys, and the second query can't be tested
against the sparql dbpedia endpoint, because it's too big. Using jena
framework against the dbpedia enpoint, works like a charm, but not the
first one. Any idea why?
Jose
Re: A query with an OR "smaller" doesn't work, but the same OR
"bigger" does!
Posted by Martynas Jusevičius <ma...@graphity.org>.
Jose, sorry can't help with your question - just wanted to let you know that
FILTER (?actor IN (<http://data.linkedmdb.org/resource/actor/30711>, ...))
is a shorter version of the same expression, in case you were not aware:
http://www.w3.org/TR/sparql11-query/#func-in
Are you implementing faceted search by a chance? :)
Martynas
graphityhq.com
On Sun, Mar 9, 2014 at 3:07 AM, José Luis Larroque
<la...@gmail.com> wrote:
> This query doesn't work:
> PREFIX dc: <http://purl.org/dc/terms/>PREFIX movie: <
> http://data.linkedmdb.org/resource/movie/>SELECT ?titulo ?id ?fecha WHERE{
> ?movie movie:actor ?actor .?movie dc:title ?titulo . ?movie dc:date
> ?fecha.?movie movie:filmid ?id .FILTER( ?actor = <
> http://data.linkedmdb.org/resource/actor/30711> || ?actor = <
> http://data.linkedmdb.org/resource/actor/31259> || ?actor = <
> http://data.linkedmdb.org/resource/actor/29536> || ?actor = <
> http://data.linkedmdb.org/resource/actor/30485> || ?actor = <
> http://data.linkedmdb.org/resource/actor/31204> || ?actor = <
> http://data.linkedmdb.org/resource/actor/29852>)}
>
> But this one, does:
> PREFIX dc: <http://purl.org/dc/terms/>PREFIX movie: <
> http://data.linkedmdb.org/resource/movie/>SELECT ?titulo ?id ?fecha WHERE{
> ?movie movie:actor ?actor .?movie dc:title ?titulo . ?movie dc:date
> ?fecha.?movie movie:filmid ?id .FILTER( ?actor = <
> http://data.linkedmdb.org/resource/actor/68186> || ?actor = <
> http://data.linkedmdb.org/resource/actor/9547> || ?actor = <
> http://data.linkedmdb.org/resource/actor/570> || ?actor = <
> http://data.linkedmdb.org/resource/actor/38579> || ?actor = <
> http://data.linkedmdb.org/resource/actor/9546> || ?actor = <
> http://data.linkedmdb.org/resource/actor/31700> || ?actor = <
> http://data.linkedmdb.org/resource/actor/35706> || ?actor = <
> http://data.linkedmdb.org/resource/actor/42962> || ?actor = <
> http://data.linkedmdb.org/resource/actor/45825> || ?actor = <
> http://data.linkedmdb.org/resource/actor/35702> || ?actor = <
> http://data.linkedmdb.org/resource/actor/30922> || ?actor = <
> http://data.linkedmdb.org/resource/actor/37416> || ?actor = <
> http://data.linkedmdb.org/resource/actor/55943> || ?actor = <
> http://data.linkedmdb.org/resource/actor/36078> || ?actor = <
> http://data.linkedmdb.org/resource/actor/34357> || ?actor = <
> http://data.linkedmdb.org/resource/actor/30535> || ?actor = <
> http://data.linkedmdb.org/resource/actor/37983> || ?actor = <
> http://data.linkedmdb.org/resource/actor/29961> || ?actor = <
> http://data.linkedmdb.org/resource/actor/9332> || ?actor = <
> http://data.linkedmdb.org/resource/actor/30532> || ?actor = <
> http://data.linkedmdb.org/resource/actor/29959> || ?actor = <
> http://data.linkedmdb.org/resource/actor/30723> || ?actor = <
> http://data.linkedmdb.org/resource/actor/36453> || ?actor = <
> http://data.linkedmdb.org/resource/actor/30913> || ?actor = <
> http://data.linkedmdb.org/resource/actor/31101> || ?actor = <
> http://data.linkedmdb.org/resource/actor/38167> || ?actor = <
> http://data.linkedmdb.org/resource/actor/31099> || ?actor = <
> http://data.linkedmdb.org/resource/actor/33199> || ?actor = <
> http://data.linkedmdb.org/resource/actor/30715> || ?actor = <
> http://data.linkedmdb.org/resource/actor/40456> || ?actor = <
> http://data.linkedmdb.org/resource/actor/46372> || ?actor = <
> http://data.linkedmdb.org/resource/actor/38156> || ?actor = <
> http://data.linkedmdb.org/resource/actor/42356> || ?actor = <
> http://data.linkedmdb.org/resource/actor/32996> || ?actor = <
> http://data.linkedmdb.org/resource/actor/62792> || ?actor = <
> http://data.linkedmdb.org/resource/actor/37770> || ?actor = <
> http://data.linkedmdb.org/resource/actor/62790> || ?actor = <
> http://data.linkedmdb.org/resource/actor/34712> || ?actor = <
> http://data.linkedmdb.org/resource/actor/41397> || ?actor = <
> http://data.linkedmdb.org/resource/actor/331> || ?actor = <
> http://data.linkedmdb.org/resource/actor/37956> || ?actor = <
> http://data.linkedmdb.org/resource/actor/37765> || ?actor = <
> http://data.linkedmdb.org/resource/actor/44446> || ?actor = <
> http://data.linkedmdb.org/resource/actor/31454> || ?actor = <
> http://data.linkedmdb.org/resource/actor/55137> || ?actor = <
> http://data.linkedmdb.org/resource/actor/46350> || ?actor = <
> http://data.linkedmdb.org/resource/actor/33169> || ?actor = <
> http://data.linkedmdb.org/resource/actor/44817> || ?actor = <
> http://data.linkedmdb.org/resource/actor/31827> || ?actor = <
> http://data.linkedmdb.org/resource/actor/34309> || ?actor = <
> http://data.linkedmdb.org/resource/actor/37743> || ?actor = <
> http://data.linkedmdb.org/resource/actor/29718> || ?actor = <
> http://data.linkedmdb.org/resource/actor/35257> || ?actor = <
> http://data.linkedmdb.org/resource/actor/34492> || ?actor = <
> http://data.linkedmdb.org/resource/actor/301> || ?actor = <
> http://data.linkedmdb.org/resource/actor/37927> || ?actor = <
> http://data.linkedmdb.org/resource/actor/10994> || ?actor = <
> http://data.linkedmdb.org/resource/actor/30857> || ?actor = <
> http://data.linkedmdb.org/resource/actor/31047> || ?actor = <
> http://data.linkedmdb.org/resource/actor/31810> || ?actor = <
> http://data.linkedmdb.org/resource/actor/31997> || ?actor = <
> http://data.linkedmdb.org/resource/actor/50332> || ?actor = <
> http://data.linkedmdb.org/resource/actor/29512> || ?actor = <
> http://data.linkedmdb.org/resource/actor/31421> || ?actor = <
> http://data.linkedmdb.org/resource/actor/33712> || ?actor = <
> http://data.linkedmdb.org/resource/actor/859> || ?actor = <
> http://data.linkedmdb.org/resource/actor/31790> || ?actor = <
> http://data.linkedmdb.org/resource/actor/29689> || ?actor = <
> http://data.linkedmdb.org/resource/actor/36564> || ?actor = <
> http://data.linkedmdb.org/resource/actor/34270> || ?actor = <
> http://data.linkedmdb.org/resource/actor/36752> || ?actor = <
> http://data.linkedmdb.org/resource/actor/50122> || ?actor = <
> http://data.linkedmdb.org/resource/actor/36553> || ?actor = <
> http://data.linkedmdb.org/resource/actor/37316> || ?actor = <
> http://data.linkedmdb.org/resource/actor/32730> || ?actor = <
> http://data.linkedmdb.org/resource/actor/29865> || ?actor = <
> http://data.linkedmdb.org/resource/actor/1215> || ?actor = <
> http://data.linkedmdb.org/resource/actor/29864> || ?actor = <
> http://data.linkedmdb.org/resource/actor/33492> || ?actor = <
> http://data.linkedmdb.org/resource/actor/39604> || ?actor = <
> http://data.linkedmdb.org/resource/actor/31581> || ?actor = <
> http://data.linkedmdb.org/resource/actor/65000> || ?actor = <
> http://data.linkedmdb.org/resource/actor/31193> || ?actor = <
> http://data.linkedmdb.org/resource/actor/64999> || ?actor = <
> http://data.linkedmdb.org/resource/actor/40168> || ?actor = <
> http://data.linkedmdb.org/resource/actor/45898> || ?actor = <
> http://data.linkedmdb.org/resource/actor/64998> || ?actor = <
> http://data.linkedmdb.org/resource/actor/29851> || ?actor = <
> http://data.linkedmdb.org/resource/actor/37681> || ?actor = <
> http://data.linkedmdb.org/resource/actor/37680> || ?actor = <
> http://data.linkedmdb.org/resource/actor/51> || ?actor = <
> http://data.linkedmdb.org/resource/actor/34430> || ?actor = <
> http://data.linkedmdb.org/resource/actor/30610> || ?actor = <
> http://data.linkedmdb.org/resource/actor/31565> || ?actor = <
> http://data.linkedmdb.org/resource/actor/41305> || ?actor = <
> http://data.linkedmdb.org/resource/actor/10362> || ?actor = <
> http://data.linkedmdb.org/resource/actor/10361> || ?actor = <
> http://data.linkedmdb.org/resource/actor/43399> || ?actor = <
> http://data.linkedmdb.org/resource/actor/43398> || ?actor = <
> http://data.linkedmdb.org/resource/actor/39> || ?actor = <
> http://data.linkedmdb.org/resource/actor/41867> || ?actor = <
> http://data.linkedmdb.org/resource/actor/34989> || ?actor = <
> http://data.linkedmdb.org/resource/actor/31932> || ?actor = <
> http://data.linkedmdb.org/resource/actor/31549> || ?actor = <
> http://data.linkedmdb.org/resource/actor/34222> || ?actor = <
> http://data.linkedmdb.org/resource/actor/38614> || ?actor = <
> http://data.linkedmdb.org/resource/actor/32501> || ?actor = <
> http://data.linkedmdb.org/resource/actor/37650> || ?actor = <
> http://data.linkedmdb.org/resource/actor/32108> || ?actor = <
> http://data.linkedmdb.org/resource/actor/30769> || ?actor = <
> http://data.linkedmdb.org/resource/actor/31914> || ?actor = <
> http://data.linkedmdb.org/resource/actor/43558> || ?actor = <
> http://data.linkedmdb.org/resource/actor/38396> || ?actor = <
> http://data.linkedmdb.org/resource/actor/32093> || ?actor = <
> http://data.linkedmdb.org/resource/actor/30373> || ?actor = <
> http://data.linkedmdb.org/resource/actor/33046> || ?actor = <
> http://data.linkedmdb.org/resource/actor/60548> || ?actor = <
> http://data.linkedmdb.org/resource/actor/32661>)}
>
> The only difference between both, are the size, because both are almost
> identical, with the exception that the second has a OR more bigger.
>
> Both are code-generated querys, and the second query can't be tested
> against the sparql dbpedia endpoint, because it's too big. Using jena
> framework against the dbpedia enpoint, works like a charm, but not the
> first one. Any idea why?
>
> Jose
Re: A query with an OR "smaller" doesn't work, but the same OR
"bigger" does!
Posted by José Luis Larroque <la...@gmail.com>.
@Martynas:
Thanks anyway, i will use your advice and do that, instead of those ugly OR
that i'm actually doing :D
I really don't know if i'm doing "a faceted search", it's a concept that
already see in some place but i didn't fully understand it. Maybe i'm, who
know's ! :D
@Andy:
Sorry andy for the format of the querys, i didn't want to alter the query
generated by my code in any way for been more exact at the moment of asking
question's here.
You are right, apparently some movies don't have a date and that was
stopping the query for finding more results.
I'm putting an "OPTIONAL{ }" clause around dc:date, for solving this issue.
I believe that i'm solving my problem doing this, so i don't understand
your last two lines in your answer.
Thanks to both!!
2014-03-09 6:44 GMT-03:00 Andy Seaborne <an...@apache.org>:
> On 09/03/14 02:07, José Luis Larroque wrote:
>
>> This query doesn't work:
>>
>
> Please make queries readable in email.
>
>
> PREFIX dc: <http://purl.org/dc/terms/>PREFIX movie: <
>> http://data.linkedmdb.org/resource/movie/>SELECT ?titulo ?id ?fecha
>> WHERE{
>> ?movie movie:actor ?actor .?movie dc:title ?titulo . ?movie dc:date
>> ?fecha.?movie movie:filmid ?id .FILTER( ?actor = <
>> http://data.linkedmdb.org/resource/actor/30711> || ?actor = <
>> http://data.linkedmdb.org/resource/actor/31259> || ?actor = <
>> http://data.linkedmdb.org/resource/actor/29536> || ?actor = <
>> http://data.linkedmdb.org/resource/actor/30485> || ?actor = <
>> http://data.linkedmdb.org/resource/actor/31204> || ?actor = <
>> http://data.linkedmdb.org/resource/actor/29852>)}
>>
>
> Some movies don't have dc:date. Maybe the pattern fails in other ways as
> well.
>
>
>> But this one, does:
>>
>
> I get results for just one actor, actor/29512, who is in many films (~30)
> and no others. That's out of about 118.
>
> If I remove actor/29512 I get no matches.
>
> data.linkedmdb.org has internal usage limits after which it stops the
> query execution. Combined with a graph pattern that excludes possibilities
> on matching, maybe the limits are being triggered.
>
> You'll need to ask them about that.
>
> Andy
>
>
> PREFIX dc: <http://purl.org/dc/terms/>PREFIX movie: <
>> http://data.linkedmdb.org/resource/movie/>SELECT ?titulo ?id ?fecha
>> WHERE{
>> ?movie movie:actor ?actor .?movie dc:title ?titulo . ?movie dc:date
>> ?fecha.?movie movie:filmid ?id .FILTER( ?actor = <
>> http://data.linkedmdb.org/resource/actor/68186> || ?actor = <
>> http://data.linkedmdb.org/resource/actor/9547> || ?actor = <
>> http://data.linkedmdb.org/resource/actor/570> || ?actor = <
>> http://data.linkedmdb.org/resource/actor/38579> || ?actor = <
>> http://data.linkedmdb.org/resource/actor/9546> || ?actor = <
>> http://data.linkedmdb.org/resource/actor/31700> || ?actor = <
>> http://data.linkedmdb.org/resource/actor/35706> || ?actor = <
>> http://data.linkedmdb.org/resource/actor/42962> || ?actor = <
>> http://data.linkedmdb.org/resource/actor/45825> || ?actor = <
>> http://data.linkedmdb.org/resource/actor/35702> || ?actor = <
>> http://data.linkedmdb.org/resource/actor/30922> || ?actor = <
>> http://data.linkedmdb.org/resource/actor/37416> || ?actor = <
>> http://data.linkedmdb.org/resource/actor/55943> || ?actor = <
>> http://data.linkedmdb.org/resource/actor/36078> || ?actor = <
>> http://data.linkedmdb.org/resource/actor/34357> || ?actor = <
>> http://data.linkedmdb.org/resource/actor/30535> || ?actor = <
>> http://data.linkedmdb.org/resource/actor/37983> || ?actor = <
>> http://data.linkedmdb.org/resource/actor/29961> || ?actor = <
>> http://data.linkedmdb.org/resource/actor/9332> || ?actor = <
>> http://data.linkedmdb.org/resource/actor/30532> || ?actor = <
>> http://data.linkedmdb.org/resource/actor/29959> || ?actor = <
>> http://data.linkedmdb.org/resource/actor/30723> || ?actor = <
>> http://data.linkedmdb.org/resource/actor/36453> || ?actor = <
>> http://data.linkedmdb.org/resource/actor/30913> || ?actor = <
>> http://data.linkedmdb.org/resource/actor/31101> || ?actor = <
>> http://data.linkedmdb.org/resource/actor/38167> || ?actor = <
>> http://data.linkedmdb.org/resource/actor/31099> || ?actor = <
>> http://data.linkedmdb.org/resource/actor/33199> || ?actor = <
>> http://data.linkedmdb.org/resource/actor/30715> || ?actor = <
>> http://data.linkedmdb.org/resource/actor/40456> || ?actor = <
>> http://data.linkedmdb.org/resource/actor/46372> || ?actor = <
>> http://data.linkedmdb.org/resource/actor/38156> || ?actor = <
>> http://data.linkedmdb.org/resource/actor/42356> || ?actor = <
>> http://data.linkedmdb.org/resource/actor/32996> || ?actor = <
>> http://data.linkedmdb.org/resource/actor/62792> || ?actor = <
>> http://data.linkedmdb.org/resource/actor/37770> || ?actor = <
>> http://data.linkedmdb.org/resource/actor/62790> || ?actor = <
>> http://data.linkedmdb.org/resource/actor/34712> || ?actor = <
>> http://data.linkedmdb.org/resource/actor/41397> || ?actor = <
>> http://data.linkedmdb.org/resource/actor/331> || ?actor = <
>> http://data.linkedmdb.org/resource/actor/37956> || ?actor = <
>> http://data.linkedmdb.org/resource/actor/37765> || ?actor = <
>> http://data.linkedmdb.org/resource/actor/44446> || ?actor = <
>> http://data.linkedmdb.org/resource/actor/31454> || ?actor = <
>> http://data.linkedmdb.org/resource/actor/55137> || ?actor = <
>> http://data.linkedmdb.org/resource/actor/46350> || ?actor = <
>> http://data.linkedmdb.org/resource/actor/33169> || ?actor = <
>> http://data.linkedmdb.org/resource/actor/44817> || ?actor = <
>> http://data.linkedmdb.org/resource/actor/31827> || ?actor = <
>> http://data.linkedmdb.org/resource/actor/34309> || ?actor = <
>> http://data.linkedmdb.org/resource/actor/37743> || ?actor = <
>> http://data.linkedmdb.org/resource/actor/29718> || ?actor = <
>> http://data.linkedmdb.org/resource/actor/35257> || ?actor = <
>> http://data.linkedmdb.org/resource/actor/34492> || ?actor = <
>> http://data.linkedmdb.org/resource/actor/301> || ?actor = <
>> http://data.linkedmdb.org/resource/actor/37927> || ?actor = <
>> http://data.linkedmdb.org/resource/actor/10994> || ?actor = <
>> http://data.linkedmdb.org/resource/actor/30857> || ?actor = <
>> http://data.linkedmdb.org/resource/actor/31047> || ?actor = <
>> http://data.linkedmdb.org/resource/actor/31810> || ?actor = <
>> http://data.linkedmdb.org/resource/actor/31997> || ?actor = <
>> http://data.linkedmdb.org/resource/actor/50332> || ?actor = <
>> http://data.linkedmdb.org/resource/actor/29512> || ?actor = <
>> http://data.linkedmdb.org/resource/actor/31421> || ?actor = <
>> http://data.linkedmdb.org/resource/actor/33712> || ?actor = <
>> http://data.linkedmdb.org/resource/actor/859> || ?actor = <
>> http://data.linkedmdb.org/resource/actor/31790> || ?actor = <
>> http://data.linkedmdb.org/resource/actor/29689> || ?actor = <
>> http://data.linkedmdb.org/resource/actor/36564> || ?actor = <
>> http://data.linkedmdb.org/resource/actor/34270> || ?actor = <
>> http://data.linkedmdb.org/resource/actor/36752> || ?actor = <
>> http://data.linkedmdb.org/resource/actor/50122> || ?actor = <
>> http://data.linkedmdb.org/resource/actor/36553> || ?actor = <
>> http://data.linkedmdb.org/resource/actor/37316> || ?actor = <
>> http://data.linkedmdb.org/resource/actor/32730> || ?actor = <
>> http://data.linkedmdb.org/resource/actor/29865> || ?actor = <
>> http://data.linkedmdb.org/resource/actor/1215> || ?actor = <
>> http://data.linkedmdb.org/resource/actor/29864> || ?actor = <
>> http://data.linkedmdb.org/resource/actor/33492> || ?actor = <
>> http://data.linkedmdb.org/resource/actor/39604> || ?actor = <
>> http://data.linkedmdb.org/resource/actor/31581> || ?actor = <
>> http://data.linkedmdb.org/resource/actor/65000> || ?actor = <
>> http://data.linkedmdb.org/resource/actor/31193> || ?actor = <
>> http://data.linkedmdb.org/resource/actor/64999> || ?actor = <
>> http://data.linkedmdb.org/resource/actor/40168> || ?actor = <
>> http://data.linkedmdb.org/resource/actor/45898> || ?actor = <
>> http://data.linkedmdb.org/resource/actor/64998> || ?actor = <
>> http://data.linkedmdb.org/resource/actor/29851> || ?actor = <
>> http://data.linkedmdb.org/resource/actor/37681> || ?actor = <
>> http://data.linkedmdb.org/resource/actor/37680> || ?actor = <
>> http://data.linkedmdb.org/resource/actor/51> || ?actor = <
>> http://data.linkedmdb.org/resource/actor/34430> || ?actor = <
>> http://data.linkedmdb.org/resource/actor/30610> || ?actor = <
>> http://data.linkedmdb.org/resource/actor/31565> || ?actor = <
>> http://data.linkedmdb.org/resource/actor/41305> || ?actor = <
>> http://data.linkedmdb.org/resource/actor/10362> || ?actor = <
>> http://data.linkedmdb.org/resource/actor/10361> || ?actor = <
>> http://data.linkedmdb.org/resource/actor/43399> || ?actor = <
>> http://data.linkedmdb.org/resource/actor/43398> || ?actor = <
>> http://data.linkedmdb.org/resource/actor/39> || ?actor = <
>> http://data.linkedmdb.org/resource/actor/41867> || ?actor = <
>> http://data.linkedmdb.org/resource/actor/34989> || ?actor = <
>> http://data.linkedmdb.org/resource/actor/31932> || ?actor = <
>> http://data.linkedmdb.org/resource/actor/31549> || ?actor = <
>> http://data.linkedmdb.org/resource/actor/34222> || ?actor = <
>> http://data.linkedmdb.org/resource/actor/38614> || ?actor = <
>> http://data.linkedmdb.org/resource/actor/32501> || ?actor = <
>> http://data.linkedmdb.org/resource/actor/37650> || ?actor = <
>> http://data.linkedmdb.org/resource/actor/32108> || ?actor = <
>> http://data.linkedmdb.org/resource/actor/30769> || ?actor = <
>> http://data.linkedmdb.org/resource/actor/31914> || ?actor = <
>> http://data.linkedmdb.org/resource/actor/43558> || ?actor = <
>> http://data.linkedmdb.org/resource/actor/38396> || ?actor = <
>> http://data.linkedmdb.org/resource/actor/32093> || ?actor = <
>> http://data.linkedmdb.org/resource/actor/30373> || ?actor = <
>> http://data.linkedmdb.org/resource/actor/33046> || ?actor = <
>> http://data.linkedmdb.org/resource/actor/60548> || ?actor = <
>> http://data.linkedmdb.org/resource/actor/32661>)}
>>
>> The only difference between both, are the size, because both are almost
>> identical, with the exception that the second has a OR more bigger.
>>
>> Both are code-generated querys, and the second query can't be tested
>> against the sparql dbpedia endpoint, because it's too big. Using jena
>> framework against the dbpedia enpoint, works like a charm, but not the
>> first one. Any idea why?
>>
>> Jose
>>
>>
>
Re: A query with an OR "smaller" doesn't work, but the same OR "bigger"
does!
Posted by Andy Seaborne <an...@apache.org>.
On 09/03/14 02:07, José Luis Larroque wrote:
> This query doesn't work:
Please make queries readable in email.
> PREFIX dc: <http://purl.org/dc/terms/>PREFIX movie: <
> http://data.linkedmdb.org/resource/movie/>SELECT ?titulo ?id ?fecha WHERE{
> ?movie movie:actor ?actor .?movie dc:title ?titulo . ?movie dc:date
> ?fecha.?movie movie:filmid ?id .FILTER( ?actor = <
> http://data.linkedmdb.org/resource/actor/30711> || ?actor = <
> http://data.linkedmdb.org/resource/actor/31259> || ?actor = <
> http://data.linkedmdb.org/resource/actor/29536> || ?actor = <
> http://data.linkedmdb.org/resource/actor/30485> || ?actor = <
> http://data.linkedmdb.org/resource/actor/31204> || ?actor = <
> http://data.linkedmdb.org/resource/actor/29852>)}
Some movies don't have dc:date. Maybe the pattern fails in other ways
as well.
>
> But this one, does:
I get results for just one actor, actor/29512, who is in many films
(~30) and no others. That's out of about 118.
If I remove actor/29512 I get no matches.
data.linkedmdb.org has internal usage limits after which it stops the
query execution. Combined with a graph pattern that excludes
possibilities on matching, maybe the limits are being triggered.
You'll need to ask them about that.
Andy
> PREFIX dc: <http://purl.org/dc/terms/>PREFIX movie: <
> http://data.linkedmdb.org/resource/movie/>SELECT ?titulo ?id ?fecha WHERE{
> ?movie movie:actor ?actor .?movie dc:title ?titulo . ?movie dc:date
> ?fecha.?movie movie:filmid ?id .FILTER( ?actor = <
> http://data.linkedmdb.org/resource/actor/68186> || ?actor = <
> http://data.linkedmdb.org/resource/actor/9547> || ?actor = <
> http://data.linkedmdb.org/resource/actor/570> || ?actor = <
> http://data.linkedmdb.org/resource/actor/38579> || ?actor = <
> http://data.linkedmdb.org/resource/actor/9546> || ?actor = <
> http://data.linkedmdb.org/resource/actor/31700> || ?actor = <
> http://data.linkedmdb.org/resource/actor/35706> || ?actor = <
> http://data.linkedmdb.org/resource/actor/42962> || ?actor = <
> http://data.linkedmdb.org/resource/actor/45825> || ?actor = <
> http://data.linkedmdb.org/resource/actor/35702> || ?actor = <
> http://data.linkedmdb.org/resource/actor/30922> || ?actor = <
> http://data.linkedmdb.org/resource/actor/37416> || ?actor = <
> http://data.linkedmdb.org/resource/actor/55943> || ?actor = <
> http://data.linkedmdb.org/resource/actor/36078> || ?actor = <
> http://data.linkedmdb.org/resource/actor/34357> || ?actor = <
> http://data.linkedmdb.org/resource/actor/30535> || ?actor = <
> http://data.linkedmdb.org/resource/actor/37983> || ?actor = <
> http://data.linkedmdb.org/resource/actor/29961> || ?actor = <
> http://data.linkedmdb.org/resource/actor/9332> || ?actor = <
> http://data.linkedmdb.org/resource/actor/30532> || ?actor = <
> http://data.linkedmdb.org/resource/actor/29959> || ?actor = <
> http://data.linkedmdb.org/resource/actor/30723> || ?actor = <
> http://data.linkedmdb.org/resource/actor/36453> || ?actor = <
> http://data.linkedmdb.org/resource/actor/30913> || ?actor = <
> http://data.linkedmdb.org/resource/actor/31101> || ?actor = <
> http://data.linkedmdb.org/resource/actor/38167> || ?actor = <
> http://data.linkedmdb.org/resource/actor/31099> || ?actor = <
> http://data.linkedmdb.org/resource/actor/33199> || ?actor = <
> http://data.linkedmdb.org/resource/actor/30715> || ?actor = <
> http://data.linkedmdb.org/resource/actor/40456> || ?actor = <
> http://data.linkedmdb.org/resource/actor/46372> || ?actor = <
> http://data.linkedmdb.org/resource/actor/38156> || ?actor = <
> http://data.linkedmdb.org/resource/actor/42356> || ?actor = <
> http://data.linkedmdb.org/resource/actor/32996> || ?actor = <
> http://data.linkedmdb.org/resource/actor/62792> || ?actor = <
> http://data.linkedmdb.org/resource/actor/37770> || ?actor = <
> http://data.linkedmdb.org/resource/actor/62790> || ?actor = <
> http://data.linkedmdb.org/resource/actor/34712> || ?actor = <
> http://data.linkedmdb.org/resource/actor/41397> || ?actor = <
> http://data.linkedmdb.org/resource/actor/331> || ?actor = <
> http://data.linkedmdb.org/resource/actor/37956> || ?actor = <
> http://data.linkedmdb.org/resource/actor/37765> || ?actor = <
> http://data.linkedmdb.org/resource/actor/44446> || ?actor = <
> http://data.linkedmdb.org/resource/actor/31454> || ?actor = <
> http://data.linkedmdb.org/resource/actor/55137> || ?actor = <
> http://data.linkedmdb.org/resource/actor/46350> || ?actor = <
> http://data.linkedmdb.org/resource/actor/33169> || ?actor = <
> http://data.linkedmdb.org/resource/actor/44817> || ?actor = <
> http://data.linkedmdb.org/resource/actor/31827> || ?actor = <
> http://data.linkedmdb.org/resource/actor/34309> || ?actor = <
> http://data.linkedmdb.org/resource/actor/37743> || ?actor = <
> http://data.linkedmdb.org/resource/actor/29718> || ?actor = <
> http://data.linkedmdb.org/resource/actor/35257> || ?actor = <
> http://data.linkedmdb.org/resource/actor/34492> || ?actor = <
> http://data.linkedmdb.org/resource/actor/301> || ?actor = <
> http://data.linkedmdb.org/resource/actor/37927> || ?actor = <
> http://data.linkedmdb.org/resource/actor/10994> || ?actor = <
> http://data.linkedmdb.org/resource/actor/30857> || ?actor = <
> http://data.linkedmdb.org/resource/actor/31047> || ?actor = <
> http://data.linkedmdb.org/resource/actor/31810> || ?actor = <
> http://data.linkedmdb.org/resource/actor/31997> || ?actor = <
> http://data.linkedmdb.org/resource/actor/50332> || ?actor = <
> http://data.linkedmdb.org/resource/actor/29512> || ?actor = <
> http://data.linkedmdb.org/resource/actor/31421> || ?actor = <
> http://data.linkedmdb.org/resource/actor/33712> || ?actor = <
> http://data.linkedmdb.org/resource/actor/859> || ?actor = <
> http://data.linkedmdb.org/resource/actor/31790> || ?actor = <
> http://data.linkedmdb.org/resource/actor/29689> || ?actor = <
> http://data.linkedmdb.org/resource/actor/36564> || ?actor = <
> http://data.linkedmdb.org/resource/actor/34270> || ?actor = <
> http://data.linkedmdb.org/resource/actor/36752> || ?actor = <
> http://data.linkedmdb.org/resource/actor/50122> || ?actor = <
> http://data.linkedmdb.org/resource/actor/36553> || ?actor = <
> http://data.linkedmdb.org/resource/actor/37316> || ?actor = <
> http://data.linkedmdb.org/resource/actor/32730> || ?actor = <
> http://data.linkedmdb.org/resource/actor/29865> || ?actor = <
> http://data.linkedmdb.org/resource/actor/1215> || ?actor = <
> http://data.linkedmdb.org/resource/actor/29864> || ?actor = <
> http://data.linkedmdb.org/resource/actor/33492> || ?actor = <
> http://data.linkedmdb.org/resource/actor/39604> || ?actor = <
> http://data.linkedmdb.org/resource/actor/31581> || ?actor = <
> http://data.linkedmdb.org/resource/actor/65000> || ?actor = <
> http://data.linkedmdb.org/resource/actor/31193> || ?actor = <
> http://data.linkedmdb.org/resource/actor/64999> || ?actor = <
> http://data.linkedmdb.org/resource/actor/40168> || ?actor = <
> http://data.linkedmdb.org/resource/actor/45898> || ?actor = <
> http://data.linkedmdb.org/resource/actor/64998> || ?actor = <
> http://data.linkedmdb.org/resource/actor/29851> || ?actor = <
> http://data.linkedmdb.org/resource/actor/37681> || ?actor = <
> http://data.linkedmdb.org/resource/actor/37680> || ?actor = <
> http://data.linkedmdb.org/resource/actor/51> || ?actor = <
> http://data.linkedmdb.org/resource/actor/34430> || ?actor = <
> http://data.linkedmdb.org/resource/actor/30610> || ?actor = <
> http://data.linkedmdb.org/resource/actor/31565> || ?actor = <
> http://data.linkedmdb.org/resource/actor/41305> || ?actor = <
> http://data.linkedmdb.org/resource/actor/10362> || ?actor = <
> http://data.linkedmdb.org/resource/actor/10361> || ?actor = <
> http://data.linkedmdb.org/resource/actor/43399> || ?actor = <
> http://data.linkedmdb.org/resource/actor/43398> || ?actor = <
> http://data.linkedmdb.org/resource/actor/39> || ?actor = <
> http://data.linkedmdb.org/resource/actor/41867> || ?actor = <
> http://data.linkedmdb.org/resource/actor/34989> || ?actor = <
> http://data.linkedmdb.org/resource/actor/31932> || ?actor = <
> http://data.linkedmdb.org/resource/actor/31549> || ?actor = <
> http://data.linkedmdb.org/resource/actor/34222> || ?actor = <
> http://data.linkedmdb.org/resource/actor/38614> || ?actor = <
> http://data.linkedmdb.org/resource/actor/32501> || ?actor = <
> http://data.linkedmdb.org/resource/actor/37650> || ?actor = <
> http://data.linkedmdb.org/resource/actor/32108> || ?actor = <
> http://data.linkedmdb.org/resource/actor/30769> || ?actor = <
> http://data.linkedmdb.org/resource/actor/31914> || ?actor = <
> http://data.linkedmdb.org/resource/actor/43558> || ?actor = <
> http://data.linkedmdb.org/resource/actor/38396> || ?actor = <
> http://data.linkedmdb.org/resource/actor/32093> || ?actor = <
> http://data.linkedmdb.org/resource/actor/30373> || ?actor = <
> http://data.linkedmdb.org/resource/actor/33046> || ?actor = <
> http://data.linkedmdb.org/resource/actor/60548> || ?actor = <
> http://data.linkedmdb.org/resource/actor/32661>)}
>
> The only difference between both, are the size, because both are almost
> identical, with the exception that the second has a OR more bigger.
>
> Both are code-generated querys, and the second query can't be tested
> against the sparql dbpedia endpoint, because it's too big. Using jena
> framework against the dbpedia enpoint, works like a charm, but not the
> first one. Any idea why?
>
> Jose
>