We're Moving!

The Vertica Forum is moving to a new OpenText Analytics Database (Vertica) Community.

Join us there to post discussion topics, learn about

product releases, share tips, access the blog, and much more.

Create My New Community Account Now


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

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 ...