[HIVE-9459] Concat plus date functions appear to be broken in 0.14

• Type: Bug
• Status: Resolved
• Priority: Major
• Resolution: Duplicate
• Assignee: Unassigned
• Reporter: Nathan Lande
• Created: 26/Jan/15 00:03
• Updated: 28/Jan/15 02:00
• Resolved: 28/Jan/15 02:00

Description

In the below example I create year_month and month_year vars. These each should be yyyymm and mmyyyy integer strings but it appears as if hive is calling the first function twice such that it is returning mmmm and yyyyyyyy.

hive> select
> month(a.joined) month,
> year(a.joined) year,
> concat(cast(year(a.joined) as string),cast(month(a.joined) as string)) year_month,
> concat(cast(month(a.joined) as string),cast(year(a.joined) as string)) month_year
> from a limit 20;
OK
month year year_month month_year
7 2014 20142014 77
7 2014 20142014 77
7 2014 20142014 77
7 2014 20142014 77
7 2014 20142014 77
7 2014 20142014 77
7 2014 20142014 77
7 2014 20142014 77
7 2014 20142014 77
7 2014 20142014 77
7 2014 20142014 77
7 2014 20142014 77
7 2014 20142014 77
7 2014 20142014 77
7 2014 20142014 77
7 2014 20142014 77
7 2014 20142014 77
7 2014 20142014 77
7 2014 20142014 77
7 2014 20142014 77
Time taken: 0.109 seconds, Fetched: 20 row(s)

Other users appear to experience similar issues in this stack overflow: http://stackoverflow.com/questions/27740866/convert-date-to-decimal-format-in-hive .

I tested this in 0.13 and 0.14 and it does not appear to be an issue in 0.13.

I looked around and could not find a similar issue so hopefully this is not a duplicate.

Issue Links

• duplicates: HIVE-9278 Cached expression feature broken in one case