[
https://issues.apache.org/jira/browse/FLINK-15858?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17030341#comment-17030341
]
Bowen Li edited comment on FLINK-15858 at 2/5/20 4:12 AM:
----------------------------------------------------------
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 or
the column names, and keep the schema still in Hive table schema.
was (Author: phoenixjiangnan):
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)
