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


fromExprRelids.size() — Vertica Forum

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

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

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