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

Try this:

select date_format(from_utc_timestamp(1490198341.705,'GMT+8:00'),'yyyyMMdd HH:mm:ss');

CodeHunter