Hive padding leading zeroes

Question

I need the output of a string column in my table as 13 length char, irrespective of whatever length it is, i need to stuff the remaining chars with 0...

I tried to use the following code in my hive query, but failed to get the desired output

right('0000000000000' + ProductID, 13)

Any help? Thanks

score 53 · Accepted Answer · answered Jul 28 '14 at 16:48

53

Hive has built-in lpad and rpad functions. In your case you could use:

lpad(ProductId, 13, "0")

Or, if you might need to truncate to 13 characters, you could wrap this in the "right" function.

answered Jul 28 '14 at 16:48

Jason Rosendale

593
6
6

just what I needed! Thnx! – Abhi Dec 22 '18 at 22:53
Awesome it really helps. – vijayraj34 Oct 06 '20 at 11:16
('41405'||lpad(hex_to_int(ci),10,'0')) - please help me – Developer KE Sep 22 '21 at 12:11
just be mindful that if you have negative numbers this will add the leading zeros before the negative sign. for example 0000-123. It will not do -0000123 – Achilles Jun 29 '23 at 13:56

Hive padding leading zeroes

1 Answers1