2 réponses
- Le plus récent
- Le plus de votes
- La plupart des commentaires
0
as an example if you have a column defined as a "double" in the schema but there's a record in your data that's an empty string, you'll get this error.
to solve this
Check Your Data Check Your Schema
or you can try another SQL server to remove spaces or other irrelevant data from the imported data
SELECT CASE
WHEN trim(column_name)='' THEN null
ELSE cast(column_name as double)
END as column_name
FROM table_name
0
Such error can occur when the table column with "double" data type is having an empty record value in it. Validate your data of the impacted column and replace the empty records with 0 or NULL using SQL statement syntax supported by Presto. Else, if possible you can also try changing the data type of the columns. Similar issues are highlighted in AWS knowledge center article 1 and article 2 also.
Contenus pertinents
- demandé il y a 2 mois
- demandé il y a 7 mois
- demandé il y a 6 mois
- AWS OFFICIELA mis à jour il y a un an
Thank you for the answer:) I tried this but I got an error because trim cannot be applied to double.