Teradata/PyTd

Please enable cancel operation for teradata sql execution.

praveen-kanamarlapudi opened this issue · 2 comments

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.

@escheie Any thoughts on this issue?

Any updates on this issue?