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
asked 4 months ago9 views
1 Answers
1
- Did you create the table in Glue data catalog by crawling redshift?
- Can you also provide the Athena error message?
Relevant questions
Can AWS Glue handles complex transformation jobs like Talend. Can any one share their observations around AWS Glue vs any standard ETL
asked 4 months agoAWS Glue Datatype Numeric giving issue
asked 4 months agoHow could we have Glue to get data from csv as String?
Accepted Answerasked 6 days agoLoading json string data as super from Glue job in to Redshift
asked 5 months agoCost of Athena and glue
asked 5 months agoWhat is the sizekey parameter in AWS Glue Catalog Data properties?
Accepted Answerasked 2 years agoUnsupported case of DataType
asked a month agoHow to avoid transforming data for a dropped column without updating glue catalog
asked a month agoGlue to automatically create target schema
Accepted Answerasked 5 years agoAWS glue Upsert operation for few columns
asked 2 months ago
could you please describe more the issue you have with the query in Athena? an example would be great. Thank you