- Newest
- Most votes
- Most comments
Can you please confirm where are you trying to create the table ? If you are trying to create table in Athena with text datatype, Athena doesn't support text data type. For list of supported data types in Athena, please refer [1]. I tested it on my end and received below error
FAILED: ParseException line 1:34 cannot recognize input near 'text' ')' 'ROW' in column type This query ran against the "default" database, unless qualified by the query. Please post the error message on our forum or contact customer support
From the error it looks like the table DDL is unable to handle the data with special characters. If you are creating table with AWS Data Exchange, I would recommend please open a support ticket with our AWS Data Exchange queue and please provide some sample data for us to test and dive deep into the issue
REFERENCES:
[1] https://docs.aws.amazon.com/athena/latest/ug/data-types.html
Relevant content
- Accepted Answerasked 2 years ago
- asked 2 years ago
- AWS OFFICIALUpdated a year ago
- AWS OFFICIALUpdated 4 months ago
- AWS OFFICIALUpdated 2 months ago