I am facing an issueswhen tentatively writing an Optimized Merge query as described in 7.0 manual.
I follow the requirements as stated in the doc:
Conditions for an Optimized MERGE
HP Vertica prepares an optimized query plan when all of the following conditions are true:
- The target table's join column has a unique or primary key constraint
UPDATEandINSERTclauses include every column in the target tableUPDATEandINSERTclause column attributes are identical
And when I run my request, with or without EXPLAIN, I have following error :
[Vertica][VJDBC](3594) INTERNAL: Internal Optimizer Error (11) [Vertica][VJDBC]Detail: !isView(rte->relid)
Are views not supported as source of the merge?
Is there another workaround to make it work?
Tx in advance,
Br