+1Hi 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...
+1Hi 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.
+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.
+1Hi 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.
+2Hi ,
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 .
Already have an account? Login
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.
77 4th Avenue
Waltham, MA 02451 USA
