[
https://issues.apache.org/jira/browse/FLINK-15858?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17028734#comment-17028734
]
Rui Li commented on FLINK-15858:
--------------------------------
This seems to be more of a limitation than a bug to me. HMS doesn't support
storing precision info for {{TIMESTAMP}} columns. That's why we disallow
creating {{TIMESTAMP(!=9)}} with HiveCatalog -- the precision will be discarded
anyway.
Maybe for generic tables, we can store the schema as table properties, so as to
support Flink-specific types.
> Unable to use HiveCatalog and kafka together
> --------------------------------------------
>
> Key: FLINK-15858
> URL: https://issues.apache.org/jira/browse/FLINK-15858
> Project: Flink
> Issue Type: Bug
> Affects Versions: 1.10.0
> Reporter: Jeff Zhang
> Priority: Major
>
>
> HiveCatalog only support timestamp(9), but kafka only support timestamp(3).
> This make user unable to use HiveCatalog and kafka together
> {code:java}
> Caused by: org.apache.flink.table.catalog.exceptions.CatalogException:
> HiveCatalog currently only supports timestamp of precision 9
> at
> org.apache.flink.table.catalog.hive.util.HiveTypeUtil$TypeInfoLogicalTypeVisitor.visit(HiveTypeUtil.java:272)
> at
> org.apache.flink.table.catalog.hive.util.HiveTypeUtil$TypeInfoLogicalTypeVisitor.visit(HiveTypeUtil.java:173)
> at
> org.apache.flink.table.types.logical.TimestampType.accept(TimestampType.java:151)
> at
> org.apache.flink.table.catalog.hive.util.HiveTypeUtil.toHiveTypeInfo(HiveTypeUtil.java:84)
> at
> org.apache.flink.table.catalog.hive.util.HiveTableUtil.createHiveColumns(HiveTableUtil.java:106)
> {code}
--
This message was sent by Atlassian Jira
(v8.3.4#803005)
