linux - 转瞬即逝 + hive : CLUSTERED TABLE

Question

我在 HIVE 中有聚簇表。

所有查询都在 hive-client 中工作。

但是我不能用这个表运行任何查询:

     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>

在设置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。