presto,hive查询比较，presto缺点

presto:default> select * from mds_bhv where dt='20190319' limit 10;

Query 20190418_083902_00583_dewqj, FAILED, 1 node
Splits: 17 total, 0 done (0.00%)
0:00 [0 rows, 0B] [0 rows/s, 0B/s]

Query 20190418_083902_00583_dewqj failed: Partition location does not exist: hdfs://nn/dw/mds/mds_bhv/dt=20190319/pp

有分区show partition ;但是hdfs 文件已删；presto查询报错。

这点不如hive；hive 不会报错。