Skip to main content
Question

Tableau Hyper writers errors on 'COPY-IN cancelled'


fdw
Contributor
Forum|alt.badge.img+6
  • Contributor

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.

Error COPY-IN TableauWhen 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.

0 replies

Be the first to reply!

Cookie policy

We use cookies to enhance and personalize your experience. If you accept you agree to our full cookie policy. Learn more about our cookies.

 
Cookie settings