'cast function with expression :: types throw mismatched inputs ":" error in Amazon Athena Query Editor
According to Amazon Athena documentation one should be able to use the syntax expression :: type to cast a variable. Trying to run the example on the Query Editor throws an error:
select 123.456::decimal(2,1);
>>> line 6:15: mismatched input ':'. Expecting: '%', '*', '+', '-', '.', '/', 'AT', '[', '||', <expression>
I guess the issues is related to serialization / inputs types. Is there a way (like character escaping) to make it pass and use this convenient syntax ?
Sources
This article follows the attribution requirements of Stack Overflow and is licensed under CC BY-SA 3.0.
Source: Stack Overflow
| Solution | Source |
|---|