Hive - Ways to standardize incoming date fields n hive?
<p>I've got datasources from all over using mysql, oracle, etc. Each datasource stores the date as a record in a table(s), but the format is not standard and can even vary from table to table in the same datasource (yyyy-MM-dd, yyyy-dd-MM, MM-dd-yyyy, yyyy-MMM-dd HH:mm:SS:ss, etc.).</p>

<p>What are some options to standardize these different date fields to store in hive? Pig?</p>