hive-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Jason Dere (JIRA)" <j...@apache.org>
Subject [jira] [Commented] (HIVE-9459) Concat plus date functions appear to be broken in 0.14
Date Wed, 28 Jan 2015 01:49:34 GMT

    [ https://issues.apache.org/jira/browse/HIVE-9459?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=14294577#comment-14294577
] 

Jason Dere commented on HIVE-9459:
----------------------------------

I suspect this is due to HIVE-9278. [~navis], can you confirm?

> Concat plus date functions appear to be broken in 0.14
> ------------------------------------------------------
>
>                 Key: HIVE-9459
>                 URL: https://issues.apache.org/jira/browse/HIVE-9459
>             Project: Hive
>          Issue Type: Bug
>            Reporter: Nathan Lande
>
> 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.



--
This message was sent by Atlassian JIRA
(v6.3.4#6332)

Mime
View raw message