That sounds like a bug, mind filing a Jira case? Thanks, Matt
P.S. Not sure the where filter will work even after the fix but I will take a look. > On Jul 7, 2016, at 3:20 PM, Nabegh <[email protected]> wrote: > > I'm trying to load a table from Netezza database using QueryDatabaseTable > processor. I'm trying to add a where filter so I put the following in the > Table Name: > (select * from table_name where condition = value) t > > This is failing with the following error > > 5136faa70] Failed to process session due to > org.apache.nifi.processor.exception.FlowFileHandlingException: > StandardFlowFileRecord[uuid=f1a41b93-ad76-4182-a51c-ce70c0548d3c,claim=,offset=0,name=196705832567747,size=0] > transfer relationship not specified: > org.apache.nifi.processor.exception.FlowFileHandlingException: > StandardFlowFileRecord[uuid=f1a41b93-ad76-4182-a51c-ce70c0548d3c,claim=,offset=0,name=196705832567747,size=0] > transfer relationship not specified > 2016-07-07 16:28:36,565 ERROR [Timer-Driven Process Thread-6] > o.a.n.p.standard.QueryDatabaseTable > org.apache.nifi.processor.exception.FlowFileHandlingException: > StandardFlowFileRecord[uuid=f1a41b93-ad76-4182-a51c-ce70c0548d3c,claim=,offset=0,name=196705832567747,size=0] > transfer relationship not specified > at > org.apache.nifi.controller.repository.StandardProcessSession.checkpoint(StandardProcessSession.java:212) > ~[nifi-framework-core-0.6.1.jar:0.6.1] > at > org.apache.nifi.controller.repository.StandardProcessSession.commit(StandardProcessSession.java:282) > ~[nifi-framework-core-0.6.1.jar:0.6.1] > at > org.apache.nifi.processors.standard.QueryDatabaseTable.onTrigger(QueryDatabaseTable.java:348) > ~[na:na] > at > org.apache.nifi.controller.StandardProcessorNode.onTrigger(StandardProcessorNode.java:1059) > ~[nifi-framework-core-0.6.1.jar:0.6.1] > at > org.apache.nifi.controller.tasks.ContinuallyRunProcessorTask.call(ContinuallyRunProcessorTask.java:136) > [nifi-framework-core-0.6.1.jar:0.6.1] > at > org.apache.nifi.controller.tasks.ContinuallyRunProcessorTask.call(ContinuallyRunProcessorTask.java:47) > [nifi-framework-core-0.6.1.jar:0.6.1] > at > org.apache.nifi.controller.scheduling.TimerDrivenSchedulingAgent$1.run(TimerDrivenSchedulingAgent.java:123) > [nifi-framework-core-0.6.1.jar:0.6.1] > at java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:511) > [na:1.8.0_91] > at java.util.concurrent.FutureTask.runAndReset(FutureTask.java:308) > [na:1.8.0_91] > at > java.util.concurrent.ScheduledThreadPoolExecutor$ScheduledFutureTask.access$301(ScheduledThreadPoolExecutor.java:180) > [na:1.8.0_91] > at > java.util.concurrent.ScheduledThreadPoolExecutor$ScheduledFutureTask.run(ScheduledThreadPoolExecutor.java:294) > [na:1.8.0_91] > at > java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1142) > [na:1.8.0_91] > at > java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:617) > [na:1.8.0_91] > at java.lang.Thread.run(Thread.java:745) [na:1.8.0_91] > > > > -- > View this message in context: > http://apache-nifi-developer-list.39713.n7.nabble.com/QueryDatabaseTable-tp12698.html > Sent from the Apache NiFi Developer List mailing list archive at Nabble.com.
