I'd consider this behaviour as a bug and would like to raise it as such.
Is there anyone to confirm it's the same on Hive 0.14?
On Fri, Oct 31, 2014 at 3:41 PM, Maciek <mac...@sonra.io> wrote:
> Actually confirmed! It's down to the timezone settings
> I've moved temporarily server/client settings to 'Atlantic/Reykjavik' (no
> change in time comparing to what I was on (GMT), but it's permanent UTC and
> as such doesn't observe daylight saving.
> I believe this shouldn't matter (see my points from previous mail) but
> apparently there's an issue with it.
> Not sure how to deal with this situation (can't just change TZ settings
> everywhere because of Hive) and don't want to hardcode anything.
> I'm on Hive 0.13.
> Does Hive 0.14 provide better support for TimeZones?
>
>
> On Fri, Oct 31, 2014 at 3:25 PM, Maciek <mac...@sonra.io> wrote:
>
>> Thought about that myself based on my prior (bad) experience when tried
>> to working with timezones in Hive (functionality pretty much doesn't exists)
>> That shouldn't be the case here though, here's why:
>> in Oracle [timestamp with timezone] can be adjusted when sent/displayed
>> on the client based on client's settings. This may be also relevant if the
>> timestamp in question would fall onto client's daily saving time period.
>> This behaviour would make sense to me, however:
>>
>> • this is server, not client settings we're talking about here
>> • the server and client do reside in the same timezone anyway, which is
>> currently GMT [UTC]
>>
>> • while we observe the daily saving here [Dublin] the time in question
>> ("1970-01-01 00:00:00") is not in that period, neither the time I'm sending
>> the query (now).
>>
>>
>>
>> Based on all above, I don't see the reason the time gets shifted by one
>> hour, but I realise the issue might be down to the general problems in
>> Hive' implementation of timezones…
>>
>> On Fri, Oct 31, 2014 at 12:26 PM, Nitin Pawar <nitinpawar...@gmail.com>
>> wrote:
>>
>>> In hive from_unixtime is returned from the timezone which you belong to
>>> "From document : from_unixtime(bigint unixtime[, string format]) :
>>> Converts the number of seconds from unix epoch (1970-01-01 00:00:00 UTC) to
>>> a string representing the timestamp of that moment in the current system
>>> time zone in the format of "1970-01-01 00:00:00".
>>>
>>> if possible can you also check by changing the timezone to UTC on your
>>> machine?
>>>
>>>>
>>>> On Fri, Oct 31, 2014 at 12:00 PM, Maciek <mac...@sonra.io> wrote:
>>>>
>>>>> Any reason why
>>>>>
>>>>> select from_unixtime(0) t0 FROM …
>>>>>
>>>>> gives
>>>>>
>>>>> 1970-01-01 01:00:00
>>>>>
>>>>> ?
>>>>>
>>>>> By all available definitions (epoch, from_unixtime etc..) I would
>>>>> expect it to be 1970-01-01 00:00:00…?
>>>>>
>>>>
>>
>
>
> --
> Kind Regards
> Maciek Kocon
>
>
--
Kind Regards
Maciek Kocon
