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.
Relevant content
- asked a year ago
- asked 3 years ago
- asked 7 years ago
- AWS OFFICIALUpdated 4 years ago
