@Query("select p FROM Partner p JOIN p.partnerIdentifier")
    List<Partner> findAfterDates();

You don't need NOT NULL statement you'd just get null values if using LEFT JOIN