Running Python Script as External Procedure in Vertica 7.1

AaduAadu
in General Discussion

Hi ,

 

We have a python script that connects to database using pyodbc.connect and processes some sql statements.

When we run the script from shell - ./<script_name>.py , it runs perfectly fine. But when I install the script inside Vertica Database and create an external procedure and try to execute it as select <proc_nam>();, it fails with error could not connect to DSN.

 

What could be the possible cause for the same ?

 

Regards

Vini

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