Home | About | Sematext search-lucene.com search-hadoop.com
 Search Hadoop and all its subprojects:

Switch to Plain View
Hive >> mail # user >> RE: I would like to report a bug


Copy link to this message
-
RE: I would like to report a bug
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
format ?

Viral
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

     unix_timestamp(duration,'HH:mm:ss')

When I test it backwards ,it works , I get my duration in a well format
with correct values. This:

     from_unixtime( unix_timestamp(duration,'HH:mm:ss'))

But anyway , I can not get unixtimestamp in seconds.

Thanks