I don't think this is the right list for your query. Moving hadoop list
to bcc and cc'ing hive list.
Also I don't get how you can get unix timestamp from a field with just
hour granularity, are you missing the date information in your date
From: Carolina Vizuete Martinez
Sent: 1/15/2013 1:38 AM
To: [EMAIL PROTECTED]
Subject: I would like to report a bug
Hi, I would like to report a bug .
I get negative value of function unix_timestamp.
I want to get a duration of format HH:mm:ss
When I test it backwards ,it works , I get my duration in a well format
with correct values. This:
But anyway , I can not get unixtimestamp in seconds.