Presto调用system.create_empty_partition()错误

Question

环境

• 普雷斯托0.215
• 普雷托-克莱伊0.215
• presto-jdbc 0.215

由Presto创建的蜂巢表

CREATE TABLE hive.origin.test_part (
    id int,
    date_key int
)
WITH (
    format = 'ORC',
    partitioned_by = ARRAY['date_key'],
    external_location = '/user/hive/warehouse/origin.db/test_part/'
)

Presto JDBC和CLI均成功插入

分区'20190122‘之前不存在，插入成功，这意味着将tmp目录重命名为/user/hive/warehouse/origin.db/test_part/date_key=20190122成功。

​

​

hdfs中的/user/hive/warehouse/origin.db/test_part/date_key=20190122/

​

​

但是Presto调用system.create_empty_partition()失败

CALL system.create_empty_partition( schema_name => 'origin', table_name => 'test_part', partition_columns => ARRAY['date_key'], partition_values => ARRAY['20190121'])

​

​

全错误信息

com.facebook.presto.spi.PrestoException: Failed to rename hdfs://datacenter1:8020/tmp/presto-hive/b87162e5-9e48-4d43-a0e7-ecf0994fe625/date_key=20190121 to hdfs://datacenter1:8020/user/hive/warehouse/origin.db/test_part/date_key=20190121: rename returned false
    at com.facebook.presto.hive.metastore.SemiTransactionalHiveMetastore.renameDirectory(SemiTransactionalHiveMetastore.java:1787)
    at com.facebook.presto.hive.metastore.SemiTransactionalHiveMetastore.access$2700(SemiTransactionalHiveMetastore.java:87)
    at com.facebook.presto.hive.metastore.SemiTransactionalHiveMetastore$Committer.prepareAddPartition(SemiTransactionalHiveMetastore.java:1177)
    at com.facebook.presto.hive.metastore.SemiTransactionalHiveMetastore$Committer.access$700(SemiTransactionalHiveMetastore.java:957)
    at com.facebook.presto.hive.metastore.SemiTransactionalHiveMetastore.commitShared(SemiTransactionalHiveMetastore.java:885)
    at com.facebook.presto.hive.metastore.SemiTransactionalHiveMetastore.commit(SemiTransactionalHiveMetastore.java:807)
    at com.facebook.presto.hive.HiveMetadata.commit(HiveMetadata.java:1949)
    at com.facebook.presto.hive.CreateEmptyPartitionProcedure.createEmptyPartition(CreateEmptyPartitionProcedure.java:126)
    at java.lang.invoke.MethodHandle.invokeWithArguments(MethodHandle.java:627)
    at java.lang.invoke.MethodHandle.invokeWithArguments(MethodHandle.java:649)
    at com.facebook.presto.execution.CallTask.execute(CallTask.java:160)
    at com.facebook.presto.execution.CallTask.execute(CallTask.java:60)
    at com.facebook.presto.execution.DataDefinitionExecution.start(DataDefinitionExecution.java:168)
    at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1149)
    at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:624)
    at java.lang.Thread.run(Thread.java:748)

hdfs中的/tmp/presto-hive/

​

​

所以

调用system.create_empty_partition()使用不同的“用户”操作hdfs？

Answer 1

这是由于错误阻止它处理非桶形表而导致的失败。它在301发行版中得到了修正。