Câu 147: SnowPro Core
A table needs to be loaded. The input data is in JSON format and is a concatenation of multiple JSON documents. The file size is 3 GB. A warehouse size S is being used. The following COPY INTO command was executed:COPY INTO SAMPLE FROM @~/SAMPLE. JSON (TYPE=JSON)The load failed with this error:Max LOB size (16777216)…
Nội dung câu hỏi
A table needs to be loaded. The input data is in JSON format and is a concatenation of multiple JSON documents. The file size is 3 GB. A warehouse size S is being used. The following COPY INTO command was executed:COPY INTO SAMPLE FROM @~/SAMPLE. JSON (TYPE=JSON)The load failed with this error:Max LOB size (16777216) exceeded, actual size of parsed column is 17894470. How can this issue be resolved?
Các lựa chọn
Đáp án được giữ gọn theo nhãn A, B, C, D trong phần bình chọn tương tác.
- A. Compress the file and load the compressed file.
- B. Split the file into multiple files in the recommended size range (100 MB - 250 MB).
- C. Use a larger-sized warehouse.
- D. Set STRIP_OUTER_ARRAY=TRUE in the COPY INTO command. — đáp án hiện tại
Cộng đồng
0 bình luận công khai. Tên thành viên được ẩn một phần.