nifi-users mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Joe Percivall <>
Subject Re: JDBC External Table File Target
Date Thu, 28 Jan 2016 20:04:58 GMT
Hello Obaid,

Sorry no one has gotten back to you sooner, many of the developers are working diligently
to get 0.5.0 done.

I don't know too much about loading SQL tables but when you say "local file system filename",
is this a file that exits on the target system? If so you may just be able to set that command
because my understanding is that using ExecuteSQL you have an input query which gets sent
to the target server. Then the target server then runs that command.

Can anyone else that has more experience with SQL and loading tables chime in?

- - - - - - 
Joseph Percivall

On Saturday, January 23, 2016 12:31 AM, obaidul karim <> wrote:


I developing a nifi processor for netezza. 
As per by experience the best way to load data to netezza is using netezza JDBC external table.

I want to run below command to load a file within NiFi processor.

insert into MYTABLE 
select * FROM EXTERNAL '<local file system filename>' 
USING (<JDBC Options>) ;

My question is which file to usefor <local file system filename>  ?
- Is it the flow files ? If yes then how can I get full path of a flowfile ?
- or can I directly load the file in a spool directory ?

Thanks for your help in advance.


View raw message