Hi Hugh,
I have library catalog data containing resources (Books etc.) having
different annotation properties that need to be concatenated into a
single literal. I made a mistake in my SPARQL query by omitting the
GROUP BY clause ... apparently without it /ALL/ strings get
concatenated, exceeding the limits. So I guess this limiting security
works fine for noobs like me :)
Thanks,
Roland
On 08-11-16 03:42, Hugh Williams wrote:
> Hi Roland,
>
> Unfortunately that limit can't be change as it's at the very base
> levels of the runtime, development indicate.
>
> What is the use case you have that requires such a large GROUP_CONCAT
> size ?
>
> Best Regards
> Hugh Williams
> Professional Services
> OpenLink Software, Inc. // http://www.openlinksw.com/
> Weblog -- http://www.openlinksw.com/blogs/
> LinkedIn -- http://www.linkedin.com/company/openlink-software/
> Twitter -- http://twitter.com/OpenLink
> Google+ -- http://plus.google.com/100570109519069333827/
> Facebook -- http://www.facebook.com/OpenLinkSoftware
> Universal Data Access, Integration, and Management Technology Providers
>
>> On 7 Nov 2016, at 22:57, Roland Cornelissen <metamatter...@gmail.com
>> <mailto:metamatter...@gmail.com>> wrote:
>>
>> Him
>>
>> Is it possible to (temporarily) increase the maximum GROUP_CONCAT
>> size? Someting like this:
>>
>> |SETSESSION group_concat_max_len =1000000;|
>>
>> I run into this error when using GROUP_CONCAT:
>>
>> *** Error 22023: [Virtuoso Driver][Virtuoso Server]SR578: The
>> expected result length of string concatenation is too large (10000059
>> bytes)
>> in lines 120-125 of Top-Level:
>>
>> I would like to temporarily increase the maximum value; how can this
>> be done?
>>
>> Thanks,
>> Roland
>>
>>
>> ------------------------------------------------------------------------------
>> Developer Access Program for Intel Xeon Phi Processors
>> Access to Intel Xeon Phi processor-based developer platforms.
>> With one year of Intel Parallel Studio XE.
>> Training and support from Colfax.
>> Order your platform today.
>> http://sdm.link/xeonphi_______________________________________________
>> Virtuoso-users mailing list
>> Virtuoso-users@lists.sourceforge.net
>> <mailto:Virtuoso-users@lists.sourceforge.net>
>> https://lists.sourceforge.net/lists/listinfo/virtuoso-users
>
>
>
> ------------------------------------------------------------------------------
> Developer Access Program for Intel Xeon Phi Processors
> Access to Intel Xeon Phi processor-based developer platforms.
> With one year of Intel Parallel Studio XE.
> Training and support from Colfax.
> Order your platform today. http://sdm.link/xeonphi
>
>
> _______________________________________________
> Virtuoso-users mailing list
> Virtuoso-users@lists.sourceforge.net
> https://lists.sourceforge.net/lists/listinfo/virtuoso-users
------------------------------------------------------------------------------
Developer Access Program for Intel Xeon Phi Processors
Access to Intel Xeon Phi processor-based developer platforms.
With one year of Intel Parallel Studio XE.
Training and support from Colfax.
Order your platform today. http://sdm.link/xeonphi
_______________________________________________
Virtuoso-users mailing list
Virtuoso-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/virtuoso-users
