ODBC Connection to Vertica

mrbhanu87

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.

sKwa

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  
------------------------
 en_US@collation=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=