We're Moving!

The Vertica Forum is moving to a new OpenText Analytics Database (Vertica) Community.

Join us there to post discussion topics, learn about

product releases, share tips, access the blog, and much more.

Create My New Community Account Now


Setting the JavaBinaryForUDx Configuration Parameter — Vertica Forum

Setting the JavaBinaryForUDx Configuration Parameter

testertester
in General Discussion
SELECT SET_CONFIG_PARAMETER('JavaBinaryForUDx','/usr/java/default/bin/java');

Giving me an error of -bash: syntax error near unexpected token '('

Anyone?

Comments

  • Abhishek_RanaAbhishek_Rana Vertica Employee Employee
    It is type of syntax error only.. Check the syntax which you are using & see for correct quotes being used.

    Try running it from vsql & from dbadmin user.

    Regards'

    Abhishek
  • testertester
    The syntax is should be right. U mean to run vsql inside dbadmin? How do u go about doing that? Thanks Abhishek

  • wwong2wwong2 Employee
    Hi, it looks like you ran the SELECT SET_CONFIG_PARAMETER('JavaBinaryForUDx','/usr/java/default/bin/java'); command at linux command line, what you need to do is issue that within Vertica.
    You can get in either through admintools to connect to db

    $> /opt/vertica/bin/admintools

    or direct through vsql

    $>/opt/vertica/bin/vsql

    Regards

  • testertester
    Thank you, it works perfectly now.

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