This article explains that Vertica does not currently support directed queries involving views and constant variables in the SELECT clause. Documentation improvements and an enhancement request have been initiated.
Environment
- Vertica Database
- Directed queries using views and constant variables in
SELECTclause
Situation
A customer reported unexpected behavior when executing queries that include views and constant variables in the SELECT clause, and that refers to the Directed queries. The documentation did not provide examples for this scenario.
