Issue with GenerateTableFetch bulk load when using MS SQL Server database type

2017-07-24 Thread Bryan Quinn
Hi, I'm trying to use the GenerateTableFetch component for 'MS SQL 2012+' database - for a full table export each time its run. However I'm forced to set a column name in the 'Maximum-value Columns' field when the component is run (error only shows during execution if I omit this setting). I'm s

Re: Issue with GenerateTableFetch bulk load when using MS SQL Server database type

2017-07-24 Thread Matt Burgess
Bryan, This is likely a bug, I will investigate and write it up if so. In the meantime, are you planning on doing the bulk fetch in parallel (with a Remote Process Group into ExecuteSQL across a NiFi cluster)? If not, you may find that QueryDatabaseTable is a good alternative, it can be configu

RE: Issue with GenerateTableFetch bulk load when using MS SQL Server database type

2017-07-24 Thread Bryan Quinn
load when using MS SQL Server database type Bryan, This is likely a bug, I will investigate and write it up if so. In the meantime, are you planning on doing the bulk fetch in parallel (with a Remote Process Group into ExecuteSQL across a NiFi cluster)? If not, you may find that

Re: Issue with GenerateTableFetch bulk load when using MS SQL Server database type

2017-07-27 Thread Matt Burgess
suming it’s a bug? Ballpark. > > > > Thanks, > > Bryan > > > > From: Matt Burgess [mailto:mattyb...@gmail.com] > Sent: Monday 24 July 2017 14:40 > To: users@nifi.apache.org > Subject: Re: Issue with GenerateTableFetch bulk load when using MS SQL > Server database typ