Please take this survey to help us learn more about how you use third party tools. Your input is greatly appreciated!

ODBC Connection to Vertica

edited July 2017 in General Discussion

Hi All, I have established ODBC connection to Vertica and the ouput generation is very slow and not able to pull the data from Vertica to Solaris server from perl Scipt. Appreciate any one 's help.

Comments

  • edited July 2017

    Hi!

    How about isql?
    https://my.vertica.com/docs/7.2.x/HTML/index.htm#Authoring/ConnectingToHPVertica/ClientODBC/TestingADSNUsingIsql.htm

    Can you post:

    • vertica version
    • perl version
    • unixODBC version (on client)
    • vertica.ini (on client)
    • database locale
    • vertica host locale

    db locale:

    dbadmin=> SELECT GET_CONFIG_PARAMETER('DefaultSessionLocale');
      GET_CONFIG_PARAMETER  
    ------------------------
     [email protected]=binary
    (1 row)
    

    host locale:

    $ locale
    LANG=en_US.UTF-8
    LANGUAGE=en_US
    LC_CTYPE="en_US.UTF-8"
    LC_NUMERIC=en_US.UTF-8
    LC_TIME=en_US.UTF-8
    LC_COLLATE="en_US.UTF-8"
    LC_MONETARY=en_US.UTF-8
    LC_MESSAGES="en_US.UTF-8"
    LC_PAPER=en_US.UTF-8
    LC_NAME=en_US.UTF-8
    LC_ADDRESS=en_US.UTF-8
    LC_TELEPHONE=en_US.UTF-8
    LC_MEASUREMENT=en_US.UTF-8
    LC_IDENTIFICATION=en_US.UTF-8
    LC_ALL=
    

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.