openinx commented on issue #2535:
URL: https://github.com/apache/iceberg/issues/2535#issuecomment-828333492
Okay, sounds like the correct way to query external table in hive is:
```sql
SET iceberg.catalog=dlf_catalog;
SET iceberg.catalog.dlf_catalog.type=dlf;
SET
iceberg.catalog.dlf_catalog.io-impl=org.apache.iceberg.aliyun.oss.OSSFileIO;
SET iceberg.catalog.dlf_catalog.oss.endpoint=*******************************;
SET
iceberg.catalog.dlf_catalog.access.key.id=*******************************;
SET
iceberg.catalog.dlf_catalog.access.key.secret=*******************************;
SET
iceberg.catalog.dlf_catalog.catalog-impl=org.apache.iceberg.aliyun.dlf.DlfCatalog;
SET iceberg.catalog.dlf_catalog.warehouse=oss://iceberg-test/warehouse;
SET iceberg.catalog.dlf_catalog.dlf.catalog-id=*************************;
SET iceberg.catalog.dlf_catalog.dlf.endpoint=*************************;
SET iceberg.catalog.dlf_catalog.dlf.region-id=*************************;
CREATE EXTERNAL TABLE dlf_db.spark_test
STORED BY 'org.apache.iceberg.mr.hive.HiveIcebergStorageHandler'
TBLPROPERTIES ('iceberg.catalog'='dlf_catalog');
SELECT * FROM spark_test;
```
@jackye1995 , I would suggest to add a document for the hive+aws glue + aws
s3 integration work, I mean add a section to describe how to use HIVE to query
tables located in aws glue and aws s3, :-).
--
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]
