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 2021/03/23 03:28:41 UTC
[GitHub] [iceberg] junsionzhang commented on issue #2357: hive cannot get data from iceberg table
junsionzhang commented on issue #2357:
URL: https://github.com/apache/iceberg/issues/2357#issuecomment-804577577
> @junsionzhang:
>
> * Is the catalog type set correctly? Could you please run `set iceberg.mr.catalog`?
> * What is the output of the `DESCRIBE FORMATTED sample` from Hive?
>
> Thanks,
> Peter
1) "set iceberg.mr.catalog=true;" works fine in hive
2) the `DESCRIBE FORMATTED sample` result is as follow
Database: iceberg
Owner: root
CreateTime: Mon Mar 22 18:08:46 CST 2021
LastAccessTime: Sun Jan 18 16:40:22 CST 1970
Retention: 2147483647
Location: hdfs://192.168.100.101:9000/hive/warehouse/iceberg/iceberg.db/sample
Table Type: EXTERNAL_TABLE
Table Parameters:
EXTERNAL TRUE
metadata_location hdfs://192.168.100.101:9000/hive/warehouse/iceberg/iceberg.db/sample/metadata/00002-f60f3416-680e-41cc-9a85-ec11dd4b9642.metadata.json
numFiles 1
previous_metadata_location hdfs://192.168.100.101:9000/hive/warehouse/iceberg/iceberg.db/sample/metadata/00001-b50a0569-05c9-4655-9db8-0eed6fa5f866.metadata.json
table_type ICEBERG
totalSize 826
transient_lastDdlTime 1616407726
# Storage Information
SerDe Library: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
InputFormat: org.apache.hadoop.mapred.FileInputFormat
OutputFormat: org.apache.hadoop.mapred.FileOutputFormat
Compressed: No
Num Buckets: 0
Bucket Columns: []
Sort Columns: []
Time taken: 0.648 seconds, Fetched: 30 row(s)
--
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