I believe DuckDB does not respect __HIVE_DEFAULT_PARTITION__ properly. Need to test it more though.
__HIVE_DEFAULT_PARTITION__