Guest User

Untitled

a guest
Jun 26th, 2018
123
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.49 KB | None | 0 0
  1. import teradata
  2. import pandas as pd
  3.  
  4. udaExec = teradata.UdaExec (appName="Hello", version="1.0",
  5. logConsole=False)
  6. session = udaExec.connect(method="odbc", system="tdprod",
  7. username="xxx", password="xxx");
  8.  
  9. sqlStr = "CREATE SET TABLE "TEST123"
  10. (col1 INTEGER) PRIMARY INDEX (col1);"
  11.  
  12. result = pd.read_sql(sqlStr, self.session)
  13.  
  14. File "..pandasiosql.py", line 1436, in read_query
  15. columns = [col_desc[0] for col_desc in cursor.description]
  16.  
  17. TypeError: 'NoneType' object is not iterable
Add Comment
Please, Sign In to add comment