Skip to main content

With clause materialization is not working in Vertica 8.0.1

  • April 14, 2017
  • 5 replies
  • 19 views
prasshant

I am having big analytic query where i amusing one with clause repeatedly , i want to make use of ENABLE_WITH_CLAUSE_MATERIALIZATION.

i am using JDBC Driver v8.0.1-0

I have tried following first by giving hint into query, as well as enabling with clause materialization at session level.

1. WITH /*+ ENABLE_WITH_CLAUSE_MATERIALIZATION  */ with-query...
2. ALTER SESSION SET PARAMETER EnableWithClauseMaterialization=1;

I am getting following error

[Error Code: 2656, SQL State: 42703] [Vertica]VJDBC ERROR: Column ad_line_agg_$1108$.ad_id does not exist

Please help

    5 replies

    Forum|alt.badge.img+2
    • Anonymous
    • Participating Frequently
    • April 17, 2017

    Can you run query without hint or session parameter ? If hint you have provided is incorrect it will be skipped but you should not get above error .

    prasshant
    • prasshant
    • Author
    • New Participant
    • April 18, 2017

    We have ran query without that hint, as well as not setting up the materialization param, it works fine.

    Forum|alt.badge.img+2
    • Anonymous
    • Participating Frequently
    • April 19, 2017

    If you have support contract with support please open support ticket. If not please message me design for tables used and query .

    bhanu_kishore
    Forum|alt.badge.img
    • bhanu_kishore
    • Participating Frequently
    • May 11, 2017

    can you keep the query in a .sql file and execute .sql file from sql prompt instead of executing over jdbc connection. Just to make sure that the problem is not with client connenction.

    prasshant
    • prasshant
    • Author
    • New Participant
    • May 29, 2017

    @bhanu_kishore
    I have used vsql console and directly fired sql query from file, and error is not going away (same error), so it is definitely Vertica problem and not JDBC.

    Still scrolling?
    Ask a question
    Terms & ConditionsAccessibility statement