You are viewing a plain text version of this content. The canonical link for it is here.
Posted to issues@flink.apache.org by "Timo Walther (Jira)" <ji...@apache.org> on 2021/02/23 13:48:00 UTC
[jira] [Commented] (FLINK-21456) TableResult#print() should
correctly stringify values of TIMESTAMP type in SQL format
[ https://issues.apache.org/jira/browse/FLINK-21456?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17289089#comment-17289089 ]
Timo Walther commented on FLINK-21456:
--------------------------------------
It is not only timestamp but also decimals. What is missing a well-defined string representation of all data types. For some logical types, I already added a specification to the JavaDocs but ROW, MAP, MULTISET etc. are missing.
> TableResult#print() should correctly stringify values of TIMESTAMP type in SQL format
> -------------------------------------------------------------------------------------
>
> Key: FLINK-21456
> URL: https://issues.apache.org/jira/browse/FLINK-21456
> Project: Flink
> Issue Type: Improvement
> Components: Table SQL / API
> Reporter: Jark Wu
> Priority: Major
>
> Currently {{TableResult#print()} simply use {{Object#toString()}} as the string representation of the fields. This is not SQL compliant, because for TIMESTAMP and TIMESTAMP_LZ, the string representation should be {{2021-02-23 17:30:00}} instead of {{2021-02-23T17:30:00Z}}.
> Note: we may need to update {{PrintUtils#rowToString(Row)}} and also SQL Client which invokes this method.
--
This message was sent by Atlassian Jira
(v8.3.4#803005)