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

Mireille_EstephMireille_Esteph
in General Discussion
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?

Comments

  • [Deleted User][Deleted User]
    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_EstephMireille_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?

Leave a Comment

BoldItalicStrikethroughOrdered listUnordered list
Format
SpoilerCodeQuote
Heading 2Heading 1
Emoji
:):D:(;):/:o:s:p:'(:|B):#:*<3o:)>:)
Url
Image
Align leftAlign centerAlign rightToggle HTML viewToggle full pageToggle lights
Drop image/file
Home • General DiscussionComment As ...