'Redshift COPY error what is the root problem of "error: Assert code: 1000 context: false - Invalid type:"
I have tried to copy data from orc into redshift table and I receive the error:
ERROR: Assert Detail:
-----------------------------------------------
error: Assert code: 1000 context: false - Invalid type: 6551 query: 44660
location: dory_util.cpp:361 process: padbmaster [pid=27395]
-----------------------------------------------
[ErrorId: 1-62340eaf-66cfc1cb4a51374b1ea75e4d]
I don't event know what the problem, I assume it is a datatype problem but no idea where. How to do get more info to be able to fix this problem?
CREATE TABLE IF NOT EXISTS "schema"."table" (
col1 varchar(256),
col2 int,
col3 varbyte,
col4 timestamp,
col5 timestamp,
col6 int,
"spid" int,
col7 varchar(256),
col8 varchar(256)
)
This is where the error occurs:
COPY "schema"."table"
FROM 's3://<bucket>/database/table/' IAM_ROLE 'arn:aws:iam::123456789:role/TestIAM'
FORMAT AS ORC
Sources
This article follows the attribution requirements of Stack Overflow and is licensed under CC BY-SA 3.0.
Source: Stack Overflow
| Solution | Source |
|---|
