I did some analysis in Hive but when I export it to a .csv file, it's dropping the leading zero.

Is there a way to preserve this?

i.e. a group by variable is being converted from "07895" to "7895" when I download it and open it in the .csv.

Thanks