PyTd
PyTd copied to clipboard
A Python Module to make it easy to script powerful interactions with Teradata Database in a DevOps friendly way.
OS: macOS 10.13.2 Python: 2.7.14 Teradata ODBC Driver for Mac OS X: 16.20.00.0006 unixodbc: Not installed I am able to test a successful connection using the following operations on command...
I got the following error using the package on Ubuntu (with Teradata ODBC 16.00 driver installed). ``` DatabaseError: (0, '[I] [. Check that the ODBC driver is installed and the...
Allow for optional JDBC support when/if the proper JDBC support packages are installed. There is an active project called JayDeBeApi that is supposed to support Teradata: https://pypi.python.org/pypi/JayDeBeApi/ https://github.com/baztian/jaydebeapi Might support...
Two small performance improvements: - In `convertValue`, if `typeCode` is `STRING` the long `if...elif...else` sequence is short-circuited. - Lists of types (`NUMBER_TYPES`, `INT_TYPES`, etc. are cast to sets for O(1)...
Performance improvements included in this PR: - Store `ctypes.sizeof(SQLWCHAR)` once rather than re-calculating on each value conversion - Return `list(self)` in `fetchall` instead of using a `for` loop Cheers!
The method `convertValue` of `DefaultDataTypeConverter` contains the following line (L230-L231): ``` logger.trace( "Converting \"%s\" to (%s, %s).", value, dataType, typeCode) ``` This results in many calls to `logger.isEnabledFor`, even when...
While testing the `udaExec.connect(method='odbc', system='dwhdev', username='ETL_TEST', password='password')` we encounter the following malloc error. When we switch to TTU 14.10 and 16.00 on different hosts to isolate the issue, we realized...
Please add the support to connect to and run SQL on Teradata Aster Platforms
Hi , I am running multiple instances of the a python script simultaneously , and got a race condition on the deleting of old logs. (def _cleanupLogs). This is the...
PyTd version is 15.10.0.18. When using PyTd to create procedure, if the deployment user doesn't have permission, it doesn't fail the query but showing query successful. By drilling down, it...