Skip to main content

fromExprRelids.size()

  • June 25, 2018
  • 2 replies
  • 7 views
vcarusi
Forum|alt.badge.img+1

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

    2 replies

    Jim_Knicely
    Forum|alt.badge.img+2
    • Jim_Knicely
    • Participating Frequently
    • June 25, 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.

    vcarusi
    Forum|alt.badge.img+1
    • vcarusi
    • Author
    • Participating Frequently
    • June 26, 2018

    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

    Still scrolling?
    Ask a question
    Terms & ConditionsAccessibility statement