islandgit commented on issue #1898: URL: https://github.com/apache/iceberg/issues/1898#issuecomment-741870471
> @islandgit: Could you please tell us which version of Hive were you using? > Also could you please provide the output of the `SHOW CREATE TABLE` output for the table mentioned above? > Thanks, > Peter Thanks for your answer my hive version is **_2.1.1-cdh6.3.2_** SHOW CREATE TABLE is: +----------------------------------------------------+ | createtab_stmt | +----------------------------------------------------+ | CREATE EXTERNAL TABLE `sinoiov_original_data`( | | `gtime` bigint COMMENT '', | | `stime` bigint COMMENT '', | | `ln` int COMMENT '', | | `lt` int COMMENT '', | | `speed` int COMMENT '', | | `direction` int COMMENT '', | | `altitude` int COMMENT '', | | `mileage` int COMMENT '', | | `state` string COMMENT '', | | `alarm` string COMMENT '', | | `color` int COMMENT '', | | `vehicle` string COMMENT '', | | `p_time` timestamp COMMENT '') | | ROW FORMAT SERDE | | 'org.apache.iceberg.mr.hive.HiveIcebergSerDe' | | STORED BY | | 'org.apache.iceberg.mr.hive.HiveIcebergStorageHandler' | | | | LOCATION | | 'hdfs://lbc/user/hive/warehouse/iceberg_gps_db.db/sinoiov_original_data' | | TBLPROPERTIES ( | | 'metadata_location'='hdfs://lbc/user/hive/warehouse/iceberg_gps_db.db/sinoiov_original_data/metadata/00001-c12049be-d808-40f8-b712-d0fe53647997.metadata.json', | | 'previous_metadata_location'='hdfs://lbc/user/hive/warehouse/iceberg_gps_db.db/sinoiov_original_data/metadata/00000-b4c0733a-b0c3-4ae2-8546-05a761b6880c.metadata.json', | | 'table_type'='ICEBERG', | | 'transient_lastDdlTime'='1607431371') | +----------------------------------------------------+ ---------------------------------------------------------------- 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: [email protected] --------------------------------------------------------------------- To unsubscribe, e-mail: [email protected] For additional commands, e-mail: [email protected]
