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

Sharon_DashetSharon_Dashet
in General Discussion
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

  • norbert_krupanorbert_krupa
    It's worth mentioning that query labels can (and should) also be used on other DML such as INSERT, UPDATE, and DELETE.
  • Sharon_DashetSharon_Dashet
    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
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 ...