'truncated incorrect INTEGER VALUE : 'EN_US'
got this error when I tried to create a table 'top20bypopulation' from a select statement
query :
CREATE table top20bypopulation as
SELECT Name,format(Population,'EN_US') as population FROM country
ORDER BY Population DESC
LIMIT 20;
error :
truncated incorrect INTEGER VALUE : 'EN_US'
But the SELECT runs okey, but when I create table out of it, it gives this error.
I am new to this language, someone please answer how to achieve this.
Sources
This article follows the attribution requirements of Stack Overflow and is licensed under CC BY-SA 3.0.
Source: Stack Overflow
| Solution | Source |
|---|
