We're Moving!

The Vertica Forum is moving to a new OpenText Analytics Database (Vertica) Community.

Join us there to post discussion topics, learn about

product releases, share tips, access the blog, and much more.

Create My New Community Account Now


Filtering in projection definition? — Vertica Forum

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

Tagged:

Answers

  • 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
Format
SpoilerCodeQuote
Heading 2Heading 1
Emoji
:):D:(;):/:o:s:p:'(:|B):#:*<3o:)>:)
Url
Image
Align leftAlign centerAlign rightToggle HTML viewToggle full pageToggle lights
Drop image/file
Home • General DiscussionComment As ...