[ 
https://issues.apache.org/jira/browse/HIVE-1385?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
 ]

John Sichi updated HIVE-1385:
-----------------------------

             Assignee:     (was: John Sichi)
        Fix Version/s: 0.6.0
    Affects Version/s: 0.5.0
          Component/s: Query Processor

> UDF field() doesn't work
> ------------------------
>
>                 Key: HIVE-1385
>                 URL: https://issues.apache.org/jira/browse/HIVE-1385
>             Project: Hadoop Hive
>          Issue Type: Bug
>          Components: Query Processor
>    Affects Versions: 0.5.0
>            Reporter: Siying Dong
>            Priority: Minor
>             Fix For: 0.6.0
>
>
> 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

-- 
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.

Reply via email to