Python SDK for Vertica Is Here


Finally its here, the Vertica Python official SDK. This was the most asked feature (at least by me) to Vertica Engineering.

More about this feature

Some Highlights about this feature

Make sure, when you test your python program before deploying it uses Python 3.5.1 interpreter as the same version is used by Vertica. So if not used right version there are possibilities your code might behave different than your UDx

For now, I think Python API only supports UDSF(User defined Scalar Functions), this is an assumption, not tried yet, since the documentation shows API usage only for this type of UDx.

Make sure when you develop a UDx, you test it for performance, since Python is interpreted language different than JAVA and C++. I wonder, if it would not be that much faster as compared to UDx in C++, JAVA SDK.

I will be trying this as soon as a I upgrade to 8.0.

Meanwhile enjoy the available option and go ahead develop something useful for the Vertica community with Python SDK.

About the author / 

Navin Chakraborty

Navin is a Senior Software Engineer with 4 years of experience working with Vertica. He author's his own blog at Vertica-howto and contributes regularly on

Leave a Reply

This site uses Akismet to reduce spam. Learn how your comment data is processed.

Upcoming Events

  • No upcoming events
AEC v1.0.4

Subscribe to Blog via Email

Enter your email address to subscribe and receive notifications of new posts by email.

Read more use cases here.


This site is not affiliated, endorsed or associated with HPE Vertica. This site makes no claims on ownership of trademark rights. The author contributions on this site are licensed under CC BY-SA 3.0 with attribution required.
%d bloggers like this: