Please take this survey to help us learn more about how you use third party tools. Your input is greatly appreciated!

Filtering in projection definition?

DreaBrandfordDreaBrandford 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

Answers

  • ChuckBChuckB 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
Emoji
Image
Align leftAlign centerAlign rightToggle HTML viewToggle full pageToggle lights
Drop image/file

Can't find what you're looking for? Search the Vertica Documentation, Knowledge Base, or Blog for more information.