geoname hierarchy, parent must exist

number of errors=2
number of warnings=0
Group=chkGrpHierarchy

select parentid,childid,creationtime,createdbyuserid,type from geoname_hierarchy where not exists (select 1 from geoname where geonameid=parentid)

parentid	childid	creationtime	createdbyuserid	type	
2954692	2934558	null	null	null	
2165698	2143255	2018-04-30 22:24:47.265339	null	null