On 12/18/13 8:15 AM, Ian Harrison wrote:
I'm hitting a problem with Virtuoso 7 with the use of large filters ...... the scenario is that I'm setting a query variable value to be one of many things ... rather than returning all values for that query variablee.g. select ?yhing ?x ?y ?x where {?thing predicate1 ?x . ?thing predicate2 ?y . ?thing predicate3 ?z filter (? thing = <http://host/id/thing/1> || ?thing = <http://host/id/thing/2> || ?thing = <http://host/id/thing/3> || ?thing = <http://host/id/thing/4> || ?thing = <http://host/id/thing/5> || .... there might be 100-200 things in the filter list ... but there may be millions of instances of ?thing. The error thrown is: Virtuoso 37000 Error SQ156: Internal Optimized compiler error : unknown table for a column dfe in sqldf.c:1422. Please report the statement compiled. SPARQL query: Virtuoso 37000 Error SQ156: Internal Optimized compiler error : unknown table for a column dfe in sqldf.c:1422. Please report the statement compiled. With trace_on() setup, it l;ooks like the filter is being truncated. Can you try and replicate such a test case. It's important for my application, as I'm using the OR filter pattern, as a way of delivering data services of the form ... do a search to identify a set of things of interest and then return lots of data about the items that have been returned by the search ..... I'm open to suggestions of a workaround tpo, if this is aknown problem, to be able to handle such a data pattern. Ian
Could you please attempt an example using the 50B+ triples instance at: http://lod.openlinksw.com/sparql . Then you can just share the SPARQL results URL etc..
-- Regards, Kingsley Idehen Founder & CEO OpenLink Software Company Web: http://www.openlinksw.com Personal Weblog: http://www.openlinksw.com/blog/~kidehen Twitter Profile: https://twitter.com/kidehen Google+ Profile: https://plus.google.com/+KingsleyIdehen/about LinkedIn Profile: http://www.linkedin.com/in/kidehen
smime.p7s
Description: S/MIME Cryptographic Signature
------------------------------------------------------------------------------ Rapidly troubleshoot problems before they affect your business. Most IT organizations don't have a clear picture of how application performance affects their revenue. With AppDynamics, you get 100% visibility into your Java,.NET, & PHP application. Start your 15-day FREE TRIAL of AppDynamics Pro! http://pubads.g.doubleclick.net/gampad/clk?id=84349831&iu=/4140/ostg.clktrk
_______________________________________________ Virtuoso-users mailing list Virtuoso-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/virtuoso-users
