[GitHub] [flink] lirui-apache commented on a change in pull request #10543: [FLINK-15128][hive][doc] Document support for Hive timestamp type

[GitBox <gi...@apache.org>]

lirui-apache commented on a change in pull request #10543: [FLINK-15128][hive][doc] Document support for Hive timestamp type
URL: https://github.com/apache/flink/pull/10543#discussion_r358043851
 
 

 ##########
 File path: docs/dev/table/hive/index.md
 ##########
 @@ -303,5 +303,6 @@ Currently `HiveCatalog` supports most Flink data types with the following mappin
 Note that:
 
 * Flink doesn't support Hive's `UNION` type is not supported
+* Hive's `TIMESTAMP` always has precision 9 and doesn't support other precisions. As a result, `HiveCatalog` cannot store `TIMESTAMP` columns whose precisions are not 9. Hive UDFs, on the other hand, can process `TIMESTAMP` values with a precision <= 9.
 
 Review comment:
   No we can't store timestamp(<9) to HMS because the precision will be lost, and when we retrieve the column from HMS it'll always be timestamp(9) which can lead to problems.

----------------------------------------------------------------
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.
 
For queries about this service, please contact Infrastructure at:
users@infra.apache.org


With regards,
Apache Git Services