Re: casting of hour and minute addition issue

2015-02-18 Thread Craig Jones
That did fix my issue. Thanks! Craig On Wed, Feb 18, 2015 at 2:56 PM, Jason Dere wrote: > I believe this is due to https://issues.apache.org/jira/browse/HIVE-9278, > which has been fixed in trunk (also 1.0). > This affects UDFs using the old-style UDF classes (which include > hour()/minute()/

Re: casting of hour and minute addition issue

2015-02-18 Thread Jason Dere
I believe this is due to https://issues.apache.org/jira/browse/HIVE-9278, which has been fixed in trunk (also 1.0). This affects UDFs using the old-style UDF classes (which include hour()/minute()/second()) A workaround is to do "set hive.cache.expr.evaluation=false;" before running the query.

casting of hour and minute addition issue

2015-02-18 Thread Craig Jones
I have a unix time that I need to convert time-zones and then do some calculations on it. In the end I want to create a fractional hour (15:30 -> 15.5). We are at Hive 0.14.0.2.2.0.0-2041 I have the following Hive test query: select time_from_epoch, cast(hour( from_utc_timestamp( from_un