Label not working

SRA1

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

SRA1

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.

 

Adrian_Oprea_1

 

 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.

 

 

SRA1

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.

 

eli_revach

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 .