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