You signed in with another tab or window. Reload to refresh your session.You signed out in another tab or window. Reload to refresh your session.You switched accounts on another tab or window. Reload to refresh your session.Dismiss alert
Sorry, I have no privileges to create tables on the Redshift DB.
Reproduction code
with conn.cursor() as cur:
cur.execute(sql)
tuples_list = cur.fetchall()
dataframe = pd.DataFrame(tuples_list, columns=[desc[0] for desc in cur.description], dtype="object")
for field in cur.description:
print(field)
The text was updated successfully, but these errors were encountered:
Driver version
redshift-connector==2.1.1
Redshift version
Redshift 1.0.77292
Client Operating System
Windows 11
Python version
Python 3.9.5
Table schema
select
GS_PE
SC_PE
SUM(SALDO_EUR)
from
Table
Problem description
When we use functions such as sum() the query result should display the exact column name like we have defined in the SQL-Query
When we use functions such as sum() the query result is missing the column name within the functions brackets
No error message for this issue.
Result:
('gs_pe', 1043, None, None, None, None, None)
('sc_pe', 1043, None, None, None, None, None)
('sum', 1700, None, None, None, None, None)
Expected Result:
('gs_pe', 1043, None, None, None, None, None)
('sc_pe', 1043, None, None, None, None, None)
('sum(saldo_euro)', 1700, None, None, None, None, None)
Python Driver trace logs
Sorry, I have no privileges to create tables on the Redshift DB.
Reproduction code
The text was updated successfully, but these errors were encountered: