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
bug: When I alias a dataframe and subsequently use SQL that references its columns, the aliasing process might not allow direct referencing of the original column names.
#9152
Open
1 task done
stereoF opened this issue
May 8, 2024
· 0 comments
What happened?
I have an Ibis dataframe named df with a column named account_id:
df.columns
['user_id', 'account_id', 'algo_user_addsteps_rate_30d', 'algo_user_pay_num', ..., 'province_shift_7d', 'city_shift_7d']
When I alias this dataframe as df and try to use it in a SQL query:
df1 = df.alias('df').sql('select *, halfMD5(account_id) as id_md5 from df')
I encounter the following error:
Based on the error message, I must manually adjust the query as follows to execute it correctly:
What version of ibis are you using?
9.0.0
What backend(s) are you using, if any?
clickhouse
Relevant log output
No response
Code of Conduct
The text was updated successfully, but these errors were encountered: