All Forums Extensibility
emerrf 1 post Joined 01/15
13 May 2015
Deploy a Customized Python interpreter

I was able to run a python script using SCRIPT_COMMAND like the following example: http://www.info.teradata.com/htmlpubs/DB_TTU_15_00/ index.html#page/SQL_Reference/B035_1145_015K/ Table_Operators.087.31.html
My question is: can a python interpreter/distribution be deployed into the Teradata infrastructure?
I managed to copy the Python Anaconda standalone distribution in a place like /var/opt/teradata/tdtemp/uiflib/anaconda/bin/python, then the python application used that environment because the first line of the script was: #!/var/opt/teradata/tdtemp/uiflib/anaconda/bin/python instead of #!/usr/bin/python. However, is there an easy way to deploy this python environment to all the machines that configure a Terdata infrastructure? 
 
 
 
 

 

Alexander K 22 posts Joined 09/13
18 Jun 2015

Hi,
I think you might find the Orange Book "R and Python Analytics with the SCRIPT Table Operator" both interesting and useful for what you want to do. Its Section 3.3.2 is all about installing the Anaconda Python distribution on a Teradata database system >= v.15.00. See details at:
http://forums.teradata.com/forum/analytics/teradata- in-database-r-and-python-analytics-with-the-script- table-operator-0
If you are using Teradata v.15.10, an issue was discovered very recently that is not covered by the above Orange Book. Specifically, Anaconda Python uses the libcrypto library v.1.0.0, which is incompatible with the libcrypto.so.0.9.8 needed by Teradata >=15.10. This issue will be resolved relatively soon, but until then, one will be unable to load packages like "pandas" and "statsmodels" via Anaconda Python on Teradata 15.10.
Bests,
Alexander

You must sign in to leave a comment.