I'm a Python dev for the past couple of years and connecting to PostgreSQL using the psycopg2 module.
Now, I'm using Teradata Aster, as my training, I tried creating a simple sql-mr function using a python. Given the table, the sql-mr will populate the tables with random values.
What do I need to connect to a Aster Database?
I see a lot of Java code that do this but I can't seem to find a Python version of this.
Other SQL-MR Example using Python would be a great help!
Basically my code will be like this:
import jdbc, sys
conn = Connect(AsterDatabase, Username, Password, Host, Port)
cur = conn.cursor()
cur = getTableColumnsAndDatatype()
records = generateRecords()
for record in records:
cur.execute("INSERT INTO table(....)VALUES(record)")
“SQL-MapReduce and Stream API for Python, Perl, and Other Types of Scripts” section of the “Teradata Aster Big Analytics Appliance DatabaseUser Guide” contains example of a python script which could be invoked in Aster Stream query to generate a small sample table.