修改Presto的JVM参数,在jvm.config文件中增加以下内容: [root@cdh01 presto-etc]# vim jvm.config -Djava.security.krb5.conf=/etc/krb5.conf -Dsun.security.krb5.debug=true 3.# 查询数据 presto>select*fromhive.hivetest.tgm_test;Query20201117_011207_00003_b3d8m failed:Failedto list directory:hdfs:/...
比如HIVE和Mysql进行关联查询,那么我们就来迫不及待的揭开Presto的庐山真面目 附上: 喵了个咪的博客:w...
io.prestosql.spi.PrestoException: Failed to list directory: s3://REDACTED/REDACTED at io.prestosql.plugin.hive.util.HiveFileIterator$FileStatusIterator.processException(HiveFileIterator.java:185) at io.prestosql.plugin.hive.util.HiveFileIterator$FileStatusIterator.hasNext(HiveFileIterator.java:164) at...
presto> select * from hive.hivetest.tgm_test; Query 20201117_011207_00003_b3d8m failed: Failed to list directory:hdfs://manager93.bigdata:8020/warehouse/tablespace/managed/hive/hivetest.db/tgm_test 注意:该问题是由于远程 Ambari 集群,HDFS 路径文件没有访问权限,设置为:777权限,可以执行查询。 设想...
访问hive的时候报Failed to list directory 具体报错: com.facebook.presto.spi.PrestoException: Failed to list directory: hdfs://hzcluster/user/hive/warehouse/t2 1. 我们在presto控制台点击刚刚查询的记录 进入之后,会有详细的log com.facebook.presto.spi.PrestoException: Failed to list directory: hdfs...
#Presto component installed directory #COMPONENT_INSTALL_DIR_NAME=../presto #你的presto地址,定位到家目录 COMPONENT_INSTALL_DIR_NAME=/opt/app/presto-server-333 #为了简单,此处不开启审计功能 XAAUDIT.SOLR.ENABLE=false #虽然文档中没有提及,不设置的话,enable-presto-plugin.sh脚本执行出错 ...
[0 rows/s, 0B/s] Query 20170522_062629_00030_9y4ih failed: Failed to list directory: hdfs://apps/hive/warehouse/table1 === TECHNICAL DETAILS === [ Error message ] Failed to list directory: hdfs://apps/hive/warehouse/table1 [ Session information ] ClientSession{server=http://coordinat...
flatMap(directory -> listDirectory(fileSystem, directory, partitionColumns, depth - 1, caseSensitive).stream()) .collect(toImmutableList()); } catch (IOException e) { throw new PrestoException(HIVE_FILESYSTEM_ERROR, e); } } Example #17...
7 Connection failed due to the wrong port. 8 Connecting to the wrong service. 9 A one-time password is required. 10 No licensed bandwidth. 11 Untrusted SSL certificate. 20 Command failed. 21 Source directory does not exist. 22 Cannot access destination directory. 23 Only part of the ...
expected ='Workers must be of type list. Found <type \'unicode\'>.'\' More detailed information can be found in '\'/var/log/prestoadmin/presto-admin.log'self.assertRaisesRegexp(OSError, expected, self.run_prestoadmin,'server install /mnt/presto-admin/%...