kettle在读写excel 96万行的时候报错
2023/05/14 13:22:26 - Excel输入.0 - ERROR (version 9.3.0.0-428, build 9.3.0.0-428 from 2022-04-12 04.56.25 by buildguy) : 错误处理 Excel 文件 [D:\22年8-9-10月.xlsx] 中的行 : java.lang.RuntimeException: com.ctc.wstx.exc.WstxIOException: Zip bomb detected! The file would exceed the max size of the expanded data in the zip-file.
This may indicates that the file is used to inflate memory usage and thus could pose a security risk.
You can adjust this limit via ZipSecureFile.setMaxEntrySize() if you need to work with files which are very large.
Uncompressed size: 4294969354, Raw/compressed size: 471441408
Limits: MAX_ENTRY_SIZE: 4294967295, Entry: xl/worksheets/sheet1.xml
2023/05/14 13:22:26 - Excel输入.0 - ERROR (version 9.3.0.0-428, build 9.3.0.0-428 from 2022-04-12 04.56.25 by buildguy) : java.lang.RuntimeException: com.ctc.wstx.exc.WstxIOException: Zip bomb detected! The file would exceed the max size of the expanded data in the zip-file.
This may indicates that the file is used to inflate memory usage and thus could pose a security risk.
You can adjust this limit via ZipSecureFile.setMaxEntrySize() if you need to work with files which are very large.
Uncompressed size: 4294969354, Raw/compressed size: 471441408
Limits: MAX_ENTRY_SIZE: 4294967295, Entry: xl/worksheets/sheet1.xml
2023/05/14 13:22:26 - Excel输入.0 - at org.pentaho.di.trans.steps.excelinput.staxpoi.StaxPoiSheet.getRow(StaxPoiSheet.java:242)
2023/05/14 13:22:26 - Excel输入.0 - at org.pentaho.di.trans.steps.excelinput.ExcelInput.getRowFromWorkbooks(ExcelInput.java:590)
2023/05/14 13:22:26 - Excel输入.0 - at org.pentaho.di.trans.steps.excelinput.ExcelInput.processRow(ExcelInput.java:426)
2023/05/14 13:22:26 - Excel输入.0 - at org.pentaho.di.trans.step.RunThread.run(RunThread.java:62)
2023/05/14 13:22:26 - Excel输入.0 - at java.base/java.lang.Thread.run(Thread.java:1623)
2023/05/14 13:22:26 - Excel输入.0 - Caused by: com.ctc.wstx.exc.WstxIOException: Zip bomb detected! The file would exceed the max size of the expanded data in the zip-file.
This may indicates that the file is used to inflate memory usage and thus could pose a security risk.
You can adjust this limit via ZipSecureFile.setMaxEntrySize() if you need to work with files which are very large.
Uncompressed size: 4294969354, Raw/compressed size: 471441408
Limits: MAX_ENTRY_SIZE: 4294967295, Entry: xl/worksheets/sheet1.xml
2023/05/14 13:22:26 - Excel输入.0 - at com.ctc.wstx.sr.StreamScanner.constructFromIOE(StreamScanner.java:625)
2023/05/14 13:22:26 - Excel输入.0 - at com.ctc.wstx.sr.StreamScanner.loadMore(StreamScanner.java:997)
2023/05/14 13:22:26 - Excel输入.0 - at com.ctc.wstx.sr.StreamScanner.loadMore(StreamScanner.java:1036)
2023/05/14 13:22:26 - Excel输入.0 - at com.ctc.wstx.sr.StreamScanner.getNextChar(StreamScanner.java:785)
2023/05/14 13:22:26 - Excel输入.0 - at com.ctc.wstx.sr.BasicStreamReader.parseAttrValue(BasicStreamReader.java:1890)
2023/05/14 13:22:26 - Excel输入.0 - at com.ctc.wstx.sr.BasicStreamReader.handleNsAttrs(BasicStreamReader.java:3063)
2023/05/14 13:22:26 - Excel输入.0 - at com.ctc.wstx.sr.BasicStreamReader.handleStartElem(BasicStreamReader.java:2961)
2023/05/14 13:22:26 - Excel输入.0 - at com.ctc.wstx.sr.BasicStreamReader.nextFromTree(BasicStreamReader.java:2837)
2023/05/14 13:22:26 - Excel输入.0 - at com.ctc.wstx.sr.BasicStreamReader.next(BasicStreamReader.java:1072)
2023/05/14 13:22:26 - Excel输入.0 - at org.pentaho.di.trans.steps.excelinput.staxpoi.StaxPoiSheet.parseRow(StaxPoiSheet.java:264)
2023/05/14 13:22:26 - Excel输入.0 - at org.pentaho.di.trans.steps.excelinput.staxpoi.StaxPoiSheet.getRow(StaxPoiSheet.java:233)
2023/05/14 13:22:26 - Excel输入.0 - ... 4 more
2023/05/14 13:22:26 - Excel输入.0 - Caused by: java.io.IOException: Zip bomb detected! The file would exceed the max size of the expanded data in the zip-file.
This may indicates that the file is used to inflate memory usage and thus could pose a security risk.
You can adjust this limit via ZipSecureFile.setMaxEntrySize() if you need to work with files which are very large.
Uncompressed size: 4294969354, Raw/compressed size: 471441408
Limits: MAX_ENTRY_SIZE: 4294967295, Entry: xl/worksheets/sheet1.xml
2023/05/14 13:22:26 - Excel输入.0 - at org.apache.poi.openxml4j.util.ZipArchiveThresholdInputStream.checkThreshold(ZipArchiveThresholdInputStream.java:118)
2023/05/14 13:22:26 - Excel输入.0 - at org.apache.poi.openxml4j.util.ZipArchiveThresholdInputStream.read(ZipArchiveThresholdInputStream.java:82)
2023/05/14 13:22:26 - Excel输入.0 - at com.ctc.wstx.io.BaseReader.readBytes(BaseReader.java:155)
2023/05/14 13:22:26 - Excel输入.0 - at com.ctc.wstx.io.UTF8Reader.loadMore(UTF8Reader.java:368)
2023/05/14 13:22:26 - Excel输入.0 - at com.ctc.wstx.io.UTF8Reader.read(UTF8Reader.java:111)
2023/05/14 13:22:26 - Excel输入.0 - at com.ctc.wstx.io.ReaderSource.readInto(ReaderSource.java:87)
2023/05/14 13:22:26 - Excel输入.0 - at com.ctc.wstx.io.BranchingReaderSource.readInto(BranchingReaderSource.java:57)
2023/05/14 13:22:26 - Excel输入.0 - at com.ctc.wstx.sr.StreamScanner.loadMore(StreamScanner.java:991)
2023/05/14 13:22:26 - Excel输入.0 - ... 13 more
数据太大了，超过文件大小限制了