Using TPT loader and DataConnector version 15.10.01.00 produce above error. I am using following script to load about 100M rows
DEFINE JOB test_tbl( SET TargetWorkingDatabase = 'DLABDVTPTTEST'; SET DCPFormat = 'Delimited'; SET DCPOpenMode = 'Read'; SET DCPTextDelimiterHEX = 'ED'; SET DCPDirectoryPath = 'data/'; SET DCPNullColumns = 'Yes'; SET DCPTruncateColumnData = 'Yes'; SET LoadErrorLimit = 1; SET DDLErrorList = ['3807','3624']; STEP TruncTbl ( APPLY ('DELETE FROM test_tbl;') TO OPERATOR ($DDL); ); STEP Load_test_tbl ( APPLY $INSERT TO OPERATOR ( $LOAD ATTR( TargetTable='test_tbl', QueryBandSessInfo='JobId=' || $JOBID || ';UtilityDataSize=MEDIUM;' ) ) SELECT * FROM OPERATOR ( $FILE_READER(DELIMITED 'DLABDVTPTTEST.test_tbl') ATTR(FileName='test_tbl_20160211.txt.gz') ); ););
Any clue on what could be wrong?
rights to materials on this website, the rights you grant to your submissions to this website, and your responsibilities regarding your conduct on this website.