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


Make sense of your SQL statements using Vertica Query Label hint — Vertica Forum

Make sense of your SQL statements using Vertica Query Label hint

http://hpsw.co/Cm79Bny
Have you experienced the Query Label hint in HP Vertica? In this blog I am showing how to utilize it effectively in a vast Vertica reporting system.

Comments

  • It's worth mentioning that query labels can (and should) also be used on other DML such as INSERT, UPDATE, and DELETE.
  • This is true, the hint is suitable for grouping all SQL statements. In this blog I demonestarted the Query use case but it can apply to DML as well.

Leave a Comment

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