Skip to main content

Make sense of your SQL statements using Vertica Query Label hint

  • November 13, 2014
  • 2 replies
  • 15 views

Sharon_Dashet
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.

2 replies

norbert_krupa
Forum|alt.badge.img+2
  • Participating Frequently
  • November 16, 2014
It's worth mentioning that query labels can (and should) also be used on other DML such as INSERT, UPDATE, and DELETE.

Sharon_Dashet
  • Author
  • New Participant
  • November 16, 2014
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.