Process Multiple date format in apache-pig -
i having muliple dates in different formats in pig like
mm/dd/yyyy hh:mm:ss.sss aa
mm-dd-yyyy hh:mm:ss.sss aa
can more..
for single date tried , works fine.
tounixtime(todate(dateandtime,'mm/dd/yyyy hh:mm:ss.sss aa'))as unix_datetime
is there way in pig can solve muliple date formats?
or have write java udf
i referring how parse dates in multiple formats using simpledateformat udf.
Comments
Post a Comment