1 Answer
- Newest
- Most votes
- Most comments
0
An asterisk qualified by a table name (from your example, spine_table.*
) will be expanded to every column of that table that is not listed in the USING clause. But since spine_table
does not have any other column you are getting that error.
You will need to find a way to switch from using (user_id)
to on spine_table.user_id = feature_table.user_id
The error message language is misleading and should have been saying something better. I request you to use the Feedback
link on bottom left of Athena page and submit the feedback Type as Report an issue
.
answered a year ago
Relevant content
- asked a year ago
- asked 5 years ago
- AWS OFFICIALUpdated a year ago
- AWS OFFICIALUpdated 13 days ago
- AWS OFFICIALUpdated 2 months ago