[
https://issues.apache.org/jira/browse/TAJO-1003?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=14093786#comment-14093786
]
Hyunsik Choi edited comment on TAJO-1003 at 8/12/14 6:12 AM:
-------------------------------------------------------------
Hi [~Christian Schwabe],
Unfortunately, I couldn't reproduce this problem in my environment. I'm
expecting that it is a timezone-related problem. So, could you try one thing
and than share the result? It would greatly appreciate you if you help me find
the problem.
The trial is to add the following line to $\{TAJO_ROOT\}/conf/tajo-env.sh and
than restart your tajo cluster. The following trial will let your Tajo cluster
to work without local timezone. With this trial, I can figure out whether this
bug is caused by local timezone or not.
{code}
export TZ="UTC"
{code}
Thanks,
Hyunsik
was (Author: hyunsik):
Hi [~Christian Schwabe],
Unfortunately, I couldn't reproduce this problem in my environment. I'm
expecting that it is a timezone-related problem. So, could you try one thing
and than share the result? It would greatly appreciate you if you help me find
the problem.
The trial is to add the following line to ${TAJO_ROOT}/conf/tajo-env.sh and
than restart your tajo cluster. The following trial will let your Tajo cluster
to work without local timezone. With this trial, I can figure out whether this
bug is caused by local timezone or not.
{code}
export TZ="UTC"
{code}
Thanks,
Hyunsik
> wrong converting to_timestamp(text, text)
> -----------------------------------------
>
> Key: TAJO-1003
> URL: https://issues.apache.org/jira/browse/TAJO-1003
> Project: Tajo
> Issue Type: Bug
> Components: function/udf
> Affects Versions: 0.9.0
> Environment: 0.9.0-SNAPSHOT
> Reporter: Christian Schwabe
> Assignee: Hyunsik Choi
>
> >> SELECT to_timestamp('2011-11-11', 'YYYY-MM-DD'); results in '2011-11-10
> >> 23:00:00' I would have expected the following result '2011-11-11 00:00:00'
> ALSO:
> >> SELECT to_timestamp(2011-11-11', 'DD-MM-YYYY'); results in '0017-05-02
> >> 23:00:00'
--
This message was sent by Atlassian JIRA
(v6.2#6252)
