Support Questions
Find answers, ask questions, and share your expertise
Alert: Welcome to the Unified Cloudera Community. Former HCC members be sure to read and learn how to activate your account here.

Modifying Insert statements before PutHiveStreaming

Modifying Insert statements before PutHiveStreaming



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

Don't have an account?
Coming from Hortonworks? Activate your account here