一、io.prestosql.spi.security.AccessDeniedException: Access Denied: Cannot drop table web.request_logs
这是因为在配置信息里面,没有指定hive可以删除表。(配合二使用)
hive.allow-drop-table=true
二、The transaction did not commit cleanly, Failed to execute some metastore delete operations……
1、That happens because party responsible for deleting table files from HDFS on DROP TABLE is Hive Metastore (not Presto itself). Currently Presto does not support impersonating of end user for Hive metastore connection. And HDFS operations performed on HDFS by Hive metastore are done on behalf of service user used for connecting to Metastore by Presto (hive@DC.SH.CTRIPCORP.COM in your case). And that user does not have permissions to delete this table files.
翻译如下:
这是因为在DROP TABLE中负责从HDFS中删除表文件的一方是Hive Metastore(不是Presto本身)。
目前Presto不支持冒充终端