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/09 16:11:31 UTC
[GitHub] [iceberg] islandgit edited a comment on issue #1898: Hive read iceberg table ERROR
islandgit edited a comment 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
@pvary
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:
users@infra.apache.org
---------------------------------------------------------------------
To unsubscribe, e-mail: issues-unsubscribe@iceberg.apache.org
For additional commands, e-mail: issues-help@iceberg.apache.org