AWS Glue Datatype Numeric giving issue
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
could you please describe more the issue you have with the query in Athena? an example would be great. Thank you
- Did you create the table in Glue data catalog by crawling redshift?
- Can you also provide the Athena error message?
Can AWS Glue handles complex transformation jobs like Talend. Can any one share their observations around AWS Glue vs any standard ETLasked 4 months ago
AWS Glue Datatype Numeric giving issueasked 4 months ago
How could we have Glue to get data from csv as String?Accepted Answerasked 6 days ago
Loading json string data as super from Glue job in to Redshiftasked 5 months ago
Cost of Athena and glueasked 5 months ago
What is the sizekey parameter in AWS Glue Catalog Data properties?Accepted Answerasked 2 years ago
Unsupported case of DataTypeasked a month ago
How to avoid transforming data for a dropped column without updating glue catalogasked a month ago
Glue to automatically create target schemaAccepted Answerasked 5 years ago
AWS glue Upsert operation for few columnsasked 2 months ago