2 Respostas
- Mais recentes
- Mais votos
- Mais comentários
0
Hi,
In Redshift for storing JSON data we have introduced the SUPER data type.
However, the SUPER data type only supports up to 1MB of data for an individual SUPER field or object. For more information, see Ingesting and querying semistructured data in Amazon Redshift.
hope this helps,
0
We are encountering a similar issue where we're utilizing the "super" datatype, which has a maximum length of 65K. However, the column in the Parquet file we receive has a maximum length of 192K. How should we handle this data? Are there alternative datatypes we can use to accommodate such large data sizes?
respondido há um mês
Conteúdo relevante
- AWS OFICIALAtualizada há 2 anos
- AWS OFICIALAtualizada há 2 anos
- AWS OFICIALAtualizada há 2 anos
How big is your JSON data?
try using text data type, supported in postgres and redshift.