presto + hive: CLUSTERED TABLE

Question

我在HIVE中有集群表。

所有查询都在配置单元客户端中工作。

但在presto中，我不能用这个表运行任何查询：

     Query ... failed: Hive table is corrupt. 
     It is declared as being bucketed, but the files do not match the 
     bucketing declaration. 
     The number of files in the directory (0) does not match the declared 
     bucket count (8) for partition: <UNPARTITIONED>

set hive.enforce.bucketing = true; 之后

错误：

Query ... failed: Hive table is corrupt. 
It is declared as being bucketed, but the files do not match the bucketing declaration. 
Found sub-directory in bucket directory for partition: <UNPARTITIONED>

需要帮助。

Answer 1

set hive.enforce.bucketing = true确保您插入的数据放在正确的存储桶中。似乎是以前插入的数据导致了这种损坏。
您应该先将hive.enforce.bucketing设置为true，然后再将其删除并插入。