Filtering in projection definition?

DreaBrandfordDreaBrandford Vertica Employee Employee
edited April 2020 in General Discussion

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


  • Options
    ChuckBChuckB Vertica Employee Employee

    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!

Leave a Comment

BoldItalicStrikethroughOrdered listUnordered list
Align leftAlign centerAlign rightToggle HTML viewToggle full pageToggle lights
Drop image/file