[
https://issues.apache.org/jira/browse/FLINK-15858?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17030373#comment-17030373
]
Rui Li commented on FLINK-15858:
--------------------------------
bq. that means users cannot use basic SQL like "describe <table>" in Hive to
probe the table
It doesn't seem to be a big issue to me. Since generic tables cannot be used in
Hive anyway, what's the point to support displaying the schema via Hive CLI? In
addition, it's not just about precision info, there can be Flink types that
cannot be mapped to corresponding Hive types.
If users want to check whether a table is generic or not, they can call
{{DESCRIBE FORMATTED}} to look for the {{is_generic}} property.
> 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)
