With clause materialization is not working in Vertica 8.0.1
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