[IMPALA-9] LPAD returns incorrect result

• Type: Bug
• Status: Resolved
• Priority: Major
• Resolution: Fixed
• Affects Version/s: Impala 0.3
• Fix Version/s: Impala 0.4
• Assignee: Nong Li
• Reporter: Alan Choi
• Created: 10/Dec/12 18:52
• Updated: 24/Jan/13 05:59
• Resolved: 24/Jan/13 05:59

Description

I see different output when LPAD is used in hive and impala,
here's my table definition,

[localhost:21000] > describe accesslog;
sessionid string
cookie string
country string
browser string
......

Here's output from hive
hive> select (lpad(sessionid,2,'0')) from accesslog;
OK
01
01
02
02
03
03
04
04

Here's output from Impala,
[localhost:21000] > select (lpad(sessionid,2,'0')) from accesslog;
01
011
0112
01122
011223
0112233
01122334
011223344