HIVE_METASTORE_ERROR: com.amazonaws.services.datacatalog.model.InvalidInputException: Error: type expected at the position 0 of 'text' but 'text' is found.

0

Running any query in Athena on a particular table "sometable" fails after ~15 seconds eg:

SELECT * FROM "somedatabase"."sometable" limit 10;

And returns this error message

HIVE_METASTORE_ERROR: com.amazonaws.services.datacatalog.model.InvalidInputException: Error: type expected at the position 0 of 'text' but 'text' is found. (Service: null; Status Code: 0; Error Code: null; Request ID: null; Proxy: null)

We double checked that data type declarations have no upper/camel casing and column names do not contain invalid characters such as spaces or hyphens. How can we pinpoint the problematic column or identify what's causing the error?

azhang
asked a year ago82 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