what is the character limit for monetdb queries?
i'm definitely hitting one around 1.7 million characters, but i'm wondering how much lower the actual limit is?
thanks!
Hi,
trying to suppress my worries about why one would need a single SQL query consisting of more than 1.7 million characters (you might want to consider using views, prepared queries, or alike ...) (;-)),
what is the exact error you get when you reach/exceed the limit?
Thanks! Stefan
----- Original Message -----
i'm definitely hitting one around 1.7 million characters, but i'm wondering how much lower the actual limit is?
thanks!
users-list mailing list users-list@monetdb.org https://www.monetdb.org/mailman/listinfo/users-list
hi stefan, my guess is the server's just truncating the query at wherever the character limit is, then getting whatever error you'd expect from the incomplete query.. i agree that sending a 1.7 million character query is pretty extreme, but i believe very long strings are unavoidable in dr. lumley's R sqlsurvey code http://sqlsurvey.r-forge.r-project.org/ even if he takes steps to minimize what he can. i don't mean to create a bunch of work for you, i was really just curious if you knew of any hard ceiling. :) thank you!
Error in .local(conn, statement, ...) : Unable to execute statement 'select avg(_s__api00_AcaciaElementa), avg(_s__api00_AdamsElementar), avg(_s__api00_AeolianElement), ...'. Server says 'syntax error, unexpected $end, expecting ')' in: "select avg(_s__api00_acaciaelementa), avg(_s__api00_adamselementar), avg(_s__api00_aeolianelement),
On Mon, Feb 17, 2014 at 6:57 AM, Stefan Manegold Stefan.Manegold@cwi.nlwrote:
Hi,
trying to suppress my worries about why one would need a single SQL query consisting of more than 1.7 million characters (you might want to consider using views, prepared queries, or alike ...) (;-)),
what is the exact error you get when you reach/exceed the limit?
Thanks! Stefan
----- Original Message -----
i'm definitely hitting one around 1.7 million characters, but i'm
wondering
how much lower the actual limit is?
thanks!
users-list mailing list users-list@monetdb.org https://www.monetdb.org/mailman/listinfo/users-list
-- | Stefan.Manegold@CWI.nl | DB Architectures (DA) | | www.CWI.nl/~manegold/ | Science Park 123 (L321) | | +31 (0)20 592-4212 | 1098 XG Amsterdam (NL) |
users-list mailing list users-list@monetdb.org https://www.monetdb.org/mailman/listinfo/users-list
I think you're hitting a bug that I fixed after the Feb2013-SP6 release. What version are you running? Can you try the Jan2014 candidate release (see http://dev.monetdb.org/downloads/testing/)?
On 2014-02-17 13:46, Anthony Damico wrote:
hi stefan, my guess is the server's just truncating the query at wherever the character limit is, then getting whatever error you'd expect from the incomplete query.. i agree that sending a 1.7 million character query is pretty extreme, but i believe very long strings are unavoidable in dr. lumley's R sqlsurvey code http://sqlsurvey.r-forge.r-project.org/ even if he takes steps to minimize what he can. i don't mean to create a bunch of work for you, i was really just curious if you knew of any hard ceiling. :) thank you!
Error in .local(conn, statement, ...) : Unable to execute statement 'select avg(_s__api00_AcaciaElementa), avg(_s__api00_AdamsElementar), avg(_s__api00_AeolianElement), ...'. Server says 'syntax error, unexpected $end, expecting ')' in: "select avg(_s__api00_acaciaelementa), avg(_s__api00_adamselementar), avg(_s__api00_aeolianelement),
On Mon, Feb 17, 2014 at 6:57 AM, Stefan Manegold <Stefan.Manegold@cwi.nl mailto:Stefan.Manegold@cwi.nl> wrote:
Hi, trying to suppress my worries about why one would need a single SQL query consisting of more than 1.7 million characters (you might want to consider using views, prepared queries, or alike ...) (;-)), what is the exact error you get when you reach/exceed the limit? Thanks! Stefan ----- Original Message ----- > i'm definitely hitting one around 1.7 million characters, but i'm wondering > how much lower the actual limit is? > > thanks! > > _______________________________________________ > users-list mailing list > users-list@monetdb.org <mailto:users-list@monetdb.org> > https://www.monetdb.org/mailman/listinfo/users-list > -- | Stefan.Manegold@CWI.nl | DB Architectures (DA) | | www.CWI.nl/~manegold/ <http://www.CWI.nl/~manegold/> | Science Park 123 (L321) | | +31 (0)20 592-4212 <tel:%2B31%20%280%2920%20592-4212> | 1098 XG Amsterdam (NL) | _______________________________________________ users-list mailing list users-list@monetdb.org <mailto:users-list@monetdb.org> https://www.monetdb.org/mailman/listinfo/users-list
users-list mailing list users-list@monetdb.org https://www.monetdb.org/mailman/listinfo/users-list
yes, it looks like you fixed it. with the jan2014 edition, the 1.7 million character query no longer returns an error and instead (much more sensibly) overloads my computer and causes it to freeze. we've gotta get these big queries under control. thank you!!!!!
On Mon, Feb 17, 2014 at 8:03 AM, Sjoerd Mullender sjoerd@monetdb.orgwrote:
I think you're hitting a bug that I fixed after the Feb2013-SP6 release. What version are you running? Can you try the Jan2014 candidate release (see http://dev.monetdb.org/downloads/testing/)?
On 2014-02-17 13:46, Anthony Damico wrote:
hi stefan, my guess is the server's just truncating the query at wherever the character limit is, then getting whatever error you'd expect from the incomplete query.. i agree that sending a 1.7 million character query is pretty extreme, but i believe very long strings are unavoidable in dr. lumley's R sqlsurvey code http://sqlsurvey.r-forge.r-project.org/ even if he takes steps to minimize what he can. i don't mean to create a bunch of work for you, i was really just curious if you knew of any hard ceiling. :) thank you!
Error in .local(conn, statement, ...) : Unable to execute statement 'select avg(_s__api00_AcaciaElementa), avg(_s__api00_AdamsElementar), avg(_s__api00_AeolianElement), ...'. Server says 'syntax error, unexpected $end, expecting ')' in: "select avg(_s__api00_acaciaelementa), avg(_s__api00_adamselementar), avg(_s__api00_aeolianelement),
On Mon, Feb 17, 2014 at 6:57 AM, Stefan Manegold <Stefan.Manegold@cwi.nl mailto:Stefan.Manegold@cwi.nl> wrote:
Hi, trying to suppress my worries about why one would need a single SQL query consisting of more than 1.7 million characters (you might want to consider using views, prepared queries, or alike ...) (;-)), what is the exact error you get when you reach/exceed the limit? Thanks! Stefan ----- Original Message ----- > i'm definitely hitting one around 1.7 million characters, but i'm wondering > how much lower the actual limit is? > > thanks! > > _______________________________________________ > users-list mailing list > users-list@monetdb.org <mailto:users-list@monetdb.org> > https://www.monetdb.org/mailman/listinfo/users-list > -- | Stefan.Manegold@CWI.nl | DB Architectures (DA) | | www.CWI.nl/~manegold/ <http://www.CWI.nl/~manegold/> | Science Park 123 (L321) | | +31 (0)20 592-4212 <tel:%2B31%20%280%2920%20592-4212> | 1098 XG Amsterdam (NL) | _______________________________________________ users-list mailing list users-list@monetdb.org <mailto:users-list@monetdb.org> https://www.monetdb.org/mailman/listinfo/users-list
users-list mailing list users-list@monetdb.org https://www.monetdb.org/mailman/listinfo/users-list
-- Sjoerd Mullender
users-list mailing list users-list@monetdb.org https://www.monetdb.org/mailman/listinfo/users-list
participants (3)
-
Anthony Damico -
Sjoerd Mullender -
Stefan Manegold