creating Athena table error
Taegu Kang1 min read
- outline
Error occurs when creating table for Athena.
- error message
line 1:8: mismatched input 'EXTERNAL'. Expecting: 'MATERIALIZED', 'OR', 'ROLE', 'SCHEMA', 'TABLE', 'VIEW'
- resolution
You can use NOT "-" as part of table name. After change "-" to "_" and create again.
0
Subscribe to my newsletter
Read articles from Taegu Kang directly inside your inbox. Subscribe to the newsletter, and don't miss out.
AWSaws athenatableline 1:8: mismatched input 'EXTERNAL'. Expecting: 'MATERIALIZED', 'OR', 'ROLE', 'SCHEMA', 'TABLE', 'VIEW'name
Written by