hameizi edited a comment on issue #2896: URL: https://github.com/apache/iceberg/issues/2896#issuecomment-890662602
> My guess would be a schema issue during import. Can you validate the schema created by iceberg and the schema of the original files? > > I would also go one by one through the columns (pruning out all but one column) and determine if there is an alignment issue or whether it is just one column. @RussellSpitzer thanks for you reply, the schema is correct like below, but get the same exception too. Flink SQL> desc flink.hive_adv_game_recommend_test19; +------------+--------+------+-----+--------+-----------+ | name | type | null | key | extras | watermark | +------------+--------+------+-----+--------+-----------+ | gameidfrom | INT | true | | | | | guid | STRING | true | | | | | uuid | STRING | true | | | | | userid | STRING | true | | | | | useridfrom | INT | true | | | | | manageid | BIGINT | true | | | | | pt | STRING | true | | | | +------------+--------+------+-----+--------+-----------+ 7 rows in set Flink SQL> desc iceberg_hive_catalog.flink.iceberg_hive_adv_game_recommend_test19; +------------+--------+------+-----+--------+-----------+ | name | type | null | key | extras | watermark | +------------+--------+------+-----+--------+-----------+ | gameidfrom | INT | true | | | | | guid | STRING | true | | | | | uuid | STRING | true | | | | | userid | STRING | true | | | | | useridfrom | INT | true | | | | | manageid | BIGINT | true | | | | | pt | STRING | true | | | | +------------+--------+------+-----+--------+-----------+ 7 rows in set -- 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. To unsubscribe, e-mail: [email protected] For queries about this service, please contact Infrastructure at: [email protected] --------------------------------------------------------------------- To unsubscribe, e-mail: [email protected] For additional commands, e-mail: [email protected]
