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?.