You are viewing a plain text version of this content. The canonical link for it is here.

Posted to user@hive.apache.org by Igor Tatarinov <ig...@decide.com> on 2013/04/11 20:23:40 UTC

string to int conversion (with leading zeros)

Hi all,

I need to convert a string attribute that contains ints with occasional
leading zeroes. Unfortunately, I can't simply cast() as Hive will try to
parse those numbers as octals. Is a regex the only solution?

thanks!
igor
decide.com