You are viewing a plain text version of this content. The canonical link for it is here.
Posted to issues@iceberg.apache.org by GitBox <gi...@apache.org> on 2020/12/11 12:15:31 UTC

[GitHub] [iceberg] 172403678 opened a new issue #1916: Spark Table With Timestamp Cannot Query By Flink

172403678 opened a new issue #1916:
URL: https://github.com/apache/iceberg/issues/1916


   Exception in thread "main" org.apache.flink.table.client.SqlClientException: Unexpected exception. This is a bug. Please consider filing an issue.
           at org.apache.flink.table.client.SqlClient.main(SqlClient.java:213)
   Caused by: org.apache.flink.table.api.TableException: Unsupported conversion from data type 'TIMESTAMP(6) WITH LOCAL TIME ZONE' (conversion class: java.time.Instant) to type information. Only data types that originated from type information fully support a reverse conversion.
           at org.apache.flink.table.types.utils.LegacyTypeInfoDataTypeConverter.toLegacyTypeInfo(LegacyTypeInfoDataTypeConverter.java:259)
           at java.util.stream.ReferencePipeline$3$1.accept(ReferencePipeline.java:193)
           at java.util.ArrayList$ArrayListSpliterator.forEachRemaining(ArrayList.java:1382)
           at java.util.stream.AbstractPipeline.copyInto(AbstractPipeline.java:481)
           at java.util.stream.AbstractPipeline.wrapAndCopyInto(AbstractPipeline.java:471)
           at java.util.stream.AbstractPipeline.evaluate(AbstractPipeline.java:545)
           at java.util.stream.AbstractPipeline.evaluateToArrayNode(AbstractPipeline.java:260)
           at java.util.stream.ReferencePipeline.toArray(ReferencePipeline.java:438)
           at org.apache.flink.table.types.utils.LegacyTypeInfoDataTypeConverter.convertToRowTypeInfo(LegacyTypeInfoDataTypeConverter.java:329)
           at org.apache.flink.table.types.utils.LegacyTypeInfoDataTypeConverter.toLegacyTypeInfo(LegacyTypeInfoDataTypeConverter.java:237)
           at org.apache.flink.table.types.utils.TypeConversions.fromDataTypeToLegacyInfo(TypeConversions.java:49)
           at org.apache.flink.table.api.TableSchema.toRowType(TableSchema.java:271)
           at org.apache.flink.table.client.gateway.local.result.CollectStreamResult.<init>(CollectStreamResult.java:71)
           at org.apache.flink.table.client.gateway.local.result.MaterializedCollectStreamResult.<init>(MaterializedCollectStreamResult.java:101)
           at org.apache.flink.table.client.gateway.local.result.MaterializedCollectStreamResult.<init>(MaterializedCollectStreamResult.java:129)
           at org.apache.flink.table.client.gateway.local.ResultStore.createResult(ResultStore.java:83)
           at org.apache.flink.table.client.gateway.local.LocalExecutor.executeQueryInternal(LocalExecutor.java:608)
           at org.apache.flink.table.client.gateway.local.LocalExecutor.executeQuery(LocalExecutor.java:465)
           at org.apache.flink.table.client.cli.CliClient.callSelect(CliClient.java:555)
           at org.apache.flink.table.client.cli.CliClient.callCommand(CliClient.java:311)
           at java.util.Optional.ifPresent(Optional.java:159)
           at org.apache.flink.table.client.cli.CliClient.open(CliClient.java:212)
           at org.apache.flink.table.client.SqlClient.openCli(SqlClient.java:142)
           at org.apache.flink.table.client.SqlClient.start(SqlClient.java:114)
           at org.apache.flink.table.client.SqlClient.main(SqlClient.java:201)


----------------------------------------------------------------
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



---------------------------------------------------------------------
To unsubscribe, e-mail: issues-unsubscribe@iceberg.apache.org
For additional commands, e-mail: issues-help@iceberg.apache.org

[GitHub] [iceberg] 172403678 commented on issue #1916: Spark Table With Timestamp Cannot Query By Flink

Posted by GitBox <gi...@apache.org>.
172403678 commented on issue #1916:
URL: https://github.com/apache/iceberg/issues/1916#issuecomment-743162592


   table like this
   
   CREATE TABLE prod.iceberg_db.bofangzt3(
   ftime timestamp,
   extinfo string
   ) 
   USING iceberg
   PARTITIONED BY (hours(ftime))
   


----------------------------------------------------------------
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



---------------------------------------------------------------------
To unsubscribe, e-mail: issues-unsubscribe@iceberg.apache.org
For additional commands, e-mail: issues-help@iceberg.apache.org