Guest User

Untitled

a guest
Mar 9th, 2018
101
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.83 KB | None | 0 0
  1. import teradata as td
  2. udaExec = td.UdaExec(appName = "TeradataConnection", version = "1.0", logConsole = False)
  3. TDconn = udaExec.connect( method = "odbc",
  4. system = "mySystem",
  5. username = usrName,
  6. password = psswd')
  7.  
  8. import pandas as pd
  9. tddf = pandas.read_sql(myTDsQLqury, TDconn)
  10.  
  11. x = 0.7 typ: <class 'float'> ,y = 0.7000000000000001 typ: <class 'float'> comparision = False
  12. x = 1.797 typ: <class 'float'> ,y = 1.7970000000000002 typ: <class 'float'> comparision = False
  13. x = 1.011 typ: <class 'float'> ,y = 1.0110000000000001 typ: <class 'float'> comparision = False
  14.  
  15. from teradata import datatypes
  16.  
  17. udaExec.connect("${dataSource}", dataTypeConverter=datatypes.DefaultDataTypeConverter(
  18. useFloat=True))
Add Comment
Please, Sign In to add comment