PyTd

PyTd copied to clipboard

Issue with LDAP Authentication using IPython through Anaconda

1

I am using teradata version 15.10.0.21 through the Anaconda distribution and am unable to connect with the following commands: `import teradata` `udaExec = teradata.UdaExec (appName="TD", version="1.0", logConsole=False)` `session = udaExec.connect...

ackshooairy

Memory Allocation Error

6

Is this error familiar to anyone? `[HY001] [Teradata][ODBC Teradata Driver] Memory allocation error` It occurs sometimes when I try to bulk insert using the python TD module, but I haven't...

jamesmf

Please enable cancel operation for teradata sql execution.

2

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...

praveen-kanamarlapudi

Selecting from decimal (18,6) return NaN in pandas

2

Evn: Python 3.6, windows 10, Connection: ``` connect = udaExec.connect( method="odbc", system='***', username= username, password= password, driver="Teradata Database ODBC Driver 16.10", dataTypeConverter=datatypes.DefaultDataTypeConverter( useFloat=False) #tried setting to True - same results...

Diyago

Returning generated keys from parameterized INSERT query fails, identical non-parameterized query succeeds

10

To reproduce, first set up a connection and table like this: ``` conn = udaExec.connect(..., ReturnGeneratedKeys="C") curs = conn.cursor() curs.execute('''CREATE TABLE testautokeyreturn (tablekey BIGINT GENERATED ALWAYS AS IDENTITY (START WITH...

ShaunCurrier

Unexpected Unicode Conversion Error

10

I've been plagued by hard-to-predict `Unicode Conversion Errors` while trying to insert non-Unicode data into existing TD tables. The data being inserted is 2 integer columns and 20 floats, stored...

jamesmf

SQL with escape character for LIKE clause can fail with syntax error

1

As long as `escape '!'` or `escape '\\'` is following LIKE clause in ODBC mode, PyTd fails into the following error: ``` SELECT DatabaseName, PermSpace, DBKind FROM DBC.DatabasesV WHERE DatabaseName...

ericsun2

The default driver selected when TPT is installed is not correct.

2

The logic for choosing the default driver to use when one is not specified does not work when TPT is installed. This is because it registers additional drivers with the...

escheie

Teradata ODBC 16.20 - Bug in SQLColumns[W] ?

1

I am in a process of elevating a project to 16.20. There is an existing code that implements metadata queries via ODBC SQLColumn API. It used to work fine in...

H-Eilat

Support for Teradata SIMBA ODBC 16.20 driver + unixODBC?

1

Hi, With 16.20 SIMBA ODBC driver, Teradata officially supports unixODBC driver manager. I am able use Teradata SEN ODBC driver with unixODBC DM using `isql` and `iusql` utilities. I can...

padhia