[
https://issues.apache.org/jira/browse/TAJO-1003?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=14093786#comment-14093786
]
Hyunsik Choi commented on TAJO-1003:
------------------------------------
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)
