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
Question
Filtering in projection definition?
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!
Sign up
Already have an account? Login
Welcome to the Rocket Forum!
Please log in or register:
Employee Login | Registration Member Login | RegistrationEnter your E-mail address. We'll send you an e-mail with instructions to reset your password.
77 4th Avenue
Waltham, MA 02451 USA
