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'

주제

분석 데이터베이스

태그

아마존 Athena 데이터베이스

언어

English

Denys

질문됨 2년 전266회 조회

1개 답변

최신
최다 투표
가장 많은 댓글

이 답변이 도움이 되었나요?커뮤니티가 여러분의 지식을 활용할 수 있도록 정답을 찬성하세요.

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 - https://aws.amazon.com/premiumsupport/knowledge-center/parse-exception-missing-eof-athena/

전문가

AWS-User-Nitin

답변함 2년 전

Amazon Athena SHOW CREATE TABLE is failing

관련 콘텐츠