Python in Database

Analytics

Python in Database

This press release http://www.computerweekly.com/news/2240217675/Teradata-Database-15-adds-JSON-addresses-internet-of-t... says Teradata 15 supports "in the core database for scripting languages Perl, Ruby, Python and R" 

It would be great to be able to do things in Teradata with Python like this: http://www.postgresql.org/docs/8.2/static/plpython-funcs.html

Greatly appreciate any pointers to technical documentation and code samples.  

Cheers!

Tags (1)
2 REPLIES
Senior Apprentice

Re: Python in Database

As for any new feature, check the Release Summary for this version.

The SCRIPT table operator is not for implementing Python functions, but Phyton/Perl/etc. scripts, i.e. TD pipes rows as strings into a Phyton script and then the output is piped back into TD:

TD || Phyton shell script || TD

Re: Python in Database

Thanks Dieter,

For anyone else that had trouble finding it go to page 1296 in the SQL Functions, Operators, Expressions, and Predicates manual. Looks like you have to download the pdf version - couldn't find the Teradata 15 manuals online so a search for "Python Teradata" doesn't find much.

Curious to learn about production uses of SCRIPT table operators and challenges and how people are using them - especailly to do analytics in Python, R, etc....

Cheers,  Bob