Options

fromExprRelids.size()

vcarusivcarusi ✭
in General Discussion

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

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

  • Options
    vcarusivcarusi ✭

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