[jira] [Commented] (TAJO-1925) Improve hive compatibility with TIMESTAMP partition column.

["Hyunsik Choi (JIRA)" <ji...@apache.org>]

    [ https://issues.apache.org/jira/browse/TAJO-1925?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16343200#comment-16343200 ] 

Hyunsik Choi commented on TAJO-1925:
------------------------------------

I've assigned this issue to me. I'll continue to do this issue.

> Improve hive compatibility with TIMESTAMP partition column.
> -----------------------------------------------------------
>
>                 Key: TAJO-1925
>                 URL: https://issues.apache.org/jira/browse/TAJO-1925
>             Project: Tajo
>          Issue Type: Improvement
>          Components: Catalog, Physical Operator
>    Affects Versions: 0.11.0, 0.12.0
>            Reporter: Jaehwa Jung
>            Assignee: Hyunsik Choi
>            Priority: Major
>             Fix For: 0.12.0
>
>         Attachments: TAJO-1925.patch, TAJO-1925_2.patch, TAJO-1925_3.patch
>
>
> -Currently, Tajo allow to use TIMESTAMP column as a partition key. But if users use TIMESTAMP partition column, Tajo doesn't keep the original TIMESTAMP values. Actually, Tajo automatically converts TIMESTAMP values to STRING literals which are accepted in the format YYYY-MM-DD HH:MM:SS. As a result, Tajo can't keep mills of second and can't provide right hive compatibility-
> We need to support hive compatibility for all partition column types. But when using TIMESTAMP partition column, users might not get correct partitions occasionally because tajo partition name is different from hive partition name. Actually, Tajo automatically converts TIMESTAMP values to STRING literals which are accepted in the format YYYY-MM-DD HH:MM:SS. But Hive automatically converts it to STRING literals which are accepted in the format YYYY-MM-DD HH:MM:SS.MS. 



--
This message was sent by Atlassian JIRA
(v7.6.3#76005)