By using AWS re:Post, you agree to the AWS re:Post Terms of Use
AWS re:Postre:Post

AWS Glue Datatype Numeric giving issue

0

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 EXPERT
    2 years ago

    could you please describe more the issue you have with the query in Athena? an example would be great. Thank you

Topics
AnalyticsDatabase
Tags
Amazon AthenaAnalyticsAWS Glue DataBrewExtract Transform & Load DataAmazon Redshift
Language
English
Usman
asked 2 years ago492 views
1 Answer
1
  1. Did you create the table in Glue data catalog by crawling redshift?
  2. Can you also provide the Athena error message?
AWS
SUPPORT ENGINEER
Manu_G
answered 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

Relevant content