[ https://issues.apache.org/jira/browse/FLINK-15858?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17030341#comment-17030341 ]
Bowen Li commented on FLINK-15858: ---------------------------------- I'm ok with the proposed solution. However, that means users cannot use basic SQL like "describe <table>" in Hive, as stated in example of [https://ci.apache.org/projects/flink/flink-docs-master/dev/table/hive/hive_catalog.html#step-4-start-sql-client-and-create-a-kafka-table-with-flink-sql-ddl] Another solution is to store precisions for such data types in properties and keep the schema still in Hive table schema. > Unable to use HiveCatalog and kafka together > -------------------------------------------- > > Key: FLINK-15858 > URL: https://issues.apache.org/jira/browse/FLINK-15858 > Project: Flink > Issue Type: Bug > Components: Table SQL / Ecosystem > Affects Versions: 1.10.0 > Reporter: Jeff Zhang > Priority: Blocker > Labels: pull-request-available > Fix For: 1.10.0 > > Time Spent: 10m > Remaining Estimate: 0h > > > 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)