Rows fail to import because integers too large

[evanct]

In my Athena dataset I have a bigint field whose values are sometimes in the hundreds of trillions. When I make the analysis, QS always fails to import those rows where that is the case. Is there a workaround for this?

My idea was to divide those values by 1000 in the SQL so that they’ll import, then multiply them by 1000 in the analysis(of course I’d lose precision but it’s better than nothing) But when I try to do the multiplication, QS gives me an overflow error.

[robdhondt]

Hi @evanct -

If the bigint values aren’t required for further arithmetic operations you can change the fields datatype to a String in data prep. I’ve used this approach for UIDs etc…