Support Questions
Find answers, ask questions, and share your expertise

Modifying Insert statements before PutHiveStreaming

Modifying Insert statements before PutHiveStreaming

Explorer

Hello,

My CSV file contains a column with DATE TIME format like 12-10-2017 11:30

Now using puthivestreaming i can insert those records easily but my requirement is to remove just the TIME from this & keep only 12-10-2017

I can acheive this using Hive command line with substr() method while inserting, Not sure if Nifi supports it

I also thought about ReplaceText but since i have multiple DateTIMe like columns on single row, i cannot do this.

How can i achieve this?.