How to convert timestamp (with dot between second and millisecond) to date(yyyyMMdd) in Hive? How to convert timestamp (with dot between second and millisecond) to date(yyyyMMdd) in Hive? hadoop hadoop