Given a column of type bigint, with a mili-second precision timestamp, like this 1485172800000
How can I get hive to give me a date, like this: 1/23/2017
I've done it before and I don't believe a UDF is necessary, but I can't seem to get it to work for me today.
Thanks!