Hello!
New message, please read <http://oncologiaparati.org/bound.php?t>
Craig
Hello!
New message, please read <http://gottabesuccessful.com/corner.php?hw>
Craig
t the "a" term
> print cos(a[0]*pi/180.0)*cos(b[0]*pi/180.0) * cos(b[1]*pi/180.0 -
> a[1]*pi/180.0)
>
> Does this matter?
>
> On Thu, May 21, 2015 at 9:49 AM, Craig Jones wrote:
>
>> I have what I thought was going to be a very simple math operation in
>>
feels like there
is some order of operations issue but surely that would have been seen by
now. It must be something I am doing wrong.
I am using Hive 0.14.0.2.2.0.0-2041
Craig
--
Craig Jones, PhD
Data Scientist
Spry, Inc
em: cjo...@spryinc.com
web: http://spryinc.com
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
> h
geles") ) as double)/60.0 as test1,
cast(hour( from_utc_timestamp( from_unixtime(1367445469, '-MM-dd
HH:mm:ss'), "America/Los_Angeles") ) as double) + 0.15 as test2
from the_table
limit 100;
I get the following:
_c0, hour, minute, fractional_hour, hour_minute,
I am new in hive and here is my idea?
1. Use mysqldump to dump your data to csv file.
2. Load csv to hive temp table.
3. Create partition table.
4. Use dynamic partition, select from temp table to insert to partition
table. You can use udf to get the date from the timestamp.
Regards,
Craig
2014-5