2개 답변
- 최신
- 최다 투표
- 가장 많은 댓글
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?
답변함 한 달 전
관련 콘텐츠
- 질문됨 한 달 전
- AWS 공식업데이트됨 2년 전
- AWS 공식업데이트됨 일 년 전
How big is your JSON data?
try using text data type, supported in postgres and redshift.