Skip to main content

ERROR 4588: Request size too big. Please try to simplify the query

Mireille_Esteph
I have a query that is just 33K and Vertica says query length has no limit, but when I ran this query I am getting the following error: ERROR 4588: Request size too big. Please try to simplify the query Can you please help me and tell me what is the issue?

    2 replies

    Forum|alt.badge.img+2
    • Anonymous
    • Participating Frequently
    • June 11, 2013
    Hi,

    This error points at the size of plan this query produces and not the query size. May be the query is too complex.

    Thanks,
    Pravesh
    Mireille_Esteph
    Thank you so much for your reply. The query I am using has 5 sub queries in it and each one of them is doing SUM + CASE + group by. Any suggestion of how to simplify this kind of query?
    Still scrolling?
    Ask a question
    Terms & ConditionsAccessibility statement