AWS Glue Datatype Numeric giving issue

Question

I've glue catalog and use s3 as DB. Datatype of columns are numeric in Redshift which i'm casting as decimal in Glue. But getting issue while querying the data in Athena. Column in redshift looks like (-12.887686) with data type Number. we cannot change the data type in source table

Fabrizio@AWS ESPECIALISTA
há 2 anos
could you please describe more the issue you have with the query in Athena? an example would be great. Thank you

Answer

1. Did you create the table in Glue data catalog by crawling redshift? 
2. Can you also provide the Athena error message?

AWS Glue Datatype Numeric giving issue

Conteúdo relevante