已执行acid事务(删除/更新)的orc配置单元表无法从presto读取?

oknrviil  于 2021-06-24  发布在  Hive
关注(0)|答案(1)|浏览(619)

我在阅读pesto的文章时遇到了问题:

presto> select * from DEFAULT.MYDIM;
Error: Query 20190722_165050_00066_7g652 failed: Hive table 'default.mydim' is corrupt. Found sub-directory in bucket directory for partition: <UNPARTITIONED>

presto> SELECT * FROM DEFAULT.hello_acid;
Query 20190722_171313_00080_7g652, FAILED, 11 nodes
Splits: 16 total, 0 done (0.00%)
0:01 [0 rows, 0B] [0 rows/s, 0B/s]

Query 20190722_171313_00080_7g652 failed: Hive table 'default.hello_acid' is corrupt. Found sub-directory in bucket directory for partition: load_date=2016-03-02

我怎样才能解决这个问题?

i34xakig

i34xakig1#

presto目前不支持acid/事务表,除非它们是完全真空的https://github.com/prestosql/presto/issues/576
目前,您可以使用starburst presto 323e读取这些表。

相关问题