Options

Label not working

SRA1SRA1
in General Discussion

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

  • Options
    SRA1SRA1

    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.

     

  • Options
    Adrian_Oprea_1Adrian_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.

     

     

  • Options
    SRA1SRA1

    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.

     

  • Options
    eli_revacheli_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 .

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 ...
gdn.meta.AnalyticsTask=false; // Check if the user has given consent. let cookieConsent = getCookie('consent'); // If the user has given consent set the track to track them. if (cookieConsent) { gdn.meta.AnalyticsTask='tick'; }