[
https://issues.apache.org/jira/browse/HIVE-13859?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Ashutosh Chauhan updated HIVE-13859:
------------------------------------
Resolution: Fixed
Status: Resolved (was: Patch Available)
Pushed to master & branch-2.1
> mask() UDF not retaining day and month field values
> ---------------------------------------------------
>
> Key: HIVE-13859
> URL: https://issues.apache.org/jira/browse/HIVE-13859
> Project: Hive
> Issue Type: Bug
> Components: UDF
> Affects Versions: 2.1.0
> Reporter: Madhan Neethiraj
> Fix For: 2.1.0
>
> Attachments: HIVE-13859.patch
>
>
> For date type parameters, mask() UDF replaces year/month/day field values
> with the values given in arguments to the UDF. Argument value -1 is treated
> as special, to specify that mask() should retain the value in the parameter.
> This allows to selectively mask only year/month/day fields.
> Specifying "-1" does not retain the values for day/month fields; however the
> year value is retained, as shown below.
> {code}
> 0: jdbc:hive2://localhost:10000> select id, join_date from employee where id
> < 4;
> +-----+-------------+--+
> | id | join_date |
> +-----+-------------+--+
> | 1 | 2012-01-01 |
> | 2 | 2014-02-01 |
> | 3 | 2013-03-01 |
> +-----+-------------+--+
> 3 rows selected (0.435 seconds)
> 0: jdbc:hive2://localhost:10000> select id, mask(join_date, -1, -1, -1,
> -1,-1, -1,-1,-1) join_date from employee where id < 4;
> +-----+-------------+--+
> | id | join_date |
> +-----+-------------+--+
> | 1 | 2012-01-01 |
> | 2 | 2014-01-01 |
> | 3 | 2013-01-01 |
> +-----+-------------+--+
> 3 rows selected (0.344 seconds)
> {code}
--
This message was sent by Atlassian JIRA
(v6.3.4#6332)
