how to solve this error


FAILED: Execution Error, return code 1 from org.apache.hadoop.hive.ql.exec.DDLTask. java.lang.NullPointerException

asked 2 years ago794 views
1 Answer

Hi There

Could you provide some additional info about what you are doing with Athena? IN the meantime, please take a look at this troubleshooting article and see if it applies to your use case.

You get this error when the attribute TableType isn't defined for the queried table in the AWS Glue Data Catalog. The TableType attribute defines whether the table is an external table or a view. This attribute can be defined with values, such as EXTERNAL_TABLE and VIRTUAL_VIEW. If you want to run DDL queries, such as SHOW CREATE TABLE or MSCK REPAIR TABLE, then you must define the TableType attribute.

profile pictureAWS
answered 2 years ago
profile pictureAWS
reviewed 2 years ago

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