search

Teradata / PyTd

A Python Module to make it easy to script powerful interactions with Teradata Database in a DevOps friendly way.
MIT License
108 stars 43 forks source link

Please enable cancel operation for teradata sql execution. #98

Open praveen-kanamarlapudi opened 6 years ago

praveen-kanamarlapudi commented 6 years ago

We are using PyTd with jupyter notebooks. Interrupting the kernel generated KeyboardInterrupt exception. But PyTd is ignoring the KeyboardInterrupt exception and not canceling the sql submitted and waiting for the sql to be completed.

Sample code:

import teradata

udaExec = teradata.UdaExec(appName="Jupyter Notebooks", version="1.0",
                                   logConsole=False)

connection = udaExec.connect(method="odbc",
                             system='teradata_host_name',
                             username=username,
                             password=password.replace('$', '$$'))

result = connection.execute(LONG_RUNNING_SQL)

It waits for the sql to be completed and doesn't cancel the executing sql.

praveen-kanamarlapudi commented 6 years ago

@escheie Any thoughts on this issue?

pkasinathan commented 5 years ago

Any updates on this issue?