Structure of a Glue Table can not be viewed in AWS Athena

0

When Glue table is created in CDK V2, AWS Athena can not SHOW CREATE TABLE over it.

[ErrorCategory:USER_ERROR, ErrorCode:DDL_FAILED], Detail:FAILED: Execution Error, return code 1 from org.apache.hadoop.hive.ql.exec.DDLTask. java.lang.NullPointerException

Is there a kind of limitation?

  • I don't think it is related with CDK but with the table definition being invalid (missing something)

  • But the table works well. I can do SELECT / INSERT etc.

  • That is peculiar but not altogether surprising, to generate the DDL it needs everything, to query maybe doesn't need whatever is missing. I would create a similar table with Athena or the console and compare what are you missing in CDK, depends a lot on the kind of table

profile picture
Smotrov
asked 10 months ago87 views
No Answers

You are not logged in. Log in to post an answer.

A good answer clearly answers the question and provides constructive feedback and encourages professional growth in the question asker.

Guidelines for Answering Questions