[HIVE-1385] UDF field() doesn't work

• Type: Bug
• Status: Closed
• Priority: Minor
• Resolution: Fixed
• Affects Version/s: 0.5.0, 0.6.0
• Fix Version/s: 0.7.0
• Component/s: UDF
• Assignee: Siying Dong
• Reporter: Siying Dong
• Created: 03/Jun/10 01:58
• Updated: 16/Dec/11 23:59
• Resolved: 15/Jul/10 21:17

Description

I tried it against one of my table:

hive> desc r;
OK
key int
value string
a string

hive> select * from r;
OK
4 val_356 NULL
4 val_356 NULL
484 val_169 NULL
484 val_169 NULL
2000 val_169 NULL
2000 val_169 NULL
3000 val_169 NULL
3000 val_169 NULL
4000 val_125 NULL
4000 val_125 NULL

hive> select *, field(value, 'val_169') from r;
OK
4 val_356 NULL 0
4 val_356 NULL 0
484 val_169 NULL 0
484 val_169 NULL 0
2000 val_169 NULL 0
2000 val_169 NULL 0
3000 val_169 NULL 0
3000 val_169 NULL 0
4000 val_125 NULL 0
4000 val_125 NULL 0