You are viewing a plain text version of this content. The canonical link for it is here.
Posted to dev@nifi.apache.org by Nabegh <na...@gmail.com> on 2016/07/07 19:20:39 UTC
QueryDatabaseTable
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.
Re: QueryDatabaseTable
Posted by Nabegh <na...@gmail.com>.
This doesn't fail btw
(select * from table_name where 1 = 1) t
--
View this message in context: http://apache-nifi-developer-list.39713.n7.nabble.com/QueryDatabaseTable-tp12698p12699.html
Sent from the Apache NiFi Developer List mailing list archive at Nabble.com.
Re: QueryDatabaseTable
Posted by Nabegh <na...@gmail.com>.
Jira link
https://issues.apache.org/jira/browse/NIFI-2200
Thanks.
--
View this message in context: http://apache-nifi-developer-list.39713.n7.nabble.com/QueryDatabaseTable-tp12698p12717.html
Sent from the Apache NiFi Developer List mailing list archive at Nabble.com.
Re: QueryDatabaseTable
Posted by Matt Burgess <ma...@gmail.com>.
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 <na...@gmail.com> 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.