Amazon Athena SHOW CREATE TABLE is failing


When database contains - in the name, the Show Create Table for the table in that DB is failing.

For example:

For test_table.db1

SHOW CREATE TABLE db1 or SHOW CREATE TABLE test_table.db1 both return FAILED: ParseException line 1:11 missing EOF at '-' near 'test'

demandé il y a 2 ans256 vues
1 réponse

You are right that you get this error when the database name specified in the DDL statement contains a hyphen ("-"). AWS Glue allows database names with hyphens. However, underscores (_) are the only special characters that Athena supports in database, table, view, and column names.

To resolve this issue, recreate the database with a name that doesn't contain any special characters other than underscore (_).

Reference -

profile pictureAWS
répondu il y a 2 ans

Vous n'êtes pas connecté. Se connecter pour publier une réponse.

Une bonne réponse répond clairement à la question, contient des commentaires constructifs et encourage le développement professionnel de la personne qui pose la question.

Instructions pour répondre aux questions