prestodb / presto

The official home of the Presto distributed SQL query engine for big data
http://prestodb.io
Apache License 2.0
16.04k stars 5.37k forks source link

How to set kerberos when connect to hdfs in Iceberg connector Hadoop catalog #18514

Open FounderHy opened 2 years ago

FounderHy commented 2 years ago
hive.metastore.uri=xxx
connector.name=iceberg
iceberg.catalog.type=hadoop
iceberg.catalog.warehouse=xxx
iceberg.hadoop.config.resources=xxx/hadoop/core-site.xml,xxx/hadoop/hdfs-site.xml
hive.hdfs.authentication.type=KERBEROS
hive.hdfs.presto.principal=xxx
hive.hdfs.impersonation.enabled=true
hive.hdfs.presto.keytab=xxx/hadoop/hdfs.keytab

when use jdbc to connect presto and query, the server has error:

[Caused by GSSException: No valid credentials provided (Mechanism level: Failed to find any Kerberos tgt)];

prestored commented 2 years ago

@FounderHy Could you add the full stack trace ? Also are you able to connect to Hive(without Iceberg) with same kerberos mechanism?

s-akhtar-baig commented 1 year ago

@FounderHy, can you try validating the credentials by runningklist on the keytab?