Presto Mismatched Domain types: date vs integer
0
I am facing this error when I am trying to query the date type column in my table select d from aggregatedb.room_nights where d = cast(current_date as date) limit 10; ERROR com.facebook.presto.spi.PrestoException: Error opening Hive split s3://oyo/room_nights/year=2018/month=11/part-00016-59e12a09-bed9-4234-88d0-098df6d926bb-c000 (offset=0, length=1446668): Mismatched Domain types: date vs integer at com.facebook.presto.hive.parquet.ParquetPageSourceFactory.createParquetPageSource(ParquetPageSourceFactory.java:220 at com.facebook.presto.hive.parquet.ParquetPageSourceFactory.createPageSource(ParquetPageSourceFactory.java:115) at com.facebook.presto.hive.HivePageSourceProvider.createHivePageSource(HivePageSourceProvider.java:160) at com.facebook.presto.hive.HivePageSourceProvider.createPageSource