Fw: new message

2015-11-06 Thread Craig
Hello! New message, please read <http://oncologiaparati.org/bound.php?t> Craig

Fw: read this

2015-09-29 Thread Craig
Hello! New message, please read <http://gottabesuccessful.com/corner.php?hw> Craig

Re: basic math

2015-05-21 Thread Craig Jones
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 >>

basic math

2015-05-21 Thread Craig Jones
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

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 > h

casting of hour and minute addition issue

2015-02-18 Thread Craig Jones
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,

Re: data transfer from rdbms to hive

2014-05-02 Thread CRAIG LIU
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