TangYan-1 edited a comment on issue #2927:
URL: https://github.com/apache/iceberg/issues/2927#issuecomment-893932685
@pvary Thanks, I'll check in presto side. Here I have two more issues about
iceberg.
1. For set iceberg.mr.catalog=hive, how can I unset it in hive session?
Seems when I set it to hive, the iceberg overlay table in hive can't be queried
any more.
2. NULLpointer exception in beeline agg query for the hadoop catalog iceberg
tables.
1). create table using spark job and load data
spark3-shell --jars iceberg-spark3-runtime-0.11.1.jar \
--conf
spark.sql.catalog.hadoop_catalog=org.apache.iceberg.spark.SparkCatalog \
--conf spark.sql.catalog.hadoop_catalog.type=hadoop \
--conf spark.sql.catalog.hadoop_catalog.warehouse=/iceberg/warehouse
spark.sql("CREATE TABLE hadoop_catalog.testdb.iceberg_table_in_hdfs (report
string ,reporttime string,reporttype string, reportid string , reportversion
bigint, day string ) USING iceberg PARTITIONED BY (day)")
2). create overlay in hive beeline
CREATE EXTERNAL TABLE testdb.iceberg_table_in_hdfs (report string
,reporttime string,reporttype string, reportid string , reportversion bigint,
day string )
STORED BY 'org.apache.iceberg.mr.hive.HiveIcebergStorageHandler'
LOCATION '/iceberg/warehouse/testdb/iceberg_table_in_hdfs'
TBLPROPERTIES (
'iceberg.mr.catalog'='hadoop',
'iceberg.mr.catalog.hadoop.warehouse.location'='/iceberg/warehouse');
3) . query from hive beeline (select count(*) from
testdb.iceberg_table_in_hdfs)
Error: java.io.IOException: java.lang.NullPointerException at
org.apache.hadoop.hive.io.HiveIOExceptionHandlerChain.handleRecordReaderCreationException(HiveIOExceptionHandlerChain.java:97)
--
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]
