m_001_write_csv_41
Export huge MS sql table to csv without fetching all records together
The example attached uses ROWIDs from SQLite. You could see if you either have a ROWIDs present or you could create one yourself. You can choose the size of the chunk/batch yourself (I use integers you might have to see if with very large numbers you might need big integers or something. Even a workaround with using strings might be possible).
Nodes
- Math Formula6 ×
- DB Query Reader (Labs)2 ×
Table Row to Variable2 ×- CSV Reader1 ×
- CSV Writer1 ×
- Show all 15 nodes
Extensions
- FeatureKNIME Base nodes
- FeatureKNIME Basic File System Connectors
- FeatureKNIME Database
- FeatureKNIME Javasnippet
- FeatureKNIME Math Expression (JEP)
- Show all 6 modules