"Could not serialize column Error" in Athena

0

I am trying to use the crowdstrike.crowdstrike_summary.removable_media_write_hour database but am getting the following serialization error: "SERIALIZATION_ERROR: Could not serialize column 'cem_employment_start_date' of type 'timestamp(3)' at position 1:28. This query ran against the "crowdstrike_summary" database, unless qualified by the query. Please post the error message on our forum or contact customer support with Query Id: 1e850429-dd42-48b8-8db3-0936c8ec2775". The query I am running is the following: "SELECT * FROM "crowdstrike_summary"."removable_media_write_hour" limit 10;"

slbush
질문됨 일 년 전1914회 조회
1개 답변
1

Cause: Athena engine version 3 checks to make sure that the precision of timestamps in the data is the same as the precision specified for the column data type in the table specification. Currently, this precision is always 3. If the data has a precision greater than this, queries fail with the error noted. reference: https://docs.aws.amazon.com/athena/latest/ug/engine-versions-reference-0003.html

If you need date from the column, you can try SELECT DATE(my_problem_column) FROM my_table. Basically changing the format of timestamp to date type.

insub
답변함 일 년 전
AWS
전문가
검토됨 일 년 전

로그인하지 않았습니다. 로그인해야 답변을 게시할 수 있습니다.

좋은 답변은 질문에 명확하게 답하고 건설적인 피드백을 제공하며 질문자의 전문적인 성장을 장려합니다.

질문 답변하기에 대한 가이드라인

관련 콘텐츠