There is a possibility to have a projection with a filter/ 'where' condition ?
Asked during BDC session The Shortest Path to Vertica - Best Practices for Data Warehouse Migration & ETL@marcothesane @Maurizio
No, projection definitions don't support WHERE. But if you sort the data on the WHERE clause, predicates are fast, and it will run as if the other data is not there!
Can't find what you're looking for? Search the Vertica Documentation, Knowledge Base, or Blog for more information.