Home | About | Sematext search-lucene.com search-hadoop.com
 Search Hadoop and all its subprojects:

Switch to Plain View
Hive >> mail # user >> string to int conversion (with leading zeros)


Copy link to this message
-
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