You are viewing a plain text version of this content. The canonical link for it is here.

Posted to users@nifi.apache.org by Aruna Sankaralingam <Ar...@Cormac-Corp.com> on 2017/12/12 19:35:42 UTC

Nifi with .txt as source

Can Nifi take a .txt file as source? If so, while loading to redshift database, should the reader be "CSV reader"?

Screenshot of the .txt file.
[cid:image001.png@01D37356.79927760]

RE: Nifi with .txt as source

Posted by Aruna Sankaralingam <Ar...@Cormac-Corp.com>.

The file is in S3. I should be using  List S3 and Fetch S3, will that still work?

From: Andy LoPresto [mailto:alopresto@apache.org]
Sent: Tuesday, December 12, 2017 2:41 PM
To: users@nifi.apache.org
Subject: Re: Nifi with .txt as source

Yes, you would use GetFile as the processor and treat the data as CSV format with a “tab” delimiter rather than a “,”.

Andy LoPresto
alopresto@apache.org<ma...@apache.org>
alopresto.apache@gmail.com<ma...@gmail.com>
PGP Fingerprint: 70EC B3E5 98A6 5A3F D3C4  BACE 3C6E F65B 2F7D EF69

On Dec 12, 2017, at 11:35 AM, Aruna Sankaralingam <Ar...@cormac-corp.com>> wrote:

Can Nifi take a .txt file as source? If so, while loading to redshift database, should the reader be “CSV reader”?

Screenshot of the .txt file.
<image001.png>

Re: Nifi with .txt as source

Posted by Andy LoPresto <al...@apache.org>.

Yes, you would use GetFile as the processor and treat the data as CSV format with a “tab” delimiter rather than a “,”.


Andy LoPresto
alopresto@apache.org
alopresto.apache@gmail.com
PGP Fingerprint: 70EC B3E5 98A6 5A3F D3C4  BACE 3C6E F65B 2F7D EF69

> On Dec 12, 2017, at 11:35 AM, Aruna Sankaralingam <Ar...@Cormac-Corp.com> wrote:
> 
> Can Nifi take a .txt file as source? If so, while loading to redshift database, should the reader be “CSV reader”?
> 
> Screenshot of the .txt file.
> <image001.png>