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

INVALID_CAST_ARGUMENT: Cannot cast '' to DOUBLE - Error

0

I have been using the below statement to retrieve the sum of all the values from that column as shown below SUM(CAST(column1 AS DOUBLE)) as cnt but now it is erroring out with the below error

INVALID_CAST_ARGUMENT: Cannot cast '' to DOUBLE This query ran against the "imdsout" database, unless qualified by the query. Please post the error message on our forum or contact customer support with Query Id: 004997cb-e355-445c-b502-28ecd8f8aaaf

Topics
Analytics
Tags
Amazon Athena
Language
English
rePost-User-2359319
asked a year ago3096 views
2 Answers
1
Accepted Answer

Hi, does column1 contain empty string? If so it will throw a cast error.

If so, make sure to use where clause to excluded unwanted values such as ‘’.

Hope it helps ;)

profile picture
EXPERT
Antonio_Lagrotteria
answered a year ago
0

Thank you @alatech. Yes it did contain empty string. Once I excluded it works.

rePost-User-2359319
answered a year 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