Re: ExecuteSQL question: how do I stop long running queries

2017-09-29 Thread Matt Burgess
all rows on daily >> basis. ? >> >> >> >> Which version of NiFi would work best for RDBMS processors, I’ll check with >> platform folks if we can go version upgrade. >> >> >> >> Thanks, Appreciate your help &g

Re: ExecuteSQL question: how do I stop long running queries

2017-09-29 Thread Jeremy Farbota
ld work best for RDBMS processors, I’ll check > with platform folks if we can go version upgrade. > > > > Thanks, Appreciate your help > > > > *From:* Matt Burgess [mailto:mattyb...@gmail.com] > *Sent:* Friday, September 29, 2017 6:48 PM > *To:* users@nifi.apach

RE: ExecuteSQL question: how do I stop long running queries

2017-09-29 Thread More, Vikram (CONT)
Burgess [mailto:mattyb...@gmail.com] Sent: Friday, September 29, 2017 6:48 PM To: users@nifi.apache.org Subject: Re: ExecuteSQL question: how do I stop long running queries Vikram, I'm not at my computer right now so I'm shooting from the hip, but depending on how complex your query is (meaning

Re: ExecuteSQL question: how do I stop long running queries

2017-09-29 Thread Matt Burgess
Vikram, I'm not at my computer right now so I'm shooting from the hip, but depending on how complex your query is (meaning if it is very simple), take a look at QueryDatabaseTable and GenerateTableFetch, if you are looking to get all rows (versus incremental fetching), you can omit the maximum

ExecuteSQL question: how do I stop long running queries

2017-09-29 Thread More, Vikram (CONT)
Hi , I am using ExecuteSQL processor to pull from operational database and for some of the tables it keeps running for more than 24 hrs, 1] During a long-running query from a database (e.g. Oracle) being execute by an 'ExecuteSql' process, is there a way to check the progress - say by seeing