The Vertica Forum recently got a makeover! Let us know what you think by filling out this short, anonymous survey.
Please take this survey to help us learn more about how you use third party tools. Your input is greatly appreciated!

fromExprRelids.size()

Hi,
Have you ever met this error ?

2018-06-25 14:30:15.051 Init Session:7f0e102d5700-a000000a15f78d @v_officedw_node0001: VX001/3594: Internal Optimizer Error (11)
DETAIL: fromExprRelids.size() == 1
HINT: Please report this error to Vertica; try restating your query
LOCATION: populateJoinTree, /scratch_a/release/svrtar12486/vbuild/vertica/Optimizer/Path/JoinGraph.cpp:1094

Thank you,
Veronica

Comments

  • Jim_KnicelyJim_Knicely - Select Field - Administrator
    edited June 2018

    Can you post the SQL statement that causes the error?

    There is a fix in Vertica 9.1 that addresses a cause of this error. But we won't know if it'd help you until we see your particular statement.

  • Hi,
    I have this error on Vertica Analytic Database v9.1.0-0.
    I will try to post the tables structure and the query.
    Thank you,
    Veronica

Leave a Comment

BoldItalicStrikethroughOrdered listUnordered list
Emoji
Image
Align leftAlign centerAlign rightToggle HTML viewToggle full pageToggle lights
Drop image/file