Trino连接配置了kerberos的hive

配置 hive.properties

hive.metastore.authentication.type				kerberos
hive.metastore.thrift.impersonation.enabled     false
hive.metastore.service.principal                hive/datasophon01@HADOOP.COM
hive.metastore.client.principal                 hive/datasophon01@HADOOP.COM
hive.metastore.client.keytab					/etc/security/keytab/hive.service.keytab
hive.hdfs.authentication.type					KERBEROS
hive.hdfs.impersonation.enabled					false
hive.hdfs.trino.principal						hive/datasophon01@HADOOP.COM
hive.hdfs.trino.keytab							/etc/security/keytab/hive.service.keytab

查询hive 提示Query failed (#20230928_021915_00043_fqy4j): Unable to create input format org.apache.hudi.hadoop.HoodieParquetInputFormat java.lang.ClassNotFoundException: Class org.apache.hudi.hadoop.HoodieParquetInputFormat not found


将hudi-trino-bundle-0.12.0.jar 添加至/opt/datasophon/trino-367/plugin/hive目录 重启trino即可

trino官网：https://trino.io/docs/current/sql.html

常用查询：

SHOW CATALOGS

show schemas from hive;

show tables  from hive.database;

select * from hive.datasophon.table

使用trino和hive查询数据量不一致：

set hive.input.format=org.apache.hadoop.hive.ql.io.HiveInputFormat;

 最近在找工作大佬们有合适的内推我一下 致以最崇高的敬意 微信：CallMeFlink