snowflakedb / snowflakedb/snowpark-python
SNOW-1597225: Selecting duplicate column using original df fails
Open
@sfc-gh-jrose is already working on this.
Since Aug 13, 2024.
bug
local testing
needs triage
- Dominant language
- Python
- Stars
- 341
- Forks
- 155
- Avg merge
- 4d 16h
- Merged PRs (30d)
- 27
Description
Please answer these questions before submitting your issue. Thanks!
-
What version of Python are you using?
Python 3.10.13 (main, Feb 13 2024, 16:41:04) [Clang 15.0.0 (clang-1500.1.0.2.5)]
-
What are the Snowpark Python and pandas versions in the environment?
pandas==2.2.2
snowflake-snowpark-python==1.20.0 -
What did you do?
from snowflake.snowpark import Session
s = Session.builder.config("local_testing", True).create()
df1 = s.create_dataframe([{'id': 1, 'foo': 'bar'}])
df2 = s.create_dataframe([{'id': 1, 'taz': 'baz'}])
df1.join(df2, on=df1['id'] == df2['id']).select(df2['id']).show() # KeyError: '"ID"'
- What did you expect to see?
Snowflake connection would know to resolve the ID column from df2.
Contributor guide
First steps
- Read the whole issue, then the project's contributing guide.
- Comment on the issue to say you are picking it up — it saves two people doing the same work.
- Fork the repository and make your change on a branch.
- Open a pull request that references the issue number.
Assessment
This issue has not been assessed yet.