python buffer size when querying Vertica using Pyodbc -

i using pyodbc connect vertica db , using cursor execute query results of query include text field huge, execute runs never returns anything, not exception. can see when debug , break point @ row=cursor.fetchall() comes empty "[]"

if try dataset less characters in huge text field execute runs , data. suspecting has buffer size when retrieving data don't know. suggestions on how this? maybe increase buffer size somehow?

thanks

import requests, pypyodbc, json, pyvertica, pyodbc pyvertica import connection     conn=pyodbc.connect("dsn=hpvertica;uid=muffin;pwd=muffin")     cursor=conn.cursor()     query="select field1_int, field2_bigtext  sometable field1_int=103;"      try:         cursor.execute(query)     except exception e:         print('err: {}'.format(e.args[0]))         print(': {}'.format(e.args[1]))      row=cursor.fetchall() 

i believe known issue in pyodbc, @ least sure i've seen complained before , random patches. looked @ pyodbc code , looks fixed issue in this commit couple weeks ago.

it doesn't appear in latest (as of post) tag of 3.0.10. you'd either have try bleeding edge or wait little longer included in future tag. (or patch based on commit, guess).