Recently I tried to write a few million non-spatial features to a Hyper writer. At some point (around 11.000 features) in committing the features to the file (create if needed on a new non-existent file) it errors. With the debugging option in the log I was able to figure out that a 'COPY-IN' statement is executed I think.
When I look at the documentation https://tableau.github.io/hyper-db/docs/sql/command/ no such statement is supported. Am I correct here?
Features per transaction is set at 1000. Bulk insert: Yes. Changing these makes no difference.
When limiting the features that pass to the writer it will write the file correctly. Like say about 50.000 no problem.
I am using FME(R) 2022.2.2.0 (20230106 - Build 22782 - WIN64)
Is this a bug? Should I upgrade to a newer version? RAM is not a problem, disk space isn't either.
