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
preguntada hace un año93 visualizaciones
No hay respuestas

No has iniciado sesión. Iniciar sesión para publicar una respuesta.

Una buena respuesta responde claramente a la pregunta, proporciona comentarios constructivos y fomenta el crecimiento profesional en la persona que hace la pregunta.

Pautas para responder preguntas