The Vertica Forum recently got a makeover! Let us know what you think by filling out this short, anonymous survey.

Label not working

Hi when I tried to implement labels in my queries.

I started with testing a sample query to test the label.

To my surprise the label didnt work , I verified in query_profile table and query _request table.

I found the select query without label and query_profile column as blank.

 

pleas please help me how to resolve this...

Comments

  • Hi everyone,

    I just gave it a try in VSQL and it is working fine,

    but when I use squirrel sql client(Java based tool --jdbc connection) im unable to label a query.

     

  •  

     Check the error_messages table looking for something like this 'Invalid character in hint%'

    select * from error_messages where message ilike  'Invalid character in hint%'

     

     It happened to me with connection coming from JDBC. 

    Note: -the hint identifier cannot start with a Integer.

     

     

  • Hi  Thanks for the reply, but I dont see any error in error_messages table and the query is executed fine without label in squirrel sql client ,when I same query is executed in vsql it was executed with label too.

     

  • Hi ,

    Its known issue with squirrel  , squirrel   don't have native plugin for vertica , we use the generic plugin  .

    You can try use dbeaver   , i think their you should be Ok .

     

    http://www.davewentzel.com/content/developing-vertica

     

     

    Thanks .

Leave a Comment

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

Can't find what you're looking for? Search the Vertica Documentation, Knowledge Base, or Blog for more information.