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

Switch to Threaded View
Hive, mail # user - string to int conversion (with leading zeros)


Copy link to this message
-
string to int conversion (with leading zeros)
Igor Tatarinov 2013-04-11, 18:23
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