Search code examples
postgresqlamazon-web-servicesintegeramazon-athenabigint

Athena doesn't show column create as BIGINT

We tried to upload a csv file with column 'cpf' on AWS-Athena, the field cpf contains numbers like this '372.088.989-03'

create external table (
    cpf bigint,
    name string
    cell bigint
)

Athena doesn't read this field, how can i register?

we try to register like string and this works but is not correct

Solution

  • Ah! It's the CPF number - Wikipedia.

    It does not match rules for numbers, and you won't be doing any mathematics on it, so I would recommend treating the CPF as a string.