I use pandas to read from Vertica DataBase:
pd.read_sql(query, self._conn)
But it fails with
UnicodeDecodeError: 'utf-8' codec can't decode byte 0xe9 in position 1: invalid continuation byte.
Other queries don't fail, so the problem is in some specific column from this query.
I need all data - what should i do? I can make changes in Vertica too, but i can't change the table values...
P.S. This is how i create a connection for Vertica:
conn_info = url2vertica(url)
conn_info["read_timeout"] = 2400
conn_info["ssl"] = False
vrt = vertica_python.connect(**conn_info)